Troubleshooting
Problem
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 the tables 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
Product Synonym
itcam4t
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21608379