This article talks about some of the fixes and SAP BOBJ Troubleshooting tips and steps applied for common issues. It covers some common issues and bugs faced by the client and how these can be fixed. Please refer to a section further to find about details of the issue and the fixes we applied for the below issues:
Though these fixes are applied for BOBJ 4.2 SPS6, but it should be valid on higher and slightly lower versions as well. Please read more to find out.
Check for the error from the server when the connection does not connect
It was found that environment variables are missing as mentioned in KBA 2054721
The error “WIS 10901” and / or “IES 10901”, which is seen when refreshing or scheduling Web Intelligence reports, is a result of the Web Intelligence Processing Server indicating that the reporting database has returned a warning or error message.
The additional text and information returned with this error should provide a general idea on the issue. Frequent causes are:
We added the environment variable as below
Manually added the X86 variable in the new server
Check that the all files and folders exported are not able to get exported
Ideally only the specific folder and its corresponding associated folder should be exported but with this error system tries to extract the entire universe and multiples it so it becomes a complicated structure.
If you notice all folders and Dashboards gets exported. We tried to uncheck the manage dependencies using “Manage dependencies” Option. However, before transporting the objects as it was wrongly linked to all objects and it this was getting all the dependent objects example Reports along with connection and universe.
All universe and folders seem to have been extracted. Multiple different errors were reported.When you click on export for first time below error comes “Sorry Promotion Management application is unable to process your request”
2nd time error: “Server encountered an internal error that prevented from fulfilling the request”
I found one note which talks about the same issue
2054164 – Promotion Management Job Failed with Error “CE SDK Exception occurred (FWM 04002)”
https://launchpad.support.sap.com/#/notes/2054164
In Promotion Management, when promoting a job, some reports are promoted successfully, some reports failed to be promoted. Destination system’s Job Server logs record the following error message:
ImportFailedcom.businessobjects.sdk.biar.BIARException$SDKException: CE SDK Exception occurred : ‘Could not open the file C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\FileStore\Input\a_100\025\000\6500\~ce298878651ad08f3-xguid[ayzwtr3xcfhgvfb7gy0xnuw]-xguid[ayrdeyhjk5zfvp_fssq6kdi]-xguid[addxhzuqgb5ajssrfodtrza]-guid[cbf10de2-3f98-48b5-90c1-b90f112e8205d].wid.’ (FWM 04002)
Job promotion failed due to: com.businessobjects.lcm.utilities.LCMException: com.businessobjects.lcm.utilities.LCMException: com.businessobjects.sdk.biar.BIARException$SDKException: CE SDK Exception occurred : ‘Could not open the file C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\FileStore\Input\a_100\025\000\6500\~ce298878651ad08f3-xguid[ayzwtr3xcfhgvfb7gy0xnuw]-xguid[ayrdeyhjk5zfvp_fssq6kdi]-xguid[addxhzuqgb5ajssrfodtrza]-guid[cbf10de2-3f98-48b5-90c1-b90f112e8205d].wid.’ (FWM 04002)
The failed report(s) may show up in the destination CMC, but viewing the report results in the following error message:
The document cannot be retrieved from the File Repository Server (WIS 30951). Following the file path in the FRS, the report does not exist on the file system
In Windows, the file path length has a limitation of 255 characters. If the report’s file path in the FRS is longer than the limit, the BI Platform will not be able to read it.
The root cause of this issue is:
In BI Platform there’s a feature called “Hot Backup”. You can find the details in the BI Platform Administrator Guide. This feature injects a parameter into the report file path due to potential existence of several files, for example•
When the report was first created, the file path is similar to: frs://Input/a_086/031/000/8022/109c80f5d75efcc.rpt
After a promotion from one system to another, the Hot Backup feature adds the -guid parameter to the file path: frs://Input/a_054/029/000/7478/109c80f5d75efcc-guid[aqvs6pvpgfpiifitbpmk6ns].rpt if the report is promoted through multiple systems, it will have multiple -guid parameter added to its file path. Eventually it gets longer than the limit.
Resolution
In order to successfully promote those failed report(s), you should:
So we opened the dashboard again and saved them in a new path and then tried to export them and the job completed successfully to export the data out.
Move the default filestore location to another place which has a shorter path. By default the filestore is located under (C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\FileStore), it already has 90 characters in it. You can move it to the root of your disk drive (e.g. C:\filestore) to allow more space for the report file names. Please refer to KBA 1910348 for the step-by-step instructions on how to move the filestore.
We advised client to follow the best practice to use Promotion Management. If you have 3 BI Platform system, DEV, QA, and PROD:
By doing so, the report filename will get modified at most once, so it is less likely that the file name will go over the limit
When trying to connect to the designer got an error which says “The specified DSN contains an Architecture mismatch between the driver and Application”
Fix applied for the above issue had the below steps we followed:
FTP issue was reported when the reports were being scheduled.
Error message said: “The document serialization version is too recent Error WIS 30915”
We have added FTP server as below to fix the issue as it was not enabled
This setting would enable FTP and then you could schedule your report.
Scheduling the publication was not working as the user tried to schedule the publication but it did not work and went to status Pending or Failed.
If you are not able to schedule the publication then you may need to check your email settings, Go to Destination and save your SMTP settings
Status now shows as success after the fix was implemented.
Below error when clicked on Web intelligence
Below error are reported as seen below: Web intelligence applet cannot be loaded please make sure you have installed a Java virtual Machine
As mentioned in note 2536934 Microsoft Edge do not (and will not) support any plugin (Flash, Java Applet,…). Same as Chrome. And Firefox will follow the same path.
Hence we can see error when using chrome or any other browser other than IE.
Excerpts from the note added below
https://launchpad.support.sap.com/#/notes/2536934
Issue details: After log in cursor should be on Reports Folder and all system folders should be invisible for normal users, now it is on home tab. (snapshot is attach)
Maintain preference setting as seen below
Please change preferences to launch the report section as per the need below is where you can maintain setting.
”If you need to maintain this for all users go to Users and Groups and right click on the specific user group or user and go to “BI Launch Pad Preferences”
Select specific folder you would like to add as a default home page view.
This sets the home page setting for the users.
Below error reported when trying to save in favourites folder again it gave a similar error as before
“Document serialization version is too recent……..”
Fix the issue by following the below steps in the note:
2076988 – Error: The document’s serialization version is too recent (Error: WIS 30915) while saving a webi report with webi rich client. Excerpts from the note as below
https://launchpad.support.sap.com/#/notes/2076988
In summary, most of the settings you can control via CMC or BI console. There are notes which you can find in the marketplace that lists the limitation if the issue can not get solve. If you setup a new system be careful to apply the environment variables correctly depending on the system BOBJ connects with.
Hope this article explains SAP BOBJ Troubleshooting tips was useful to help in fixing some common errors you face during the implementation and support of SAP BOBJ product.
Thanks for reading the article
To know more about our SAP service offering
https://peritossolutions.com/services/sap-consulting/
Get in touch if you have a business inquiry;