SAP Knowledge Base Article - Preview

1819834 - CMS server is not coming UP after upgrading BI 4.0 to SP05

Symptom

  • The issue was observed on few customer's environments.
  • The upgrade will not complete properly and will throw error message "SAP Business Objects BI Platform 4.0 SP5 has encountered errors during the install process"
  • The issue is specific with IBM DB2 used as CMS system database.
  • The CMS will not start after the upgrade and in the /var/logs/messages following error messages were found.
  • DB2 is running with HADR enabled. Ths requires that the CMS_INFOOBJECTS7 column of the table PROPERTIES be set to LOGGED. That cannot happen because the current version of DB2 does not support logging of large blob columns. The CMS will not start under this condition because database failover would corrupt the repository. There are two options. Option one is to upgrade the DB2 server to DB2 v9.5 fixpak 5 or higher, DB2 9.7 fixpak 1 or higher or DB2 10 or higher. Option two is to turn off HADR. (FWB 00088)
  • CMS is unstable and will shut down immediately. Reason: DB2 is running with HADR enabled. Ths requires that the CMS_INFOOBJECTS7 column of the table PROPERTIES be set to LOGGED. That cannot happen because the current version of DB2 does not support logging of large blob columns. The CMS will not start under this condition because database failover would corrupt the repository. There are two options. Option one is to upgrade the DB2 server to DB2 v9.5 fixpak 5 or higher, DB2 9.7 fixpak 1 or higher or DB2 10 or higher. Option two is to turn off HADR. (FWB 00088)
  • The issue was observed on Unix, however it can be reproduced on Windows environments as well.

 


Read more...

Environment

  • SAP BusinessObjects BI 4.0 SP05 upgrade
  • SAP BusinessObjects BI 4.0 Patch 4.6

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

cms upgrade failed bi40 bi 4.0 sp 05 , KBA , BI-BIP-DEP , Webapp Deployment, Networking, Vulnerabilities, Webservices , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.