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
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
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
  9. 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
  10. 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