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
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1.x | |
| 8.0.x | |
RDBMS | Yes/No |
|---|---|
| Oracle Server |  |
| Microsoft SQL Server | |
| CSS3 | |
| CSS2 | |
Step by Step scenario
- Upload a snapshot from the central to the measure schema
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
Ticket # 10248
