Health Dashboard - Run Consolidation - CLI - Error - Integer out of range
Purpose (problem description)
This page handle the issue of the below error seen in the command prompt while uploading snapshot from the central schema to the measure schema via the CLI. Please refer Using the GUI and CLI tools for Health Dashboard
org.postgresql.util.PSQLException: ERROR: integer out of range
Observed in CAST AIP
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
| 8.2.x | ✅ |
| 8.1.x | ✅ |
| 8.0.x | ✅ |
Observed on RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ❌ |
| Microsoft SQL Server | ❌ |
| CSS3 | ✅ |
| CSS2 | ✅ |
Step by Step scenario
- Upload a snapshot from the central to the measure schema
Action Plan
- If you are using an AIP version lower then 8.2.8, then this can be due to the fact that the table DSS_HISTORY of the measure schema is corrupted. Surely there were too many message logs and the serial history_id has been overpassed. Limit is 2.147.483.647, and even when table is empty (has been truncated), the serial does not return to 0. In order to check that and remediate refer to SQL Queries - CAST Measure Base - Checking and removing corruptions - integer out of range for dss_history table
- If the above steps do not solve your issue then contact CAST Technical Support with the following Relevant input
Notes/comments
Ticket # 10248
Related Pages