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(error)
8.2.x(error)
8.1.x(error)
8.0.x(tick) x < 1
7.3.x(error)
Observed on RDBMS
RDBMS
Yes/No
Oracle Server(error)
Microsoft SQL Server(error)
CSS3(error)
CSS2(tick)
Step by Step Scenario

Below is the step-by-step scenario leading to the problem:

  1. 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=<local schema> before running.

Attached is the procedure which should be run on local base INT_CSV_CONTAINER.sql

  1. Run the procedure on a sql session.
  2. 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