Cognos reports fail to start

The problem: After upgrading to ITCAM for TransactionsV7.4, Cognos reports fail to start in Tivoli Common Reporting.

The solution:

Client Response Time is deprecated in ITCAM for Transactions V7.4. Because Cognos reports rely on all components being installed, you must run scripts from the integration package, included in the Cognos report package, to create dummy Client Response Time tables (CRT_Application_Status and CRT_Transaction_Status) in the Tivoli Data Warehouse. Depending on which database you use, in utilities/mssql, utilities/db2, or utilities/oracle, run the following scripts to create the tables:
  1. Run tdw_schema_table.sql
  2. Run tdw_schema_view.sql
Parent topic: Troubleshooting: Install / upgrade problems