APAR status
Closed as program error.
Error description
Controller datamart contains 6 schemas sits on 1 database instance. In controller 8.5.1RTM, they are able to start multiple datamart at the sametime. In controller 8.5.1IF12, they see it failed with error message:"Could not create index or facts table table "FAP_ACTUAL"
Local fix
Workaround 1: Publish the first datamart, stop the datamart and then publish the second datamart. This means however that trickl e only can be done for one datamart at a time. Workaround 2: M anually rename the index FACTS_INO_PERIOD in the FAP Database. T his must be done after each initial publish since the index will be created every time an initial publish is done. This will all ow you to trickle from both datamarts at the same time.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Controller 10.1.1 * * or * * Upgrade to IBM Cognos Controller 8.5.1 FP1 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PM51841
Reported component name
COG CONTROLLER
Reported component ID
5724W24CO
Reported release
851
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-11-08
Closed date
2012-09-28
Last modified date
2012-09-28
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 CONTROLLER
Fixed component ID
5724W24CO
Applicable component levels
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
08 August 2024