APAR status
Closed as program error.
Error description
After installing FP3 for 10.2.2, After restarting Cognos services the Content Store contains 5 tables prefixed with BAK_ and is missing 5 corresponding tables that should start with ANN_. Even comment out the following command INSERT INTO ANN_VERSION(id, version) VALUES ('2', 2); from In the ANS2_UPDATE_Oracle.sql file, it did not fix issue. Need to run the script manually without comment out INSERT INTO ANN_VERSION(id, version) VALUES ('2', 2); from In the ANS2_UPDATE_Oracle.sql then rename ANS2_UPDATE_Oracle.sql to Bakup_ANS2_UPDATE_Oracle.sql
Local fix
Manually run the script \cognos\configuration\schema\oracle\ ANS2_UPDATE_Oracle.sql script after commenting out the following command: INSERT INTO ANN_VERSION(id, version) VALUES ('2', 2); Rename ANS2_UPDATE_Oracle.sql to prevent Cognos from running the script on restart.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Business Intelligence 10.2.2 Fix Pack * * 4 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PI53680
Reported component name
COG CONNECTION
Reported component ID
5724W12CC
Reported release
A22
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-12-07
Closed date
2016-01-06
Last modified date
2016-01-06
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
COG CONNECTION
Fixed component ID
5724W12CC
Applicable component levels
RA22 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWN","label":"Portal v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A22","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
06 January 2016