IBM Support

FAP errors (such as "Datamart operations failed") after changing company structure in Controller

Troubleshooting


Problem

User changes the Controller company structure (for example changes an end date for a group in Company structure,). Afterwards, publishing the FAP datamart gives an error. For example, user clicks "Maintain - Company Structure - Define", chooses a subgroup, and clicks "Edit Consolidation Structure - Connected to: Edit". User changes the 'To Period', saves, and then closes the window. This will re-generate structures. Afterwards, there are errors in the FAP-related "retry.log" and "nrtr_log".

Symptom

retry.log - (default path = C:\Program files\cognos\c8\server\fap)

    java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:599)
    at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:50)
    at com.ibm.cognos.fap.service.persistence.tm1.CompanyTM1$$EnhancerByCGLIB$$559501a4.setAttributesOnElement(<generated>)
    at com.ibm.cognos.fap.service.dimension.Company.publishNewChildren(Company.java:210)
    at com.ibm.cognos.fap.service.schedule.DatamartTimerTask.publishNewChildren(DatamartTimerTask.java:553)
    at com.ibm.cognos.fap.service.schedule.DatamartTimerTask.run(DatamartTimerTask.java:188)
    at java.util.Timer$TimerImpl.run(Timer.java:286)
    Caused by: java.lang.NullPointerException
    at com.ibm.cognos.fap.service.persistence.tm1.CompanyTM1.setAttributesOnElement(CompanyTM1.java:378)
    ... 10 more

nrtr_log:
    2011-05-12 13:46:23.297 20 VFLFAP Update publish 10 Company version structure changed in ccr.
    2011-05-12 13:47:53.300 20 VFLFAP Update publish 10 Company version structure changed in ccr.
    2011-05-12 13:47:53.317 20 VFLFAP Update publish 10 Security changed in ccr.
    2011-05-12 13:50:07.867 30 FAP Service Scheduler 20 Datamart operations failed NULL
    2011-05-12 13:51:23.323 30 FAP Service Scheduler 10 Datamart removed from scheduling: VFLFAP

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 May 2025

UID

swg21499415