CMS Analysis Unit - Information - Identify the Analysis unit log file
Purpose
This page will explain how to identify the Analysis Unit log file either from CAST MS, or by queries.
On the whole, the analysis log files are stored in :
Applicable in CAST Version
| Release | Yes/No |
|---|---|
| 8.0.x | ✅ |
| 7.3.x | ✅ |
| 7.2.x | ✅ |
| 7.0.x | ❌ |
Applicable RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ❌ |
| Microsoft SQL Server | ❌ |
| CSS2 | ✅ |
| CSS1 | ❌ |
In CAST MS
To check the Analysis Unit log file from CAST MS, edit the Analysis Unit, and click on the Execute tab. The log file path and name is in the “Last execution log” field.
Details
Using Queries
It is possible to get all Analysis Units log file using queries. We need to proceed in two steps :
- Run the query below to get the “final” request giving all the analysis units log files:
Info
select case
when row_number() over (order by table_schema) != 1 then ‘union all '
else ’’ end || ‘select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from ’ || table_name from information_schema.columns
where column_name=‘execlog’
and table_schema=
The result is as below :
"select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_asp_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_cobol_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_cpp_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_forms_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_j2ee_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_net_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_ora_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_sap_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_sqlsrv_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_syb_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_ua_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_udb_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_ui_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_vb_analysis"
"union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_zos_analysis"
- Set your schema search path and copy paste the result of the above query (remove all the “) and execute it :
Set search_path to <YOUR_SCHEMA>;
select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_asp_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_cobol_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_cpp_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_forms_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_j2ee_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_net_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_ora_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_sap_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_sqlsrv_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_syb_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_ua_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_udb_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_ui_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_vb_analysis
union all select object_id Analysis_Unit_Id , object_name Analysis_Unit_Name, execstatus, execlog from cms_zos_analysis
The result is as below:
| A.U ID | Analysis Unit Name | ExecStatus | ExecLog |
| 15521 | To reproduce Inner Classes | ExecutionNoneStatus | |
| 16255 | BusinessHelloWorld | ||
| 15788 | STATS_DELAIS | ExecutionNoneStatus | |
| 15789 | CHARGEMENT_SR | ExecutionNoneStatus | |
| 15790 | FJAS_PROD_ALERT | ExecutionNoneStatus | |
| 15791 | FJAS_ANALYSE_IDEN | ExecutionNoneStatus | |
| 15792 | FJAS_TMA | ExecutionNoneStatus | |
| 15793 | INTERRO_FND_ICARE | ExecutionNoneStatus | |
| 15794 | FJAS_WS | ExecutionNoneStatus | |
| 16273 | BusinessHelloWorld | ExecutionSuccessStatus | C:\Users\SBO~1.CAS\AppData\Local\Temp\CAST\CAST\7.2\7543ada520814794a835b78e3a8b03a1\My Source file based execution unit_16289-20140925100505.castlog |
| 16277 | SCOTT | ExecutionSuccessStatus | C:\Users\SBO~1.CAS\AppData\Local\Temp\CAST\CAST\7.2\7543ada520814794a835b78e3a8b03a1\My Package 2_16271-20140925100505.castlog |
| 16125 | test1 | ExecutionNoneStatus | |
| 16148 | TEST SBO | ExecutionNoneStatus |
From CAST-MS
- From CAST-MS we have an option here:
Notes / Comments
Related Pages