PM06847: ORACLE AUDIT DATABASE UPGRADE FROM 8.3 TO 8.4.1 FAILS.

APAR status

• Closed as program error.

Error description

• Customer would like to get steps to upgrade Audit schema from
  8.3 to 8.4.1 to be able to use old Audit data.
  
  Audit tables are first created for Cognos 8.3 against empty
  Audit schema. After that when configuring 8.4.1 to use same
  audit database, Audit tables neither upgrade nor log any data.
  Replicated issue with tables from 8.3 FP5 to 8.4.1 in Oracle
  10.2.0.1.0. Error on startup in cogserver.log:
  
  ---
  9.71.210.105:9306 8104 2010-02-02 15:55:40.937 +0    main LOGSV
  6003 1 Audit Upgrade Schema
  jdbc:oracle:thin:@localhost:1521:orcl Success  <parameters><item
  name="OLD_VERSION"><![CDATA[83.017]]></item><item
  name="NEW_VERSION"><![CDATA[84.003]]></item></parameters>
  9.71.210.105:9306 8104 2010-02-02 15:55:41.031 +0     main LOGSV
  6003 1 server.Audit.IPF StartService LogService  FAILED Log
  Server Database error <parameters><item name="DB
  URL"><![CDATA[jdbc:oracle:thin:@localhost:1521:orcl]]></item><it
  em
  name="DB Error"><![CDATA[LogDbStoreFactory::getUpgradeFiles() -
  No LS DB upgrade scripts]]></item></parameters>
  ---
  
  Also tried to upgrade via 8.4 FP2 using workaround from bug
  'COGCQ00073963' by setting 'IPFStoreVersion' to '8.4.002'. This
  works in 8.4 FP2 so that logging starts to work again, but Audit
  tables does not seem to be otherwise touched and
  "COGIPF_POWERPLAY_" tables are not created? Setting 8.4.1 Audit
  logging to use this db, logservice fails to start again and
  cogserver.log has similar error as before.
  
  IR COGCQ00207984 describes process to upgrade from 8.2 to 8.4.
  What is correct procedure to manually update Audit schema from
  8.3 to 8.4.1 and still secure use of old data.
  

Local fix

• n/a,  fixed in 10.1
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1             *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COG8 BI INST CO

• Fixed component ID

  5724W12IC

Applicable component levels

• RA10 PSN

     UP