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.
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
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
SAP Business Objects training in Bangalore
ReplyDeletecode works .Keep updating Cognos TM1 online training Bangalore
ReplyDelete