Release | Yes/No |
|---|---|
| 8.2.x |  |
| 8.1.x | |
| 8.0.x | |
| 7.3.x | |
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS2 | |
| CSS1 | |
- Launch TCC.
- Click on Compute application function point
- Optimize the local base, for this refer to CSS Tools - Optimize - Updating the statistics - using Cssoptimize exe on a schema, then compute the Application Function point, if this do not resolve the issue then go to the next step.
- Enable SQL traces then compute FP for this refer to Transaction Configuration Center - Information - How to launch TCC in SHOW SQL mode in order to get the SQL traces and go to the next step.
- Compute application function points, open TCC log file, refer to the following page for the log location CAST Management Studio - Information - How to find logs, then go to the next step
- The issue can be due to the fact that TCC is stuck in the computation of a phase or the computation of a procedure or a query.This case is identified when the computation takes very long time in a specific phase or procedure without returning any message after this procedure.
Listed below are the known cases and the remediation's, if your case is not listed bellow then go to the next step.The computation is stuck at synchronizing local size phase:
YYYY/MM/DD HH/MM/SS INF: Message Synchronizing local site... MM/JJ/YYYY/HH/MM/SS
If it's the case then perform the below steps, else go to the next step:
- Open Cast-MS log, For information about log location, please refer to the following page CAST Management Studio - Information - How to find logs
Search for the following error:
" UserProject Application Name already locked by "User Name" "
If you find this error then the Local Base is currently locked by another user, if this is not the case then contact CAST Technical Support with the following Relevant input, else perform the following steps to resolve the issue:
- Remove Analysis service locks, for this refer to SRV - Remove Locks (Troubleshooting)
- Synchronize the Analysis service with the management schema, for this refer to CMS - Synchronize
- Compute Application function points from TCC
If The issue is really a performance issue, then we need to identify the procedure(s) that takes a long time, this is identified by searching for the following message inside the log file:
YYYY/MM/DD HH/MM/SS INF: [SQL] *** LONG ELAPSED TIME: 10 mn
If you find this message and the procedure located above this message takes more then 1 min to be executed, check if your case is listed below, else contact CAST Technical Support with Relevant input
If the performance issue is due to the execution of the procedure "DSSAPP_SCOPE_IFPUG_DONE", listed below are the known issues and the workarounds.
YYYY/MM/DD HH/MM/SS INF: [SQL] call <local_DB>.DSSAPP_SCOPE_IFPUG_DONE(?,?,?,?) YYYY/MM/DD HH/MM/SS INF: [SQL] *** LONG ELAPSED TIME: X mn
As a workaround perform the following steps: (This procedure was optimized starting from CAST AIP 8.2.5.)
Take a backup of your triplet
Run the queries in the file fix_dssapp_scope_ifpug_done.txt, on the Knowledge Base
Compute application function point from TCC.
If this solution do not resolve your issue then contact CAST Technical Support with the following Relevant input
If the performance issue is due to the insert from the procedure "PMC_ARCHI_ALLOW_LINKS " into the procedure "PMC_EXPAND_SUBOBJECTS", you will find the following message:
YYYY/MM/DD HH/MM/SS INF: [SQL] Insert into <Knowledge_Base>.PMC_ARCHI_ALLOW_LINKS select * from <local_db>.PMC_EXPAND_SUBOBJECTS ( 0, 15 ) where PMC_EXPAND_SUBOBJECTS = -999999" YYYY/MM/DD HH/MM/SS INF: [SQL] *** LONG ELAPSED TIME: X mn
As workaround perform the following steps: (This procedure was optimized starting from CAST AIP 7.3.9.)
Take a backup of your triplet
Run the queries in the file fix_PMC_ARCHI_PROC.sql on the Knowledge Base
Compute application function point from TCC.
If this solution do not resolve your issue then contact CAST Technical Support with the following Relevant input
If the performance issue is due to the procedure "DSSAPP SCOPE INIT TCC ", you will find the following message in the TCC log:
YYYY/MM/DD HH/MM/SS INF: call <local_DB>.DSSAPP_SCOPE_INIT_TCC(?) }YYYY/MM/DD HH/MM/SS INF: [SQL] *** LONG ELAPSED TIME: X mn
Then check if there is custom procedure like -tcc_fp_usr_xxx used in your application as shown below:
Please check why these customization is added. If it is not necessary, then deactivate the customization by running the following function on KB and compute the FP again in TCC : select SET_TCC_OPTION_FPCUSTOM (0,0);
If issue is not reproduced at support end using customer schema then ask customer to optimize and vacuum the KB&CB following the FP computation. Please refer the page for vacuum Tools - How to VACUUM FULL tables of a schema and the page CSS Tools - Optimize - Updating the statistics - using Cssoptimize exe on a schema to optimize the schema .
If the steps above do not resolve your issue then contact CAST Technical Support with the following Relevant input.
