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
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | x < 1 |
7.3.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 |
Below is the step-by-step scenario leading to the problem:
- Take a snapshot of the application
The impact of the problem on the analysis or the dashboard is: Snapshot hangs at Run CSV step
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
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 on the analysis or the dashboard is: CSV Job will run successfully.