Troubleshooting
Problem
If you upgraded to Planning Analytics 2.0.9.4 or later, you may encounter these errors when you run Cognos Controller Financial Analytics Publisher (FAP) jobs.
- In the FAP error logs:
Could not run TI process: <…>MonthlyCompanyDetails_TextImportData - In the Planning Analytics error logs:
Error: Data procedure line (0): 01004[Microsoft][ODBC SQL Server Driver]String data, right truncation
Cause
These errors occur because Planning Analytics 2.0.9.4 and later does not support FAP jobs with comments containing more than 2047 characters. The existing <…>MonthlyCompanyDetails_TextImportData TI process that you upgraded from your previous TM1 environment does not adhere to this new limitation.
Resolving The Problem
To prevent these errors from reoccurring, follow these steps:
- Install Controller 10.4.2 IF 13.
Tip: Controller 10.4.2 IF 13 limits comments in FAP jobs to 2047 characters. This prevents errors when you run the <…>MonthlyCompanyDetails_TextImportData TI process. - Stop the Windows service of the TM1 server that is connected to FAP.
- Stop the Windows service IBM Cognos FAP Service.
- Manually delete the existing <…>MonthlyCompanyDetails_TextImportData TI process from TM1.
- Start the Windows service of the TM1 server that is connected to FAP.
- Start the Windows service IBM Cognos FAP Service.
- Do a full FAP republish.
After republishing, the TI processes created by Controller contain comments that meet the character limitation. The previous truncation errors no longer appear.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"ARM Category":[{"code":"a8m0z0000000AutAAE","label":"1 - Migrated Categories-\u003EBA - Cognos Controller-\u003EUpgrade"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.4.2"}]
Document Information
Modified date:
23 November 2021
UID
ibm16514511