TCR shows no data for ITCAM reports

Technote (troubleshooting)


Problem(Abstract)

Selecting 'run the report now' produces an error and no data

Symptom

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.


Cause

All the required tables must be created and the correct schema name must be applied to the configuration.


Diagnosing the problem

All of the tables listed in the documentation are required for TCR operation. Agents that are not installed must also have the required tables created in the database, even if you don't plan to use other agents.

Resolving the problem


These are the - Application Scorecard tables - All are required
Application Management Console (raw data, hourly):
AMC_Application
AMC_Client
AMC_Transaction
AMC_Server
AMC_Internet_Service
AMC_Internet_Service_Agent
AMC_Internet_Service_Element
RRT_Application_Status

RRT_Transaction_Status
RRT_SubTransaction_Status
RRT_Robotic_Playback_Events (raw data only)

CRT_Application_Status
CRT_Transaction_Status
WRT_Application_Status
WRT_Transaction_Status
WRT_User_Sessions
Aggregates
Interactions
TIME_DIMENSION table


Verify all the database tables, views and indexes are created in the schema with the correct schema.

Related information

Viewing Cognos reports

Product Alias/Synonym

itcam4t
itcamfort

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Composite Application Manager for Transactions
ITCAM TRANSACT AMC 5724S79EU v710

Software version:

7.3, 7.4

Operating system(s):

AIX, Linux, Windows

Reference #:

1608379

Modified date:

2012-12-06

Translate my page

Machine Translation

Content navigation