Troubleshooting

The topics in this section provide solutions for problems you may encounter when using IBM® Cognos Controller.

Error message in Trial Balance and Journals Across after migration from Consolidator to IBM Cognos Controller
If you have upgraded to Cognos Controller from IBM Cognos® Consolidator and receive an error message about missing data in the Trial Balance or Journals Across reports, it may be because the status for all companies is set to Missing.
Forms locked for data entry
If a form is missing from the list in Data Entry - Reported Values, it may be because linked structures have not been set up correctly.
Unexpected differences in the Intercompany Balance and Trial Balance reports
If the difference shown in Group > Reconcile > Intercompany Balances exceeds the difference shown in Group >Reports > Trial Balance with Drilldown, the intercompany balance account setup in the configuration table may be missing the Sign +/- setting. The result is that the account is displayed in the reconciliation report but not included in the elimination calculation.
Exceeding levels in forms
If you receive the error message The level of the extended dimension member exceeds the level of the account after updating the form in Microsoft Excel and try to save the form, the dimension may be at a lower level than the dimension for the account, which is set in the account structure.
Unexpected steps in the consolidation in batch mode
If additional consolidation steps are executed when running consolidation by steps in batch mode, the status may have been set to Active in Maintain > Change Status. This setting will override any pending batch jobs and the result is that consolidation will be executed by status.
Error no 1004: The macro ’cc.SetForegroundEx’ cannot be found
If you receive the error message Error no 1004: The macro ’cc.SetForegroundEx’ cannot be found when trying to preview a report from Microsoft Excel, the Controller add-in may not have been loaded properly.
User-defined report based on contribution version retrieves base figures only
If a user-defined report based on contribution version only retrieves base values, although consolidated values exist and are displayed to an administrator, the report user may have the wrong user rights defined.
Unlock all periods (multi-period locking)
If a period is open for data entry although it is locked in Maintain > Period Locking > Change - Multi Period Locking, ensure that Unlock All Periods in Maintain > Period Locking > Change - Multi Period Locking is cleared.
Slow response to Excel query
When you refresh a query using the Excel add-in, it takes much longer than it should for the results to be returned.
Cannot export very large amount of data
When you try to export a very large amount of data from Controller, an error message appears, similar to the following: