IBM Support

Cannot run TI process <…>MonthlyCompanyDetails_TextImportData

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:
  1. 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.
  2. Stop the Windows service of the TM1 server that is connected to FAP.
  3. Stop the Windows service IBM Cognos FAP Service.
  4.  Manually delete the existing <…>MonthlyCompanyDetails_TextImportData TI process from TM1.
  5. Start the Windows service of the TM1 server that is connected to FAP.
  6. Start the Windows service IBM Cognos FAP Service.
  7.  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