Page tree
Skip to end of metadata
Go to start of metadata

SQL Tool is a sub task that is optional and will only be run when configured in the analysis.  It can be configured to run either before or after an analysis, or after a module generation.

It is triggered to run when the user adds the specific action for this in either the 'Tools before analysis' or the 'Tools after analysis' sections in the Content Enrichment tab of the application configuration, or in the 'Tools after module generation' section in the Module tab of the application configuration.

A separate log will be generated for the action of the SQL Tool execution.

The screenshot below shows how SQL Tool can be configured as a tool before analysis

Example screenshot showing how the Tools after Module Generation is configured in CAST-MS:

Check the below documentation and example screenshots for more information on this step and an example of where it is located in the CAST Management Studio. 

8.3.X Documentation: CMS - Modules tab

8.3.X Documentation: CMS - Content Enrichment tab

Select the log lines that you are interested from the list below

Excerpt Macro - Logs - Full Analysis Image for 83


CAST-MS-<date>-<time>.log.txt log file

Section of CAST-MS log file dealing with SQL Tool step as shown in the log above. 

Run SQL Tool Generation

INF: 2018-10-01 16:04:36:     starting Task Run Tool

INF: 2018-10-01 16:04:36:     starting Task sql1

INF: 2018-10-01 16:04:39:     Script successfully completed

INF: 2018-10-01 16:04:39:     Task message: No Task message

INF: 2018-10-01 16:04:39:     Log file: C:\ProgramData\CAST\CAST\Logs\c\Run_Tool_2166\sql1-20181001-160428.log.txt

INF: 2018-10-01 16:04:39:     ending Task sql1

INF: 2018-10-01 16:04:39:     Task message: No Task message

INF: 2018-10-01 16:04:39:     No associated log file

INF: 2018-10-01 16:04:39:     ending Task Run Tool

SQLTool log

<sql job name>-<Date>-<Time>.log.txt log file

Example screenshot showing the SQL Tool being executed:

Sample results of a SQL Tool log (results will vary depending on the contents of the SQL being run):

Run SQL Tool Results 

This logline contains the SQL Query

INF: 2018-10-01 16:20:13:     [SQL] set search_path=test830_local;

select count(*) from keys;




  • No labels