How to resolve the error "Updating to 205 fails... unique contraint violated" after upgrading from Spotfire Statistica 14.x to 14.2
Article ID: KB0070038
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 14.x and 14.2 |
Description
When launching Statistica for the first time, after successfully upgrading from 14.x to 14.2, e.g., from 14.0.1 to 14.2, the login dialog appears:
After a successful login, the database schema update dialog will run:
After clicking OK to perform the update, this error appears:
After a successful login, the database schema update dialog will run:
After clicking OK to perform the update, this error appears:
Environment
OS: Windows
Resolution
The "Approver (APPRV)" row in the CSPERM table must be removed from the metadatabase so the schema can be updated successfully.
Important Note: Back up the metadatabase before making any changes.
The SQL commands to remove the "Approver (APPRV)" are below:
1. Find the corresponding entry in the CSPERM table:
SELECT PERMID
FROM CSPERM
WHERE NAME = "Approver (APPRV)"
This will give you the PERMID to be used in the next two statements.
2. DELETE FROM CSGPRM
WHERE PERMID ='<PERMID>'
3. DELETE FROM CSPERM
WHERE PERMID ='<PERMID>'
Important Note: Back up the metadatabase before making any changes.
The SQL commands to remove the "Approver (APPRV)" are below:
1. Find the corresponding entry in the CSPERM table:
SELECT PERMID
FROM CSPERM
WHERE NAME = "Approver (APPRV)"
This will give you the PERMID to be used in the next two statements.
2. DELETE FROM CSGPRM
WHERE PERMID ='<PERMID>'
3. DELETE FROM CSPERM
WHERE PERMID ='<PERMID>'
Issue/Introduction
How to resolve the error "Update to database schema 205" fails after upgrading from 14.x to 14.2
Was this article helpful?
Yes
No
Powered by
