Run analysis option enables you to start the process of source code analysis of all Analysis Units at the Application level.
T SQL MS Analyzer helps to analyze the extracted Microsoft SQL Server source code in the offline mode.
The CAST SQL Analyzer (used to analyze PL/SQL and T-SQL (ASE & MS SQL)) is an "offline" analyzer, therefore, no live connection to the RDBMS is required during the analysis in the CAST Management Studio.
Instead, the target schemas/databases are packaged by the CAST Delivery Manager Tool via a JDBC connection into files that can be analyzed by the CAST SQL Analyzer.
Official Documentation: CAST AIP 8.0.x Documentation > CAST AIP 8.0.x Documentation > Cookbooks > Application Analysis and Measurement with CAST AIP > 2. Application Analysis Process with CAST AIP > 2.2. Execute the Analysis
In this page, the different logs lines corresponding to Run SQL Analyzer - T SQL MS are listed with functional and technical explanation of the logs that it generates.
If you want to know more about Run Analyzer task related to other technologies, please:
CAST-MS<ID>.log.txt
This section lists the information logged into the Cast-MS log file when the Analysis is run and provides detailed information about the Environment,Type of analyzer and settings, command line to run the Analyzer.
Environment Information
In the CAST MS log file we have many useful information regarding the environment : the CAST Installation folder used (we can find it in the command line to run the tool), the LISA and LTSA location and log file location
Using arguments:
INF: 2016-09-21 10:12:05: Loading ini file: C:\Users\SBR\Documents\8.0.0_Build8525_flat_for_customer\CastGlobalSettings.ini
INF: 2016-09-21 10:12:33: load from database done in 9371 ms.
INF: 2016-09-21 10:12:48: Server 'css2sup03:2280 on CastStorageService' found
INF: 2016-09-19 09:41:21: Environment
Product: CAST-MS
Version: 8.0.0.1
License Key: CAST_PS:1:20160930:UHURRKKR
Connection: cb800_logs_sbr_mngt on CastStorageService _ css2sup03:2280
Log file path: C:\Users\SBR\AppData\Local\Temp\CAST\CAST\8.0/CAST-MS.log.txt
Job Generation
Job generation for Application "TSQL_MS_New
INF: 2016-09-21 11:06:40: User Defined Module "TSQL_MS_New full content" saved in Analysis Service "cb800_logs_sbr_local"
INF: 2016-09-21 11:06:41: Dashboard Service "cb800_logs_sbr_central" saved in Dashboard Service "cb800_logs_sbr_central"
INF: 2016-09-21 11:06:41: System "My System" saved in Dashboard Service "cb800_logs_sbr_central"
INF: 2016-09-21 11:06:41: Application "TSQL_MS_New" saved in Dashboard Service "cb800_logs_sbr_central"
INF: 2016-09-21 11:06:41: User Defined Module "TSQL_MS_New full content" saved in Dashboard Service "cb800_logs_sbr_central"
INF: 2016-09-21 11:06:41: document saved
Synchronize Services
INF: 2016-09-21 11:06:41: Task message: No Task message
INF: 2016-09-21 11:06:41: No associated log file
INF: 2016-09-21 11:06:41: ending Task Synchronize Services
INF: 2016-09-21 11:06:41: starting Task Application "TSQL_MS_New"
INF: 2016-09-21 11:06:41: starting Task Run analysis for 'TSQL_MS_New'
INF: 2016-09-21 11:06:41: starting Task Run SQL Analyzers "My Package_14455"
Command Line to Run the Analysis
INF: 2016-09-21 11:06:41: C:\Users\SBR\Documents\8.0.0_Build8525_flat_for_customer/anarun.exe -CONNECT_PROFILE('css2sup03:2280 on CastStorageService.cb800_logs_sbr_local') -RUN_AU(11001,11003,'C:\CASTMS\LargeStorage\LISA\65ea62a3657a4155b3496c31f7087db3\Scr14468\JobSettings.xml') -MANAGED(11001) -SESSION_ID(11003) -LOG('C:\CASTMS2140\Delivery\logs\65ea62a3657a4155b3496c31f7087db3\My Package_14455-20160921110641.castlog',TRUNCATE) -LARGESTORAGE('C:\CASTMS\LargeStorage','C:\CASTMS\LargeStorage','65ea62a3657a4155b3496c31f7087db3/Scr14468') -LOGIN(,CASTCORP\sbr,) -APP(-NOGUI) -FINAL_UPDATE -NOPROGRESS -EXIT
Run Analysis for Sybase Analyzer
INF: 2016-09-21 11:06:55: About to run JOB_SQL_ANALYZER job 'My Package_14455'.
INF: 2016-09-21 11:07:31: Execution date=2016/09/21 09:07
INF: 2016-09-21 11:07:31: Execution duration=0 days, 00 hours, 00 mins, 35 secs
INF: 2016-09-21 11:07:31: Execution result=success
INF: 2016-09-21 11:07:32: Loading ini file: C:\Users\SBR\AppData\Local\Temp\CAST\CAST\8.0\AMRunResult11003.INI
INF: 2016-09-21 11:07:32: Loading ini file: C:\Users\SBR\AppData\Local\Temp\CAST\CAST\8.0\AMRunResult11003.INI
INF: 2016-09-21 11:07:32: Task message: No Task message
INF: 2016-09-21 11:07:32: Log file: C:\CASTMS2140\Delivery\logs\65ea62a3657a4155b3496c31f7087db3\My Package_14455-20160921110641.castlog
INF: 2016-09-21 11:07:32: ending Task Run SQL Analyzers "My Package_14455"
INF: 2016-09-21 11:07:32: starting Task Compute Analysis Unit full content for master
INF: 2016-09-21 11:07:33: Task message: Number of objects selected : 112
INF: 2016-09-21 11:07:33: No associated log file
INF: 2016-09-21 11:07:33: ending Task Compute Analysis Unit full content for master
My Package_<Execution_Unit_ID>-<DateTime>.castlog
This section shows all the configuration messages. All the options configured in CAST- MS like the local base name, LISA/LTSA folder destination, file extensions included in analysis, Schema Name, any custom environment profiles ,Package Name that are required to run a perfect analysis are shown in the log message during the beginning.
Environment Information
Timestamp Level Topic Body Who Error Number Runtime File Line Module Source Line Source Column Runtime Context Source
2016-09-21 11:07:35.606 Information INTERNAL ; Body 64-bit environment
2016-09-21 11:07:35.606 Information INTERNAL ; Body LISA folder: C:\CASTMS\LargeStorage
2016-09-21 11:07:35.606 Information INTERNAL ; Body LTSA folder: C:\CASTMS\LargeStorage
2016-09-21 11:07:35.606 Information INTERNAL ; Body LSA relative folder: 65ea62a3657a4155b3496c31f7087db3\Scr14468
2016-09-21 11:07:40.879 Information INTERNAL ; Body Using Knowledge Base on schema cb800_logs_sbr_local.
Run Analysis is about to Start
2016-09-21 11:06:53.730 Information MODULMSG ; Body Loading meta model from repository
2016-09-21 11:06:56.217 Information MODULMSG ; Body Meta model loaded.
2016-09-21 11:06:56.218 Information INTERNAL ; Body RunAnalysis started
Configuration Information of Package
2016-09-21 11:06:56.219 Information INTERNAL ; Body Description :
2016-09-21 11:06:56.219 Information INTERNAL ; Body Name : My Package
2016-09-21 11:06:56.219 Information INTERNAL ; Body Selection File : C:\CASTMS\LargeStorage\LISA\65ea62a3657a4155b3496c31f7087db3\Scr14455\CAST-MS-generated.uaxselection
2016-09-21 11:06:56.219 Information INTERNAL ; Body Selection AnalysisUnits
2016-09-21 11:06:56.219 Information INTERNAL ; Body Analysis Unit description :
2016-09-21 11:06:56.219 Information INTERNAL ; Body Name : master
2016-09-21 11:06:56.219 Information INTERNAL ; Body Number of Instances : 200000
2016-09-21 11:06:56.219 Information INTERNAL ; Body SESSION CONTEXT details: 11001 ; 11003 = "TSQL_MS_New"."My Package_14455"
T SQL MS Analysis Started
This section shows that the analysis step has and it processes the source code analysis of all the selected Analysis Units. It shows the number of external link components loaded, validation results and the files that are being analyzed.
We know that the analysis is starting with the statement : About to run <Execution unit name>
2016-09-21 11:06:56.219 Information INTERNAL ; Job execution About to run JOB_SQL_ANALYZER job 'My Package_14455'.
2016-09-21 11:06:56.219 Information MODULMSG ; Job execution Total physical memory: 8155 MB.
Dependencies : External links loaded
It gives information about the number of Client Server objects that would be involved in the analyzer in order to create external links.
2016-09-21 11:06:58.033 Information MODULMSG ; Job execution External link component has loaded 99 objects
Processing the extracted files
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateFunction.7.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateFunction.6.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateFunction.5.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateFunction.4.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateFunction.3.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateFunction.2.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateFunction.1.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\p_Schema.1.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\p_Schema.3.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\p_Schema.2.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateTable.3.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateTable.2.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateTable.1.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateIndex.2.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateIndex.1.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateProcedure.2.uax'
2016-09-21 11:06:59.815 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateProcedure.1.uax'
2016-09-21 11:07:00.166 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateProcedure.1.src'
2016-09-21 11:07:00.166 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateProcedure.2.src'
2016-09-21 11:07:00.166 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateProcedure.2.src'
2016-09-21 11:07:00.166 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateIndex.1.src'
2016-09-21 11:07:00.166 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\TSQL_MS_New\My Package\VASTCreateIndex.2.src'
Comparison and Merging objects on server
2016-09-21 11:07:20.105 MODULMSG ; Job execution Comparing objects on server
2016-09-21 11:07:26.128 MODULMSG ; Job execution Comparison completed.
2016-09-21 11:07:26.130 MODULMSG ; Job execution Merging objects on server
2016-09-21 11:07:29.658 MODULMSG ; Job execution Merge completed.
Execution Summary
2016-09-21 11:07:31.414 Information INTERNAL ; Job execution New Job status
2016-09-21 11:07:31.414 Information INTERNAL ; Job execution Execution date=2016/09/21 09:07
2016-09-21 11:07:31.414 Information INTERNAL ; Job execution Execution duration=0 days, 00 hours, 00 mins, 35 secs
2016-09-21 11:07:31.414 Information INTERNAL ; Job execution Execution result=success
2016-09-21 11:07:31.414 MSGACCOUNT ; Summary 0 fatal error(s); 0 error(s); 0 warning(s); 158 information message(s).
CAST_MainTask_SummaryLog_<DateTime>.txt
Status: Execution succeeded
Start: Wed Sep 21 11:06:39 CEST 2016
OS Version: Windows 7 (version 6.1)
Machine name: W7X64SP1SBR1
Software Version: CAST 8.0.0 ( Build 8525 )
Task: Take a snapshot of the application
Total duration: 3m27s
Nb of Computed Quality Rules: 54
-- Statistics for application TSQL_MS_New --
Analysis duration: 1m28s
No of modules: 1
No of active analysis units: 1
No of inactive analysis units: 0
Total no of analysis units: 1
No of saved objects: 112