Posts

Showing posts from December, 2013

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(MA

BI 4 Error - Index is not ready. Please try again later (PSS 01004)

Index is not ready. Please try again later (PSS 01004) Environment BI 4.0 SP 8 When we tried to find a document name in the search field the error above has been raised. Resolution Go to CMC->Application-> Right Click 'Platform Search Application'->Properties Go down in the page and select the option "Rebuild Index" , save and close. Let the index rebuild  and Restart the SIA Check also the SAP NOTE http://service.sap.com/sap/support/notes/1634413 See also BI 4.0 errors list

BI 4 Error - QTJ 00519 Refecence @select could not be resolved

After migrating an Universe from XI R3.1 SP 4 to BI 4 SP 8 and converting it in UNX format for a filter object the following error was erased  Riferimenti non risolti:  : @Select(OGGETTI SPECIALI\Cod Anno) it missed the root folder of the object Riferimenti non risolti:  :  @Select( ORDERS \OGGETTI SPECIALI\Cod Anno) so the solution was to replace the first string with the second! See also Sap BI 4.0 errors list

Information Design Tool - How to create a Native filter

Image
How to create a object filter in Information Design Tool Go in th Business Layer an click on insert object button selecting filter object Assign it a name flag the check 'Native' filter select it as Active object and select the where condition in SQL Assistant (check the prompt syntax on the bottom of image behind) Properties See also Bublish unx universe from IDT

Error WIS 10901 - A database error occured. The database error text is: (CS) "DBDriver failed to load : C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32x_x86\dataAccess\connectionServer\dbd_oci.dll (The specified module could not be found)

WebI Error WIS 10901 A database error occured. The database error text is: (CS) "DBDriver failed to load : C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32x_x86\dataAccess\connectionServer\dbd_oci.dll (The specified module could not be found) Environment BO XI 3.1 SP 4 We get this error when  to create a  Rich Client  report from a user's machine, against a universe with a connection to an oracle database . Solution This usually due to  incorrect ODBC configuration so in order to solve this issue try the following steps: 1.      Stop all the services from BO Central configuration Manager. 2.      Open odbc.sbo file located at "Program Files\Business Objects\BusinessObjects Enterprise    11.5\win32_x86\dataAccess\connectionServer\odbc" 3.     Go to parameter setting for "Generic ODBC datasource ". 4.     Change the value of "Transactional Available" parameter to No. 5.     Add this new parameter settin

Error ERR_WIS_30285 -The Web Intelligent server is running out of memory, your document has been closed. If the problem persists, contact your BusinessObjects administrator. (Error ERR_WIS_30285) while refreshing a large Webi report.

Error ERR_WIS_30285 -The Web Intelligent server is running out of memory, your document has been closed. If the problem persists, contact your BusinessObjects administrator. (Error ERR_WIS_30285)  while refreshing a large Webi report. Envirnonement BO XI R3.1 SP 4 This error was erased while scheduling or refreshing  a large Webi report. The cause is connections  timed out. Resolution File Repository Servers:- Input Server: Maximum Idle Time : 60 Minutes (CMC-->servers-->Input File Repository Server)                                                 Output Server: Maximum Idle Time : 60 Minutes (CMC-->servers-->Output File Repository Server) Universe - Timeout parameter limit in the Universe - set this in Designer Open the designer > import the universe. Click File > Parameters, select the controls tab, increase the Limit execution time to 60 minutes. WebIntelligenceProcessingServer Connection Timeout - This is set in the CMC > Servers > WebInte