Business Intelligence with SAP Business Objects 4.3

Webi Error XI 4.1  - Your security profile does not include permission to edit this documents (WIS 30252) Symptom Below mentioned mentioned error message is displayed while performing drill in a Web Intelligence(WebI) report by non-Administrator user: "Your security profile does not include permission to edit this documents (WIS 30252)". Environment SAP Business Objects XI 4.1 SP 4 - two node cluster Windows Server 2012 R2 Database  Teradata 14 Reproducing the Issue 1.  Login to WebI Rich client/BILaunchPad using Administrator account and create a new Webi report on a universe. 2.  In the query panel select a dimension and a measure. 3.  Save report to the repository. 4.  Enable "Drill" in the report. Administrator is able to successfully perform drill in the report. 5.  Logout and login to BIlaunchPad using Non-Administrator user and open the same report in View mode. 6.  Try to perform Drill in the repor...

Information Design Tool - Problem on opening a session as designer user not administrator  Environment IDT 4.1 SP 5  - 2 nodes  Cluster  Windows 2012 R2   Our customer has a problem while opening session on Information Design Tool loggin on with a not administator  user. We found the solution on SAP Knoledge base in the following note. 1916649 - Information Design Tool session terminated right after login for certain users https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3139313636343926 Reproducing the Issue In the CMC deny the "View Objects" and "View objects that the user owns" access level on "UserA" 's Inbox Log in IDT using "UserA" Notice that the session is terminated and an error message might appear Cause The user has not been granted right access into its BI Inbox Solution Make sure the users have view ...

 Cannot initialize Report Engine Server. (Error:RWI 00226) (Error:INF) Environment BO XI R3.1 SP 4 Windows Server 2008 R2  sp1  While rescheduling a Webi report one of our users experienced the error in exam. Solution: In our case we just restared WebIntelligence group servers: See also: SAP BI 4.0 Errors List XI R 3.1 errors solutions

 Scheduling reports error -  source file error. [Invalid argument]: [CrystalEnterprise.DiskUnmanaged]  Environment SAP BI 4 SP8  The BI 4 server is not in windows domain  but SIA service is runned by a domain user As suggested in other B.O. forum we perfomed the following steps: in CMC,  the Job Server  must use a NETWORK SERVICE user that has all the permissions to read/write, that run's as a service, log on as service account etc. ( admin user) ; user has full read/write access to the folders.  we are following  the UNC naming conventions while specifying the folder name including the sub-directories. So when we scheduled reports in order to create acrobat files on a network folder such as \\ServerName\Path  directories. the scheduled istance Fails  and raises the error source file error. [Invalid argument]: [CrystalEnterprise.DiskUnmanaged]  Solution: In our case we decide to...

Maximum binary output size limit reached (ERR_WIS_30271) Environment SAP BI 4 SP 8 While exporting a huge  Web Intelligence report in Excel format BO raised the error: Max Binary file size limit exceeded. The document is too large to be processed by the server. Error WIS 30271  Cause This error message appears because BusinessObjects Enterprise allows documents to be saved with the limit specified for Web Intelligence Report server settings in the Central Management Console(CMC). To resolve the error follow the below steps: - Login to Central Management Console (CMC) using BusinessObjects Enterprise "Administrator". - Navigate to "Home >> Servers". - Click on "WebIntelligenceProcessingServer" to open its properties. Increase: Maximum Character Stream Size (MB) which specifies the maximum character stream size sent to the Web Intelligence client. Default value is 5. The valid range is 1 to 65535 MB. Bin...

Error: WIS 00504  Message: You do not have the rights to access data returned by this universe. See your business objects administrator  Non si dispone dei diritti di accesso ai dati restituiti da questo universo. (WIS 00504) Environment SA BI 4.0 SP 8 In order to solve this issue on refreshing a WebI  report check  user permissions at user/folder/object level Check   the access rights for all the universes and universe connections in this case for assigning rights to the user for Universe and connections, Login to CMC and go to Universes.  Select the universe which you are using,right click and select user security,check if your user has rights on that universe if not then use Add principals and assign rights to the user you are using.  Then go to Connections in CMC and select the connection which your universe is using and follow the same thing as done for Universes.  Moreover  on the rights tab and for ...

Invalid Prompt definition. See your Business Objects administrator. (Error: WIS 00005) Environment BI  4 SP 8 Cause The syntax in the prompt is not valid, or the prompt makes reference to an object that no longer exists in the universe. Action The universe designer can verify that the prompt syntax is correct, and check that all objects referenced in the prompt exist.

 WebI Rich Client XI R3.1 Environment XI R3.1 SP 4 When we try to open an imported reports  in Webi Rich Client, BO raises the following Error Code WIJ 20002 Error Workaround: Log in  Web Intelligence Rich Client. Go to Tools > Options Go to Locale (tab) and set "Interface locale" and "Formatting locale" to English (United States) > OK. Open a report in Web Intelligence Rich Client it runs ! See Also XI R 3.1 errors solutions

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(P...

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...

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 Limi...

Err_WIS_30270 While exporting in Excel a report Webi Environment XI R3.1 SP 4 This problem happened to an user which received a report WebI in the In box  when she tried to export it in xls format. Resolution We edited the advanced rights on favorite folder of this user as the rights to export in csv, pdf and xls were not specified and then in her case not allowed! So we granted them under WebI Report Content  as you can see in the following figure!

WIS 10901 - Webi Rich Client error - DB Driver failed to load Environment BO XI R 3.1 SP4 This error occurred opening a LOV on refreshing a Rich client report. Solution If you're logging into rich client in 2-tier mode (system name with computer icon) then the TNSNAMES.ora will be picked from local machine( in this case you must have an Oracle client installation and an up to date Tnsnames) Instead when using 3-tier (system name with world icon) then the TNSNAMES.ora will be picked from the BOBJ server  So the server may not be configured properly if the latter option is used  This rule has to be applied on a DeskI application setup  Error wis-10901 database error occured Business Objects errors

 CMS system database is overloaded, please try again. If the problem persists, please contact the system administrator  Environment BO XI R 3.1 SP4 Please follow these steps 1. Check the database connectivity  2. Check the Logfile(s)   If everything is right, restart the SIA agent. This issue usually indicates problem with CMS database and this might also occur if CMS table entry is corrupted.

Connection or SQL sentence error. (DA0005) Cause Connection Server can generate a connection or SQL sentence error after the date format has been changed in the relevant .sbo file. This can occur if the format set in the .sbo file does not agree with that set in the database. Action Verify that the Oracle NLS_DATE_FORMAT parameter is set to the date format that you have set in the data access .sbo file. Check your Oracle documentation for more information. See the "Data Access Guide" for information on parameters defined in the .sbo files, and how to modify them. Cause Your Oracle data access drivers have been moved, deleted, renamed, or damaged. Action Re-install the Oracle data access driver

An error has occurred: Unable to reconnect to the CMS.  The session has been logged off or has expired. (FWM 01002) Environment BO XI R 3.1 SP 4 In order to solve this issue we found a  SAP released note 1422296  1422296 - Error:' Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' with BusinessObjects XI 3.1. Symptom Not able to schedule WebIntelligence reports. Reports fail with error:'Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' Environment BusinessObjects XI 3.1. Reproducing the Issue Schedule a WebIntelligence report to run now. Reports fails with error:u2018Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' Resolution 1. From Central Configuration Manager, disable all the services and re-enable them. 2. Log into Central Management Console and go to the server area. 3. Go to the properties of Central Man...

Error RFC 00101 -  No server was available to process the request. Please try again later. ( Error RFC 00101 ) (Error: INF ) Environment BO XI R 3.1 SP4 This error often happens during the peak business hours while scheduling WebI reports. In our case we solved the problem  increasing the Maximum connection perameter in WebIntelligenceProcessingServer on CMS. The  default value is 50 connections per one WebI Processing Server.  The best way is to create the new webi processing server from the CMS. In case of DeskI reports: Following solution might be helpful in resolving the issue. To resolve the error message Log on to the Central Management Console as administrator. Click Servers > Desktop Intelligence Report Server. Increase the following time-out parameters to at least twice the current value: Minutes before Idle connection is closed Minutes before an idle report job is closed Moreover if this solution does not work for you, you c...

#DATATYPE ERROR Environment:  WebI  BO XI R3.1 SP 4  You got thi error when you are using a wrong data type .  For example if  your data is numerical but it is throwing char or date then Business Objects will  expose this error. Often it  happens, when you mix string and number or string and date/time data types.   If these data types are mixed, the function returns a string. As Date/time and number data types cannot be mixed  the results is a #DATATYPE error. Solution: In Webi  you must create a variable in which you have to convert and cast the data types in order to make them all homogeneous as datatype. Check also: Business Objects errors list

 An internal error occured while calling 'getMap' API. (Error : ERR_WIS_30270). Environment BOE XI R3.1 SP 4 This is a generic error message,  in our case we had this error while we were applying  some changes to an old WebIntelligence report. By searching through SAP notes there are about 100's of notes on this error. The problems can range from bugs (as also stated in this thread) to configuration issues with universe to report design.  IF you are unable to resolve with the latest patch then open a case with the SAP BO. Solution In our case we saved the report we re-open it and we made some changes in the query pane and after this it was refreshed correctly. Other case: Considering four web intelligence reports, among these, for one report when i click on refresh list of values of a prompt i am getting the error  "An internal error occored while calling process DPCommands API (Error: ERR_WIS_30270) (Error.INF).  In order ...

Internal error  [ RCIRAS0216 ] (Error: INF ) Please contact your system administrator. Environment BOE XI 3.1 Deski report with Zabo  on Windows 2008 R2  Case: We had this exception after changing from Zabo a Deski option on saving the report, we checked the option 'Refresh on opening' the report. After exporting in the CMS the report on opening it we had the above exception Solution We imported the report on Deski,  choosig the BO system with  (J2EE Portal) ,  we save it  again by checking the option 'Refresh on opening'  and we re-exported it. After this the issue was resolved. See also: Errors list - Solutions