CMS Snapshot Analysis - Compute Snapshot - Performance Issue - SQL error Local ORA-01008 not all variables bound
Description
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
Observed in CAST AIP
| Release | Yes/No |
|---|---|
| 8.3.x | ❌ |
| 8.2.x | ❌ |
| 8.1.x, x< 1 | ✅ |
| 8.0.x | ✅ x<3 |
| 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:
- Run Snapshot
Impact of the Problem
The impact of the problem on the analysis or the dashboard is:
Snapshot stuck at Compute Snapshot phase
Action Plan
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
Impact of the solution on the analysis or the dashboard is: Snapshot runs successfully.
Notes/comments
Ticket # 5716 for 8.0
Ticket # 6852 for 7.3
This issue has been fixed in 8.0.3.
Related Pages