Purpose (problem description)
The page will help you to find a solution for performance issue of the procedure AED_INIT_TRAN_VIOL_CNT_TMP_PREV getting stuck.
The stuck procedure name can be seen in AedCli-xxx log as shown in the screen shot below.
*Observed in CAST AIP
Release | Yes/No |
|---|---|
8.3.x x<=8.3.5 |  |
| 8.2.x | |
| 8.1.x | |
| 8.0.x | |
| 7.3.x | |
*Observed on RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server |  |
| Microsoft SQL Server | |
| CSS3 | |
| CSS2 | |
Step by Step Scenario
- Configure Snapshot in dashboard service'
- Step getting stuck for procedure AED_INIT_TRAN_VIOL_CNT_TMP_CUR.
Action Plan
Perform the below actions
Use the attached optimized version of the procedure AED_INIT_TRAN_VIOL_CNT_TMP_CUR.sql.
- Run the attached procedure on the central schema.
- Run the Snapshot by skipping analysis.
- If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input for CAST Technical Support to reproduce the issue.
Notes/comments
Ticket #16759
This performance issue with the procedure AED_INIT_TRAN_VIOL_CNT_TMP_PREV is fixed in AIP 8.3.6.
Related Pages
