1796965 - BI 4.0 DB2 9.5 HADR/Hot backup restore capability

Symptom

Restore from Hot Backup of DB2 database lead to CMS hanging with following type of errors visible in the logs:

|2012 12 10 15:26:20:882|+0100|Information| |-|-|-||||||||||||CRC does not match BLOB for Object 3611

...

|2012 12 10 15:26:31:918|+0100|Information| |||||||||||||||SIServerController:run: Fail to initialize or uninitialize.  Reason is The root server reported an error Initialization Failure. (Reason: Plugin Manager error: Unable to locate the requested plugin 18 on the server. (FWB 00006)Plugin Manager error: Unable to locate the requested plugin 18 on the server. (FWB 00006) Unknown plugin or invalid SI_OBTYPE).:Plugin Manager error: Unable to locate the requested plugin 18 on the server. (FWB 00006) Unknown plugin or invalid SI_OBTYPE
).:Plugin Manager error: Unable to locate the requested plugin 18 on the server. (FWB 00006) Unknown plugin or invalid SI_OBTYPE

After applying SP05, patch 4.6 or patch 4.7 on a platform using DB2 9.5 and containing backups, the following error might occur:

Failed to retrieve cluster name from the database. 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, DB 9.7 fixpak 1 or higher or DB2 10 or higher. 
Option 2 is to turn off HADR. (FWB 00088)

Environment

This issue affects only the versions quoted below

SAP BusinessObjects Business Intelligence Platform BI 4.0 SP05
SAP BusinessObjects Business Intelligence Platform BI 4.0 patch 4.6 and 4.7
DB2 9.5

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

RAN, PR ADAPT01675007, FR ADAPT01675008, PR ADAPT01674899, ADAPT01674900 (Patch5.1), ADAPT01674901 (Patch4.8), TE 5000454339 5000453361, ADAPT01659678, ADAPT01659681 AURORA_4.0_Patch4.6, ADAPT01659682 AURORA_4.0_SP05, TE 5000454339 5000453361 , KBA , BI-BIP-DEP , Webapp Deployment, Networking, Vulnerabilities, Webservices , BI-BIP-INS , Installation, Updates, Upgrade, Patching , Problem

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.