This page provides the information about the various steps that are processed during the analysis of SQL technologies using the SQL Analyzer extension.

This extension is done through the Universal Analyzer framework and can handle a variety of SQL technologies. This page handles the sub technology Teradata.

A sample log is provided below and shows the steps taking place during the analysis process.

In this page, the different logs lines corresponding to the SQL analyzer extension are listed with functional and technical explanation of the logs that it generates.

The logs for the different SQL technologies are essentially the same except for the identifying line indicating the technology that is being analyzed.

 Refer to the official documentation of SQL Analyzer Extension for more details: SQL Analyzer

 For information on Universal Analyzer, refer to this document: What is the CAST Universal Analyzer and Framework

CAST-MS[#].log.txt

Since the SQL analyzer extension uses the Universal Analyzer Framework, the job in the CAST-MS log is a Universal Analyzer job

INF: 2018-06-04 16:09:47: starting Task Run Universal Analyzer "My Universal Analysis Unit_213186"

INF: 2018-06-04 16:09:47: C:\Program Files\CAST\8.3/anarun.exe -CONNECT_PROFILE('localhost:2282 on CastStorageService.test830_local') -RUN_AU(364801,364802,'C:\ProgramData\CAST\CAST\CASTMS\LISA\f39fe1b243894927ad407f384d256887\Scr632d71e3f1a34c4d82d277e5a6601212\JobSettings.xml') -MANAGED(364801) -SESSION_ID(364802) -LOG('C:\ProgramData\CAST\CAST\Logs\dbs_postgres\Take_a_snapshot_of_1138\My_Universal_Analysis-20180604-160937.castlog',TRUNCATE) -LARGESTORAGE('C:\ProgramData\CAST\CAST\CASTMS','C:\ProgramData\CAST\CAST\CASTMS','f39fe1b243894927ad407f384d256887/Scr632d71e3f1a34c4d82d277e5a6601212') -LOGIN(,DOMAIN\XXX,) -APP(-NOGUI) -FINAL_UPDATE -NOPROGRESS -EXIT

INF: 2018-06-04 16:09:54: #PMC#About to run JOB_UNIVERSAL_ANALYZER job 'My Universal Analysis Unit_213186'.
INF: 2018-06-04 16:09:54: About to run JOB_UNIVERSAL_ANALYZER job 'My Universal Analysis Unit_213186'.
INF: 2018-06-04 16:10:33: Adding new Project: My Universal Analysis Unit_213186
INF: 2018-06-04 16:10:33: Guid set
INF: 2018-06-04 16:10:33: persistence posted
INF: 2018-06-04 16:10:33: identification set
INF: 2018-06-04 16:10:33: description set
INF: 2018-06-04 16:10:33: fullname set
INF: 2018-06-04 16:10:33: identification posted
INF: 2018-06-04 16:10:33: project posted
INF: 2018-06-04 16:10:33: UnivProject id = #4
INF: 2018-06-04 16:10:33: IsInProjectLink added
INF: 2018-06-04 16:13:31: #PMC# Execution date=2018/06/04 23:13
INF: 2018-06-04 16:13:31: Execution date=2018/06/04 23:13
INF: 2018-06-04 16:13:31: #PMC# Execution duration=0 days, 00 hours, 03 mins, 37 secs
INF: 2018-06-04 16:13:31: Execution duration=0 days, 00 hours, 03 mins, 37 secs
INF: 2018-06-04 16:13:31: #PMC# Execution result=success
INF: 2018-06-04 16:13:31: Execution result=success
INF: 2018-06-04 16:13:31: Loading ini file: C:\Users\JMC~1.CAS\AppData\Local\Temp\CAST\CAST\8.3\AMRunResult364802.INI
INF: 2018-06-04 16:13:31: Task message: No Task message
INF: 2018-06-04 16:13:31: Log file: C:\ProgramData\CAST\CAST\Logs\dbs_postgres\Take_a_snapshot_of_1138\My_Universal_Analysis-20180604-160937.castlog

INF: 2018-06-04 16:13:31: ending Task Run Universal Analyzer "My Universal Analysis Unit_213186"

My_Universal_Analysis-[Date]-[Time].castlog

This log starts with environmental information such as the CAST version and LISA/LTSA locations among others. It also shows the version and the presence of the SQL analyzer extensions that will be run.

Environment Information

2018-06-04 16:09:49.589739 Information MODULMSG ; Job execution 64-bit environment
2018-06-04 16:09:49.590740 Information MODULMSG ; Job execution CAIP Version: CAST 8.3.3 ( Build 1591 )
2018-06-04 16:09:49.590740 Information MODULMSG ; Job execution LISA folder: C:\ProgramData\CAST\CAST\CASTMS
2018-06-04 16:09:49.590740 Information MODULMSG ; Job execution LTSA folder: C:\ProgramData\CAST\CAST\CASTMS
2018-06-04 16:09:49.591741 Information MODULMSG ; Job execution LSA relative folder: f39fe1b243894927ad407f384d256887\Scr632d71e3f1a34c4d82d277e5a6601212
2018-06-04 16:09:49.989465 Information MODULMSG ; Job execution Using Knowledge Base on schema test830_local.
2018-06-04 16:09:52.634258 Information MODULMSG ; Job execution Registering extension com.castsoftware.JEE-MavenHttp 1.4.0-funcrel.
2018-06-04 16:09:52.634258 Information MODULMSG ; Job execution Registering extension com.castsoftware.angularjs 1.5.0-funcrel.
2018-06-04 16:09:52.634258 Information MODULMSG ; Job execution Registering extension com.castsoftware.businessobject 1.0.0-funcrel.
2018-06-04 16:09:52.634258 Information MODULMSG ; Job execution Registering extension com.castsoftware.dmtboextractiondiscoverer 1.0.0-funcrel.
2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.dmtxmlscanner 1.0.0-funcrel.
2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.dotnet 1.0.0.
2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.html5 1.7.1-funcrel.
2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.php 1.3.0.
2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.webfilesdiscoverer 1.1.0-funcrel.
2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.internal.platform 0.3.0-funcrel.
2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.jaxrs 1.3.0-funcrel.
2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.jee 1.0.0-funcrel.
2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.jquery 1.5.0-funcrel.
2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.nodejs 1.5.0-funcrel.
2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.springmvc 1.3.0-funcrel.

The below line shows that SQL Analyzer extension is present as well as the specific version used

2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.sqlanalyzer 2.3.1.

2018-06-04 16:09:52.635259 Information MODULMSG ; Job execution Registering extension com.castsoftware.wbslinker 1.5.0.

The log next has a section for the metamodel loading and start of the run analysis step

Metamodel loading and start of Run analysis

2018-06-04 16:09:53.016617 Information MODULMSG ; Job execution Loading meta model from repository . . .
2018-06-04 16:09:53.922379 Information MODULMSG ; Job execution Meta model loaded.
2018-06-04 16:09:54.148034 Information MODULMSG ; Job execution RunAnalysis started

The log then has a section for the analysis configuration settings. This includes the extensions that will be analyzed.

File Extension information and other configuration information used by the analyzer

2018-06-04 16:09:54.151285 Information MODULMSG ; Job execution Analysis Unit description :
2018-06-04 16:09:54.151285 Information MODULMSG ; Job execution Name : My Universal Analysis Unit
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Universal language
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Extensions used in jobSettings : *.sql;*.sqltablesize;*.uaxdirectory;*.src
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Name : SQLScript
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Description : SQL
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Sources
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution File Path : C:\CASTMS\test830_css3\Deploy\dbs_postgres\My Package
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Permission : Include
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Universal language
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Extensions used in jobSettings : *.sql;*.sqltablesize;*.uaxdirectory;*.src
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Name : SQLScript
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Description : SQL
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Extensions used in jobSettings : *.js;*.ts;*.jsx;*.tsx;*.html;*.htm;*.xhtml;*.jsp;*.xml;*.json;*.css;*.asp;*.aspx;*.htc;*.cshtml
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Name : HTML5
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Description : HTML5/Javascript
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Extensions used in jobSettings : *.php;*.php4;*.php5;*.php6;*.inc;*.phtml;*.yml;*.yaml
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Name : PHP
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Description : PHP
2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution Number of Instances : 200000

Next, the log has a section for the universal analyzer job initialization.

Universal Analyzer Job Initialization

2018-06-04 16:09:54.151718 Information MODULMSG ; Job execution SESSION CONTEXT details: 364801 ; 364802 = "dbs_postgres"."My Universal Analysis Unit_213186"

2018-06-04 16:09:54.152722 Information MODULMSG ; Job execution About to run JOB_UNIVERSAL_ANALYZER job 'My Universal Analysis Unit_213186'.
2018-06-04 16:09:54.193927 Information MODULMSG ; Job execution Total physical memory: 8095 MB.
2018-06-04 16:09:54.528275 Information MODULMSG ; Job execution External link component has loaded 0 objects
2018-06-04 16:09:54.564180 Information MODULMSG ; Job execution External link component has loaded 0 objects
2018-06-04 16:10:33.612317 Information MODULMSG ; Job execution External link component has loaded 0 objects

The next log section deals with the processing of the files by the analyzer as well as the link creation.

File Processing and Link Creation - also includes the specific variation of analysis used

2018-06-04 16:10:33.785442 Information MODULMSG ; Job execution Starting processing of file 'C:\CASTMS\test830_css3\Deploy\dbs_postgres\My Package\abc.sql'
2018-06-04 16:10:34.549459 Information MODULMSG ; Job execution File processed : 'C:\CASTMS\test830_css3\Deploy\dbs_postgres\My Package\abc.sql'
2018-06-04 16:10:34.733888 Information MODULMSG ; Job execution [com.castsoftware.sqlanalyzer] Start creating symbols for file C:\CASTMS\test830_css3\Deploy\dbs_postgres\My Package\abc.sql

The analyzer is basically just a sql file analyzer regardless of technology. The line below will indicate the type or variant of SQL identified in the file. This identification will be used in the process of the file contents by the analyzer, though no specifics related to a language are in the log. All other items in the log would remain the same for another SQL technology except for the specific SQL variant that was identified. In this case it is identified as Teradata.

2018-06-04 16:10:35.272492 Information MODULMSG ; Job execution [com.castsoftware.sqlanalyzer] This file is analyzed against Variant.Teradata variant

2018-06-04 16:11:11.753080 Information MODULMSG ; Job execution [com.castsoftware.sqlanalyzer] End creating symbols for file C:\CASTMS\test830_css3\Deploy\dbs_postgres\My Package\abc.sql
2018-06-04 16:11:23.729773 Information MODULMSG ; Job execution [com.castsoftware.sqlanalyzer] Start creating links for file C:\CASTMS\test830_css3\Deploy\dbs_postgres\My Package\abc.sql
2018-06-04 16:12:03.084266 Information MODULMSG ; Job execution [com.castsoftware.sqlanalyzer] End creating links for file C:\CASTMS\test830_css3\Deploy\dbs_postgres\My Package\abc.sql
2018-06-04 16:12:03.085268 Information MODULMSG ; Job execution Starting checksum processing
2018-06-04 16:12:03.241380 Information MODULMSG ; Job execution End checksum processing
2018-06-04 16:12:03.469281 Information MODULMSG ; Job execution Starting UA resolution
2018-06-04 16:12:03.469281 Information MODULMSG ; Job execution End UA resolution
2018-06-04 16:12:03.469281 Information MODULMSG ; Job execution Ending External Link processing

Next, the log has a section for comparison and merging of objects.

Comparison and Merge

2018-06-04 16:12:04.436956 MODULMSG ; Job execution Comparing objects on server . . .
2018-06-04 16:13:14.396155 MODULMSG ; Job execution Comparison completed.
2018-06-04 16:13:14.396155 MODULMSG ; Job execution Merging objects on server . . .
2018-06-04 16:13:29.223625 MODULMSG ; Job execution Merge completed.

Finally, the log has a section for the summary of the analysis.

Execution Summary

2018-06-04 16:13:31.014425 Information MODULMSG ; Job execution New Job status
2018-06-04 16:13:31.015414 Information MODULMSG ; Job execution Execution date=2018/06/04 23:13
2018-06-04 16:13:31.018778 Information MODULMSG ; Job execution Execution duration=0 days, 00 hours, 03 mins, 37 secs
2018-06-04 16:13:31.019297 Information MODULMSG ; Job execution Execution result=success
2018-06-04 16:13:31.019297 Information MODULMSG ; Job execution Analysis completed
2018-06-04 16:13:31.216798 Information MODULMSG ; Job execution 0 fatal error(s); 0 error(s); 0 warning(s); 73 information message(s).

CAST_MainTask_SummaryLog-[Date]-[Time].txt

Summary of the analysis task that has been done. 

Status: Execution succeeded

Start: Mon Jun 04 16:09:35 CDT 2018 OS Version: Windows 8.1 (version 6.3)

Machine name: xxxxxxx

Software Version: CAST 8.3.3 ( Build 1591 )

Task: Take a snapshot of the application

Total duration: 10m31s

Nb of Computed Quality Rules: 53

 -- Statistics for application <application_name>  --    

Analysis duration: 5m27s    

Nb of modules: 1    

Nb of active analysis units: 1    

Nb of inactive analysis units: 0    

Total nb of analysis units: 1    

Nb of saved objects: 36375

Summary is saved at C:\ProgramData\CAST\CAST\Logs\<application_name>\Take_a_snapshot_of_1138\CAST_MainTask_SummaryLog-[Date]-[Time].txt