This page is part of the...
This Wiki is for documenting known issues and solutions for the SAP BusinessObjects Intelligence Platform BI 4.0 SP04 or higher Full or patch Installations. Originally this page was focused on SP04 updates, but this information is now considered applicable to all Service Packs 4 or higher.
These are the best practices for all Support Pack and Patch installations:
- Use the Update Installer when upgrading from BI Platform SP02 to SP04.
- Read the Support and Feature Pack Release Notes.
- Turn off all servers except the most essential servers:
- Content Management System (CMS)
- File Repository Servers (FRS)
- Tomcat and the CMS Database (if applicable)
Use the Process Explorer or Windows Task Manager to ensure that all non-essential processes are terminated after stopping them. The java.exe processes located in the Business Objects directory should be terminated. (The process paths can be viewed under the Command Line column of the Processes tab for Windows Task Manager).
Note: If the Java processes associated with the BI Platform are not terminated, they may lock up files, causing them to be updated or deleted. These file changes can cause issues with missing libraries. This issue is a Java Virtual Machine (JVM) issue that is scheduled to be fixed in BI Platform Support Pack 05 (SP05).
The administrator would need to terminate the selected process in the image if it was still in memory after stopping the non-essential services.
The above information on best practices is available as SAP kbase 1757132 - BI4 Support Pack Upgrade and Patch Install Best Practice Guide
Additional Best Practices for Clustered or Distributed Environments
These are best practices for clustered or distributed environments:
- First, update the CMS servers before moving onto other tiers.
- Run the Update Installer on one server at a time. If you run the Update Installer simultaneously on multiple servers, you may cause a race condition which will result in missing metadata.
Note: Symptoms of a failed simultaneous install include:
i. You see several files in the .../setup/packagestemp folder.
ii. You see in the install logs (setupengine.log) that CMS tried to log in but failed consistently.
The above information on best practices is available as an SAP kbase 1757132 – BI4 Support Pack Upgrade and Patch Install Best Practice Guide.
Issue 1: Services do not start because of missing .jar files
The issue was observed when performing a failed patch upgrade from BI 4.0 SP02 Patch 12 to BI 4.0 SP04 on Windows. This issue is typically caused by the Report Application Server (RAS) performing processing while the update is running which causes it to fail to shut down one of its java child processes when requested. The processing results in a number of locked files while the patch is performed which results in missing binaries when the patch has completed. The problem can be avoided by following the Best Practices section above.
- The following processes fail to start after applying the patch:
- Adaptive Processing Server (APS)
- Crystal Cache
- Xcelsius Cache
- The behavior remains the same despite recreating processes and the Server Intelligence Agent(SIA), and repairing/installing SP04.
- Uninstalling only SP04 results in an SP04 patch 12 server.
- Missing files/libraries
- Ensure that all non-essential services are stopped.
- Run a repair on the base BI platform 4.0 installation by clicking on Control Panel > Programs > Programs and Features > SAP Business objects BI Platform 4.0 > Uninstall/Change > Repair
- (Optional) To detect issues with missing files or libraries:
- Check the .../InstallData/logs/<install_timestamp> folder.
- Ensure there are only 3 files in the folder (InstallManifest.sqlite, setupexe.log and setupengine.log.
- If you see other log files such as InstallDU-*.log (e.g., InstallDU-cvom.java-4.0-core-nu, 184.108.40.2068, etc), then some files or libraries have not been installed properly.
Issue 2: 32-bit paths replace 64-bit paths
This issue was observed after applying an SP04 patch upgrade or installation. In one case this issue occurred with SP04 Patch 17 but it is most common with SP04.
- The AdaptiveProcessingServer does not start.
- This symptom can be observed on the CMC Server's page.
- The AdaptiveJobServer doe snot spawn any child processes:
- On the CMC Server’s page, the AJS has started but it does not begin any child processes as it is supposed to.
- No schedules run because the server is not available to begin new jobs.
- Install logs may show issues upgrading these servers.
Stop all services except the CMS, and Input and Output FRS prior to a BI4.0 upgrade. This prevents a service from affecting the install when not stopped all the way.
Note: If non-essential services are not manually stopped before applying SP04, certain java services may fail to upgrade.
The above information is available as an SAP kbase 1742498 – Scheduling workflow(s) affected after installing SP4 for BusinessObjects Enterprise 4.0.
Issue 3: CMS cannot restart after installation
This issue was observed with SP04 installs and previous patch versions. The most likely cause of the CMS not starting is the file locking problem triggered by RAS as noted in Issue 1. This is the usual trigger in SP04, but there are other possible root causes.
- Install fails with errors.
- Some processes cannot be started or stay disabled.
- Applications like BI Launchpad and CMC may fail unexpectedly although they were redeployed properly.
Setup log (setupengine.log) indicates that the installer was unable to connect to the CMS due to its inability to restart in time. Log entries as below or similar can be noticed:
Server <servername> not found or server may be down or
com.crystaldecisions.sdk.occa.security.in ternal.LogonService||Is the CMS alive? Ensure the CMS supports SDK version 1400
[InstallEntDfoWrapper.Connect] Connection Failed. Please retry...
10:46:30.572 [InstallEntDfoWrapper.main] Connection Failed. Could not connect to CMS [SERVERNAME:6400]
Note: The reasons for the CMS being unable to restart may vary from environmental-related (resources, virus, etc) to network-related, because this is not a common issue.
Before upgrading or repairing, follow the "Best Practices" section above.
- Ensure that all non-essential services are stopped as explained in the best practices.
- Run a Repair on the BASE BI 4.0 Install by going to Control Panel > Programs > Programs and Features . SAP Business Objects BI Platform 4.0 > Uninstall/Change > REPAIR.
- (Optional) Uninstall, then install a refreshed SP04 full build.
- After the install, re-run the script to import the missing modules.
The above information is available as an SAP kbase 1603067 - java.lang.NullPointerException or usagesProperty error after login to CMC or BI Launchpad.
Issue 4: SP04 Patch Install does not install correct files
There are incorrectly versioned DFO files which cause them to fail to upload during the installation. If there are more files in the folder than the set listed above, it may indicate the same problem as in Issue 1 and Issue 3, where the CMS has failed to start.
- When upgrading an existing BI4 system with the Installer, the Installer may not install all files.
- While the setup logs indicate a successful install, files are left in the .../setup/packagestemp folder e.g., "C:\Program Files(x86)\SAP BusinessObjects\setup\packagestemp" on a default windows platform installation.
Some of the files listed under the .../setup/packagestemp folder folder may look like:
- This issue was tracked as ADAPT01628046 and resolved in SP04 Patch1 which is available in SMP patch downloads.
- This and other fixes & improvements can be validated in the Release notes document at http://service.sap.com/~sapidb/011000358700000813222012E.
- BI4.0 SP04 Patch release notes are available at: 1729424.
Issue 5: HTTP 500 Error on CMC and BI Launchpad after installation
An HTTP 500 error was noticed in a web-tier deployment. This may not always happen. Another patch or add-on may turn off Tomcat while it is compiling the web applications that have been deployed to it, leaving the compiled folder in an inconsistent state.
- After updating or patching SP04 you see the following error when accessing BI Launchpad or CMC:
Error: “Java.lang.NullPointer Exception”
- This is an application server issue, not an installer issue.
The resolution and above information is available as an SAP kbase 1671068 - CMC in SAP BusinessObjects BI 4.0 returns a 500 error.
Issue 6: Renaming SIA Node causes SP2 updates to FP3 or SP4 to fail
The installer uses the node name from the original install, causing a failure to upload the newly named node.
- In an update to SP4 (but not FP3), the installer will alert you on the final screen that the installer encountered errors.
- If you perform a modified install after the original install to add RESTful Web Services, you will find that RESTful Web Services does not appear as a service.
- Dashboard Analytics Server and Dashboard Server will show as “failed to start” on the CMC Server management page. The services themselves have been moved.
If you have renamed the original node, you can run a repair installation and name the new node to get a fixed system.
- To resolve this issue, you need to run a repair install from the command line, using the setup.exe located in your installation folder:
- For BI platform (on UNIX platforms, substitute setup.sh for setup.exe):
<INSTALLDIR>\setup.exe -i product.businessobjects64-4.0-core-32 SIAName=<NEW SIA NAME>
- For Information Platform Services:
<INSTALLDIR>\setup.exe -i product.minibip-4.0-core-32 SIAName=<NEW SIA NAME>
- For Crystal Server:
<INSTALLDIR>\setup.exe -i product. crystalserver2011-4.0-core-32 SIAName=<NEW SIA NAME>
- For BI platform (on UNIX platforms, substitute setup.sh for setup.exe):
- Follow the instructions below, where MasterCmsName and MasterCmsPort are your CMS name and port, CMSPassword is your Administrator account's password, and SIAName is the name of your additional node:
- Shut down the node being updated. Unless the MasterCms is on the node being updated, the node running MasterCms must be running.
- Run the following command line (on UNIX platforms, substitute addnode.bat with addnote.sh):
"<INSTALLDIR>\SAP BusinessObjects Enterprise XI 4.0\win64_x64\scripts\addnode.bat" -update -cms "[MasterCmsName]:[MasterCmsPort]" -username Administrator -password "[CMSPassword]" -authentication secEnterprise -name [SIAName] -cmsport [MasterCmsPort] -usetempcms
The above information is available as an SAP note 1731612 - SIA node renaming may affect SP2 updates to FP3 or SP4.
Issue 7: Installing Patch 3 on BI 4.0 breaks SAP functionality
SAP logon, Viewing SAP Users, Roles, and Accounts with SAP Aliases, as well as SAP plug-in can stop functioning when installing on a system that is running against a message server in the SAP entitlement system.
- You see the error: "Account information not recognized: All servers with CMS "CMSname:port", cluster @"clustername:port", kind cms which host service null, are down or disabled".
- Switch to an application server.
- Rollback to patch 2 or earlier.
For more details refer to kbase 1765690. where the issue is detailed and a fixed .dll targeted for patch 5 is attached, or the SP04 Patch Release notes.
Issue 8: #SYNTAX after updating from SP4 to SP6
- #SYNTAX is shown in some reports after updating from BO 4.0 SP4 to BO 4.0 SP6.
Between SP4 and SP6, updates to the calculation engine might have created an incompatibility with previous files in the cache. Because of this, the binaries of SP6 are not able to properly process the files that were generated by th SP4 document cache. To resolve this issue, please clear the document cache as described in the note 1926596 - How to clear Web Intelligence. document cache on BI 4.0.
Help Portal: http://help.sap.com/bobip40/
SP04 Patch Release notes: http://service.sap.com/~sapidb/011000358700000813222012E
SAP Note 1729424 Business Intelligence platform 4.0 SP04 Patch Release Notes
SAP KBA 1603067 java.lang.NullPointerException or usagesProperty error after login to CMC or BI Launchpad
SAP KBA 1742498 Scheduling workflow(s) affected after installing SP4 for BusinessObjects Enterprise 4.0
SAP KBA 1743755 After installation of BI 4.0 Sp04, the crystal report cache server runs with errors and is disabled
SAP KBA 1671068 CMC in SAP BusinessObjects BI 4.0 returns a 500 error
SAP Note 1731612 SIA node renaming may affect SP2 updates to FP3 or SP4
SAP Note 1757132 BI4 Support Pack Upgrade and Patch Install Best Practice Guide
SAP Note 1765690 Installing patch 3 on BI 4.0 SP4 breaks SAP logon, viewing SAP users, roles, and accounts with SAP aliases as well as SAP plug-in
SAP Note 1926596 How to clear Web Intelligence. document cache on BI 4.0.
Thanks Shiva for making this public. I've already refered one of my customer's here who has been instrumental in finding the fix concerning the 32bit and 64bit paths. He will be posting another symptom concerning LCM in just a few. Its great to see everyone collaberating on this in the mean time.
- XI Jedi
This is dynamite! Help us help each other! While we don't want problems this is the best way to be proactive and share the goodness when we find it! I like the approach to confirm the known KB's associated with any of the items. Best to have this be a confident page where we have issues and valid solutions.
Unknown User (hz9i655)
Hello SAP Advocates,
We have two systems with SP4 update and one system with base SP4.Base SP4 system works with out any issues.Most of the issues we are seeing is with SP4 update system.Please workflow below.
1.Login to LCM
2.Select source system (SP2 PATCH 11 SP4)
3.Destination (Straight SP4)
4.Select one dashboard to promote
5.check manage dependents
6.Instead of one unx and connections ...it pulls entire system as
If i use straight SP4 as source i don't see any issue
If you have an issue without a workaround or solution yet, then you should post it in discussions or open a support indicent to get it investigated. This Wiki page is to document known issues and solutions to them.
Unknown User (hz9i655)
So we should not be posting any symptomsin comments area too?.Thanks for the information.You can remove the symptoms i added in comments section if you want.
Yes, we want issue - solution pairs, issues without solutions need to get solutions before we post them here.
To confirm for Sreedhar we definitely welcome the feedback but ideally we have a message so we can confirm a resolution for you and as Denis notes we want to pair issues with solutions on the Wiki from a formal perspective. For the record though I have seen a couple incidents of this workflow being an issue so I do feel there is something to it but not locked down yet. If you have a message let me know what it is.
Great information. If I am reading this correctly it appears that the Upgrade installer has issues updating files when they are being locked by running processes.
I have experienced issues in with BOE 4.0 on Windows servers where the permissions of the service account were delegated in such a way that the installer script was unable to fully stop all of the PIDS associated with the BOBJ services. UAC (User account control) can also cause this if the installer engine was not executed with “Run as Administrator” privileges. Typically I disable UAC on Windows servers to avoid this issue. I also make sure that the logon and service account are members of the local Administrators group.
On Linux I have had issues similar to this with ULIMIT, SELINUX and file permissions. SELINUX is typically the aggressor as it can prevent the installer from running various scripts. ULIMIT can cause problems by preventing all the PIDS (managed by the SIA) from fully starting during the upgrade process. Permissions on the install files must be set to 777 using CHMOD before running the installer.
Now that I have shared a little experience I was hoping someone could respond to a question. Outside of security related issues, are there any known issues with running the Upgrade installer vs the Full Installer of SP4? In short, has anyone experience an issue where a binary, library, dll, *.so or other dependent files are simply not deployed due to issues with the Upgrade Installer? Not that I would expect anyone at SAP development to make a mistake, but it would be good to know if there are any known issues with Upgrading vs Full Installing.
The first 2 sentences are ambiguous...it says...
1. When upgrading from BI Platform SP02 to SP04, SAP Highly recommends running the UPDATE INSTALLER.
SP04 Full build is more suitable for fresh installs, and should not be used in Update situations as this scenario has not been validated as a valid workflow.
Does this mean no update situations... UPDATE Installer is NOT update situation?
Also, does this mean, no other better way to do this than to have an extra box sitting side by side and do an update of the system?
Please help clarify. Thanks! :-)
This means that if you already have SAP BI4.0, you should always use Update installer. You should NOT remove original install or use fresh box to install Full build of SP04 using pre-SP04 CMS DB.
Once you UPGRADED using patch install, then you can add nodes to your cluster using full Sp04 build.
A few more questions (we have AIX as OS).
(1) what if we would like to have a fresh install since i think we have a corrupted registry - do we have then to have fresh install of SP2 and then use update installer to SP4?
(2) Or what if we have a totally new SP4 build, new CMS, new everything - will it be valid to re-import the BIAR file that was created with SP2? - Not using Update Installer.
(3) what are our options then given that we are running BIP 4.0 SP02 (have contents-mostly webI and CR) to move to SP04?
Unknown User (vli7cw7)
we are in process of moving to SP4 from SP2 patch 12 for BI 4.0. We would like to know.
1. Can we directly move to this patch? Also, we have downloaded following patch not the full install. is this right one?
ENTERPRISE04_0-20007507.TGZ SBOP BI Platform Servers 4.0 SP04 (including FP03) 0 Info 2833896 15.06.2012
2. also, whats the way i can unzip .TGZ file as we have linux env.
Deepak, you should use SDN forum for this sort of questions.
Yes the package is correct.
How to unzip .TGZ : http://www.linuxquestions.org/questions/linux-newbie-8/how-to-extract-tgz-125678/
Make sure you use binary transfer to move it from windows to linux, do not extract on windows.
Unknown User (105vl0mkl)
This is legendary post. Thanks a lot for sharing for this great stuff.
Really helpful for people that looks forward to upgrading to SP04 like me.
Unknown User (xq4zzkj)
Do you have any specific document or checklist invovling any specific components to be looked into while service pack upgrade from 10 to 13.
Tried finding one but could'nt succeed . If some one shares it , please do so as we are finding it difficult as upgrade is going to happen soon.
Installation of BO 4.1 SP5 and Windows AD SSO working successfully since last one year.
Now, for the purpose of security policy, client want to change the password of BI service account and make it complex. They might use Special characters in it like %, $, (, ^ etc. Current password does not contain special characters.
Would that password with special characters work fine while generating krb5.ini file or executing kinit command or bosso.keytab file??
Do we have any sap note or any article which specifies that password should not contain any special characters or how to do above tasks if password contain special characters?