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

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:

 Choose your technology
CMS Snapshot Analysis - Run DOTNet Analyzer - C Sharp - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run ABAP Analyzer - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run ASP Analyzer - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run CPP Analyzer - C and CPP - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Universal Analyzer - EGL - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Universal Analyzer - Flex - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Universal Analyzer - Fortran - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Universal Analyzer - PHP - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Universal Analyzer - PLI - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Universal Analyzer - RPG - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Universal Analyzer - Shell - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Universal Analyzer - Angular js - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Universal Analyzer - JQuery - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Universal Analyzer - Node js - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Universal Analyzer - HTML5 Javascript - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run J2EE Analyzer - Java - JSP - Web Services - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run J2EE Analyzer - JAX RS - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run J2EE Analyzer - Spring MVC - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run J2EE Analyzer - JSP - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run J2EE Analyzer - JEE - EJB - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Mainframe Analyzer - CICS - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Mainframe Analyzer - Cobol - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Mainframe Analyzer - IMS - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Mainframe Analyzer - JCL - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Oracle Forms Analyzer - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run Universal Analyzer - Power Builder - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run DB2 zOS Analyzer - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run SQL Analyzer - T SQL ASE - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run SQL Analyzer - T SQL MS - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run SQL Analyzer - SQL PSM zOS - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run SQL Analyzer - PL SQL - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run VB Analyzer - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run VB Analyzer - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run DOTNet Analyzer - WPF - Extension - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run DOTNet Analyzer - WCF - Extension - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run DOTNet Analyzer - Silverlight Extension - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run DOTNet Analyzer - C Sharp - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run DOTNet Analyzer - ASP DOTNet - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run DB2 zOS Analyzer - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run CPP Analyzer - C only - Error Free Logs - CAST AIP 8

CMS Snapshot Analysis - Run CPP Analyzer - CPP - Error Free Logs - CAST AIP 8

 

CMS Snapshot Analysis - Run J2EE Analyzer - JAX WS - Error Free Logs - CAST AIP 83


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

  • No labels