Could not run TI process: FAPMonthlyCompanyDetails_TextImportData

Product:
Cognos Controller 10.4.2 if8 CONTRL_UPDATE_version=CCR-AW64-ML-RTM-10.4.2000.1064-0
Microsoft Windows 2016 server
Planning Analytics 2.0.9.11  TM1-AW64-ML-RTM-11.0.911.20-0

Issue:
After upgrade of TM1 (Planning Analytics) to a newer version than 2.0.9.4 then the Cognos Controller FAP does not work.
The FAP IP stop with a error.

The TM1ProcessError can be:

Cannot convert field number 17, value “123456” to a real number

Error: Data procedure line (0): 01004[Microsoft][ODBC SQL Server Driver]String data, right truncation

Solution:

Upgrade Cognos Controller software to a later version.

https://www.ibm.com/support/pages/download-ibm-cognos-controller-1042-if17

  1. Install Controller 10.4.2 IF 17
  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 inside TM1 Architect.
  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 IP.

 

More information:

https://www.ibm.com/support/pages/cannot-run-ti-process-monthlycompanydetailstextimportdata

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.

If you upgrade Planning Analytics 2.0.9, you must upgrade Cognos Controller 10.4.2 to a later version.

https://www.ibm.com/support/pages/how-upgrade-controller-1042x-later-interim-fix-if-fix-pack-patch-level

https://www.ibm.com/support/pages/ibm-planning-analytics-20-fix-lists

https://www.ibm.com/support/pages/node/6519826

https://www.ibm.com/support/pages/ibm-cognos-controller-builds-ccr-name-and-database-version