CMS Snapshot Analysis - Run CSV Generation - Performance Issue - CSV Generation Job runs infinitely
Description
When snapshot is run, Run CSV task gets stuck.
Figure 1
The log of Run CSV Generation task also gets stuck as shown below:
Figure 2
Observed in CAST AIP
| Release | Yes/No |
|---|---|
| 8.3.x | ❌ |
| 8.2.x | ❌ |
| 8.1.x | ❌ |
| 8.0.x | ✅ x < 1 |
| 7.3.x | ❌ |
Observed on RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ❌ |
| Microsoft SQL Server | ❌ |
| CSS3 | ❌ |
| CSS2 | ✅ |
Step by Step Scenario
Below is the step-by-step scenario leading to the problem:
- Take a snapshot of the application
Impact of the Problem
The impact of the problem on the analysis or the dashboard is: Snapshot hangs at Run CSV step
Action Plan
Launch manually sub procedure - INT_CSV_CONTAINER in a sql session.You can see that the procedure will get stuck while executing.
The issue is due to a bug fixed in 8.0.1 for the procedure INT_CSV_CONTAINER.
Any applications on 8.0.0 which have this similar issue should update this procedure on the local database for it to work properly
Remember to use the set search_path=
Attached is the procedure which should be run on local base INT_CSV_CONTAINER.sql
- Run the procedure on a sql session.
- Run CSV job again.
Impact of the Solution
Impact of the solution on the analysis or the dashboard is: CSV Job will run successfully.
Notes/comments
Ticket # 5355
Related Pages