Error UNV0023 - Parse Failed: Invalid Definition (UNV0023)

Parse Failed: Invalid Definition (UNV0023)


Environment BI 4 SP 8

We are working with Universe Design Tool  on universes
 that require the same tables so after inserting the tables in one universe and creating classes/objects/meta data, we copied the same classes and objects into other universes as the tables are  the same.
But when we  parse the objects in the table after copying we got  following error: Parse Failed:Invalid definition (UNV0023). 
The only way to solve the problem was to go into each object and copy, delete and then past the table object name.

So the advise  that in similar cases is:
 first  you have  to add the tables 
and then you can add relative objects and  not viceversa!



2nd case

We got the error  in another case

For an object with the following select:

CASE WHEN @Select(PromptList\....) IN @Prompt('Code:','N','PromptList\CatCode',multi,constrained)
THEN @Select(PromptLis\generic)
ELSE (SELECT LTRIM(MAX(SYS_CONNECT_BY_PATH(LISTA,', ')) KEEP (DENSE_RANK LAST ORDER BY curr),', ')    
      FROM (SELECT  DESC_CA AS LIST
                           ,ROW_NUMBER() OVER (ORDER BY 1) curr
                           ,ROW_NUMBER() OVER (ORDER BY 1) -1 prev
            FROM  CAT_DESC
            WHERE CODE_CAT IN @Prompt('Code:','N','PromptList\CatCode',multi,constrained)
          )
      CONNECT BY prev = PRIOR curr
      START WITH curr = 1
     )

END

The error was due to CatCode witch has been changed in CatC 
and so we forgot to change it in the string @Prompt('Code:','N','PromptList\CatCode',multi,constrained).


See also

http://businessobjectsbi4.blogspot.it/2013/09/sap-bi-40-errors-list.html

Comments

Post a Comment

Popular posts from this blog

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

SAP HANA Introduction

SAP BusinessObjects 4.0 - Suite Presentation