This page provides solution if the snapshot is stuck at Compute Snapshot phase and in the DSSEngine log you can see below messages:
2016-06-02 11:40:40.345 SQL error (Local): ORA-01008: not all variables bound (sev 1, MsgNo 1008)
2016-06-02 11:40:40.376 ERROR while writing table DSS_METRIC_DESCRIPTIONS
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x, x< 1 | |
8.0.x | x<3 |
7.3.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 |
Below is the step-by-step scenario leading to the problem:
- Run Snapshot
The impact of the problem on the analysis or the dashboard is:
Snapshot stuck at Compute Snapshot phase
The performance issue is located in the stored procedure DSSAPP_FP_APP_DATAFUNC.
Attached is an optimized procedure for 8.0 ( DSSAPP_FP_APP_DATAFUNC.sql ), and an optimized procedure for 7.3 (DSSAPP_FP_APP_DATAFUNC-73.sql)
To fix the problem, proceed as follows:
- Install the procedure in the local base.
- Run the snapshot after running the procedure,
Impact of the solution on the analysis or the dashboard is: Snapshot runs successfully.
Ticket # 5716 for 8.0
Ticket # 6852 for 7.3
This issue has been fixed in 8.0.3.