Run analysis option enables you to start the process of source code analysis of all Analysis Units at the Application level.
SQL Analyzer helps to analyze the extracted Sybase 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 the Run SQL Analyzer for T SQL ASE 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 Cat-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 found it in the command line to run the tool), the LISA and LTSA location and log file location
Using arguments:
INF: 2016-07-07 17:06:36: Loading ini file: C:\Users\SBR\Documents\8.0.0_Build8525_flat_for_customer\CastGlobalSettings.ini
INF: 2016-07-07 17:08:51: load from database done in 953 ms.
INF: 2016-07-07 17:08:53: Initializing logging context in a new thread. Logging.runInNewThreadContext should be used instead
INF: 2016-07-07 17:11:44: Section.run Platform Settings
INF: 2016-07-07 17:11:44: document saved
Platform Settings (Duration: 270 ms)
INF: 2016-07-07 17:11:44: starting Task Export
INF: 2016-07-07 17:11:44: Task message: document saved
INF: 2016-07-07 17:11:44: No associated log file
INF: 2016-07-07 17:11:44: ending Task Export
INF: 2016-07-07 17:11:44: document saved
INF: 2016-07-07 17:11:44: Server 'css2sup03:2280 on CastStorageService' found
INF: 2016-07-07 17:11:48: 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 "Sybase"
INF: 2016-07-07 20:50:40: User Defined Module "Sybase full content" saved in Analysis Service "cb800_logs_sbr_local"
INF: 2016-07-07 20:50:40: Dashboard Service "cb800_logs_sbr_central" saved in Dashboard Service "cb800_logs_sbr_central"
INF: 2016-07-07 20:50:41: System "My System" saved in Dashboard Service "cb800_logs_sbr_central"
INF: 2016-07-07 20:50:41: Application "Sybase" saved in Dashboard Service "cb800_logs_sbr_central"
INF: 2016-07-07 20:50:41: User Defined Module "Sybase full content" saved in Dashboard Service "cb800_logs_sbr_central"
INF: 2016-07-07 20:50:41: document saved
Synchronize Services
INF: 2016-07-07 20:50:41: Task message: No Task message
INF: 2016-07-07 20:50:41: No associated log file
INF: 2016-07-07 20:50:41: ending Task Synchronize Services
INF: 2016-07-07 20:50:41: starting Task Application "Sybase"
INF: 2016-07-07 20:50:41: starting Task Run analysis for 'Sybase'
INF: 2016-07-07 20:50:41: starting Task Run SQL Analyzers "My Package_13817"
Command Line to Run the Analysis
INF: 2016-07-07 20:50: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(551,553,'C:\CASTMS\LargeStorage\LISA\bf10fa0df9f148a59684c4b4ea6cf643\Scr13830\JobSettings.xml') -MANAGED(551) -SESSION_ID(553) -LOG('C:\CASTMS2140\Delivery\logs\bf10fa0df9f148a59684c4b4ea6cf643\My Package_13817-20160707205041.castlog',TRUNCATE) -LARGESTORAGE('C:\CASTMS\LargeStorage','C:\CASTMS\LargeStorage','bf10fa0df9f148a59684c4b4ea6cf643/Scr13830') -LOGIN(,CASTCORP\sbr,) -APP(-NOGUI) -FINAL_UPDATE -NOPROGRESS -EXIT
Run Analysis for Sybase Analyzer
INF: 2016-07-07 20:51:46: About to run JOB_SQL_ANALYZER job 'My Package_13817'.
INF: 2016-07-07 20:53:10: Execution date=2016/07/07 18:53
INF: 2016-07-07 20:53:10: Execution duration=0 days, 00 hours, 01 mins, 24 secs
INF: 2016-07-07 20:53:10: Execution result=success
INF: 2016-07-07 20:53:20: Loading ini file: C:\Users\SBR\AppData\Local\Temp\CAST\CAST\8.0\AMRunResult553.INI
INF: 2016-07-07 20:53:20: Loading ini file: C:\Users\SBR\AppData\Local\Temp\CAST\CAST\8.0\AMRunResult553.INI
INF: 2016-07-07 20:53:20: Task message: No Task message
INF: 2016-07-07 20:53:20: Log file: C:\CASTMS2140\Delivery\logs\bf10fa0df9f148a59684c4b4ea6cf643\My Package_13817-20160707205041.castlog
INF: 2016-07-07 20:53:20: ending Task Run SQL Analyzers "My Package_13817"
INF: 2016-07-07 20:53:20: starting Task Compute Analysis Unit full content for CASTpubs
INF: 2016-07-07 20:53:20: Task message: Number of objects selected : 184
INF: 2016-07-07 20:53:20: No associated log file
INF: 2016-07-07 20:53:20: ending Task Compute Analysis Unit full content for CASTpubs
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-07-07 20:50:48.559 Information INTERNAL ; Body 64-bit environment
2016-07-07 20:50:48.559 Information INTERNAL ; Body LISA folder: C:\CASTMS\LargeStorage
2016-07-07 20:50:48.559 Information INTERNAL ; Body LTSA folder: C:\CASTMS\LargeStorage
2016-07-07 20:50:48.559 Information INTERNAL ; Body LSA relative folder: bf10fa0df9f148a59684c4b4ea6cf643/Scr13830
2016-07-07 20:50:55.537 Information INTERNAL ; Body Using Knowledge Base on schema cb800_logs_sbr_local.
RUN ANALYSIS IS ABOUT TO START
2016-07-07 20:51:40.227 Information MODULMSG ; Body Loading meta model from repository
2016-07-07 20:51:42.415 Information MODULMSG ; Body Meta model loaded
2016-07-07 20:51:43.134 Information INTERNAL ; Body RunAnalysis started
CONFIGURATION INFORMATION OF PACKAGE
2016-07-07 20:51:46.009 Information INTERNAL ; Body Description :
2016-07-07 20:51:46.009 Information INTERNAL ; Body Name : My Package
2016-07-07 20:51:46.368 Information INTERNAL ; Body Selection File : C:\CASTMS\LargeStorage\LISA\bf10fa0df9f148a59684c4b4ea6cf643\Scr13817\CAST-MS-generated.uaxselection
2016-07-07 20:51:46.368 Information INTERNAL ; Body Selection AnalysisUnits
2016-07-07 20:51:46.368 Information INTERNAL ; Body Analysis Unit description :
2016-07-07 20:51:46.368 Information INTERNAL ; Body Name : CASTpubs
2016-07-07 20:51:46.368 Information INTERNAL ; Body Number of Instances : 200000
2016-07-07 20:51:46.368 Information INTERNAL ; Body SESSION CONTEXT details: 551 ; 553 = "Sybase"."My Package_13817"
Sybase Online 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-07-07 20:51:46.368 Information INTERNAL ; Job execution About to run JOB_SQL_ANALYZER job 'My Package_13817'.
2016-07-07 20:51:53.556 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-07-07 20:52:36.022 Information MODULMSG ; Job execution External link component has loaded 0 objects
Processing the extracted files
2016-07-07 20:52:37.131 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.7.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.7.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.6.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.6.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.5.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.5.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.4.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.4.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.3.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.3.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.2.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.2.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.2.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.1.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.27.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.27.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.26.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.26.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.25.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.25.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.24.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.24.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.23.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.23.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.22.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.22.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\p_Schema.1.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\p_Schema.1.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\p_Database.1.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\p_Database.1.uax
2016-07-07 20:52:37.881 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\p_Instance.1.uax' C:\LogsProject\TSQL\Deploy\Sybase\My Package\p_Instance.1.uax
2016-07-07 20:52:39.319 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.1.src'
2016-07-07 20:52:39.319 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.1.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.1.src
2016-07-07 20:52:43.631 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.2.src'
2016-07-07 20:52:43.631 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.2.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.2.src
2016-07-07 20:52:43.631 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.3.src'
2016-07-07 20:52:43.631 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.3.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.3.src
2016-07-07 20:52:43.631 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.4.src'
2016-07-07 20:52:43.631 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.4.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.4.src
2016-07-07 20:52:43.631 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.5.src'
2016-07-07 20:52:43.631 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.5.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.5.src
2016-07-07 20:52:43.631 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.6.src'
2016-07-07 20:52:43.631 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.6.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.6.src
2016-07-07 20:52:43.631 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.7.src'
2016-07-07 20:52:43.631 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.7.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.7.src
2016-07-07 20:52:43.631 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.8.src'
2016-07-07 20:52:43.631 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.8.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.8.src
2016-07-07 20:52:44.006 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.9.src'
2016-07-07 20:52:44.006 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.9.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.9.src
2016-07-07 20:52:44.006 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.10.src'
2016-07-07 20:52:44.006 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.10.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.10.src
2016-07-07 20:52:44.006 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.11.src'
2016-07-07 20:52:44.006 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.11.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.11.src
2016-07-07 20:52:44.006 Information PARSING ; Job execution Parsing file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.12.src'
2016-07-07 20:52:44.006 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.12.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateProcedure.12.src
2016-07-07 20:52:44.381 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.2.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.2.src
2016-07-07 20:52:44.381 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.3.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.3.src
2016-07-07 20:52:44.381 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.4.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.4.src
2016-07-07 20:52:44.381 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.5.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.5.src
2016-07-07 20:52:44.381 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.6.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.6.src
2016-07-07 20:52:44.381 Information MODULMSG ; Job execution Starting processing of file 'C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.7.src' C:\LogsProject\TSQL\Deploy\Sybase\My Package\VASTCreateIndex.7.src
Comparison and Merging objects on server
2016-07-07 20:52:52.100 Information MODULMSG ; Job execution Metric Assistant process launched
2016-07-07 20:52:56.194 MODULMSG ; Job execution Comparing objects on server . .
2016-07-07 20:53:04.476 MODULMSG ; Job execution Comparison completed
2016-07-07 20:53:04.476 MODULMSG ; Job execution Merging objects on server . .
2016-07-07 20:53:08.444 MODULMSG ; Job execution Merge completed
Execution Summary
2016-07-07 20:53:10.241 Information INTERNAL ; Job execution New Job status
2016-07-07 20:53:10.241 Information INTERNAL ; Job execution Execution date=2016/07/07 18:53
2016-07-07 20:53:10.241 Information INTERNAL ; Job execution Execution duration=0 days, 00 hours, 01 mins, 24 secs
2016-07-07 20:53:10.241 Information INTERNAL ; Job execution Execution result=success
2016-07-07 20:53:10.241 MSGACCOUNT ; Summary 0 fatal error(s); 0 error(s); 0 warning(s); 169 information message(s)
2016-07-07 20:53:10.241 1048575 ; Job execution
2016-07-07 20:53:10.585 Information INTERNAL ; Body Analysis completed
CAST_MainTask_SummaryLog_<DateTime>.txt
Status: Execution succeeded
Start: Wed Sep 14 11:21:34 CEST 2016
OS Version: Windows 7 (version 6.1)
Machine name: W7X64SP1SBR1
Software Version: CAST 8.0.0 ( Build 8525 )
Task: Run Analysis only
Total duration: 1m15s
-- Statistics for application TSQL --
Analysis duration: 1m13s
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: 15