Health Dashboard - Run Consolidation - GUI - Error - Failed to read SYS PACKAGE VERSION relation sys package version does not exist
Description
HD consolidation fails with the below error -
Failed to read SYS_PACKAGE_VERSION (ERROR: relation “sys_package_version” does not exist Position: 22)
Observed in CAST AIP
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
| 8.2.x | ✅ |
| 8.1.x | ✅ |
| 8.0.x | ✅ |
| 7.3.x | ✅ |
| 7.2.x | ✅ |
| 7.0.x | ✅ |
Observed on RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ❌ |
| Microsoft SQL Server | ❌ |
| CSS3 | ✅ |
| CSS2 | ✅ |
| CSS1 | ✅ |
Step by Step Scenario
- Create measurement base
- Launch HDConsolidation-GUI.exe
- fill the fields with appropriate central base, measurement base name & connection details
- Run consolidation
Action Plan
This error occurs when the schema does not exists or is not a cast schema.
- Check if you have a typo in the name of the database
- Re-do the consolidation after entering the correct schema name.
Impact on Analysis Results and Dashboard
Analysis - N/A Dashboard - N/A
Notes/comments
Related Pages