PM51841: DOES CONTROLLER FAP SUPPORT MULTIPLE FAP DATA MART?

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 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