CAST Engineering Dashboard - Information - How to identify and execute SQL query involved in data display

Purpose

This page provides you the information on how to identify the specific section a SQL Query belongs to, after the SQL Traces have been activated. It will provide the steps on how to adapt that query and execute on the pgAdmin manually.

Applicable in CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS2✅

Details

Follow the below steps:

  1. Stop the web server
  2. Activate the SQL Traces in CED Dashboard, as explained in CAST Engineering Dashboard - Information - Configuring Dashboard to SQL trace
  3. Activate the traces on Retrievers in CED Dashboard, as explained in CAST Engineering Dashboard - Information - Configuring Dashboard to show the retriever name
  4. Restart the web server
  5. Log in CED
  6. Navigate to the desired page
  7. Open the stdout.log file present by default in the path - <Webservice_installation_folder>/logs/tomcatx-stdout.yyyy-MM-dd.log
  8. Identify the retriever that retreive the data from the schema. Remember that all the retrievers are named as per their purpose.
Name of the RETRIEVERSpecific Section on Dashboard
RETRIEVER_MODULE_FULLNAME
This retriever provides the module name
RETRIEVER_RULE_INVEST_VIOLATION_TABLEThis retriever provides the results of violations for quality rules
RETRIEVER_RULE_VALUE_TITLEThis retriever provides the metric description for a particular quality rule
RETRIEVER_MODULE_FAILED_CHECKS_COMPUTINGThis retriever provides the number of failed checks
RETRIEVER_MODULE_TOTAL_CHECKS_COMPUTINGThis retriever provides the number of total checks
RETRIEVER_MODULE_NB_OBJECT_VIOL_COMPUTINGThis retriever provides the number of objects with violations

For instance,

[05-17-2016 13:14:09][INFO]:    [ROWREADER] Read: RETRIEVER_MODULE_FULLNAME
[05-17-2016 13:14:09][INFO]:    [ROWREADER] Session Id : 0C09B1ABACD731DB0DEFE4A3713381C5
[05-17-2016 13:14:09][DETAIL]:  [SQL] PREPARE Select o.OBJECT_FULL_NAME from test_73_shell_central.DSS_OBJECTS o where o.OBJECT_ID = 4
[05-17-2016 13:14:09][DETAIL]:  [SQL] EXECUTE
[05-17-2016 13:14:09][DETAIL]:  [SQL] Query Time < 1 ms

  1. Identify the SQL query provided in the retriever in the [DETAIL]:  [SQL]. In the above example, it is PREPARE Select o.OBJECT_FULL_NAME from test_73_shell_central.DSS_OBJECTS o where o.OBJECT_ID = 4

  2. Execute this SQL query in pgAdmin manually, without SQL PREPARE statement. In the above example, run

Select o.OBJECT_FULL_NAME from test_73_shell_central.DSS_OBJECTS o where o.OBJECT_ID = 4


    It will provide the results as below:

    **Query Result**

    "Shell full content"

**Notes/comments**

**Related Pages**