DB Update Error: "Database Update failed!!! Version rolled back to next earliest version completed"
Article ID: KB0081777
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 12.7 |
Description
When updating DB, the DB tries to update from Version 5.1.153 to 5.1.178. The DB update process seems to work to 169, and then there is an issue and a rollback to Version 168. When you try to open Statistica, the error messages appears:
"Database Update failed!!! Version rolled back to next earliest version completed".
And then when it tries to update (168 ->169), an Oracle error message appears: "ORA-01408: such column list already indexed".
Environment
Windows
Resolution
WORKAROUND:
When you get to version 169 and failed, drop all the indexes of CSSPCMNT. Here is how to do it:
1. Open SQLPlus
2. Execute this SQL: select index_name from user_indexes where table_name = 'CSSPCMNT'
3. It should show all the indexes
4. Take all the names and drop them with the command "drop index XYZ" where "XYZ" is an index name
5. Continue the database upgrade
STATUS:
This issue has been fixed in version 13.0 and higher. The latest version of Statistica can be downloaded here.
Issue/Introduction
DB Update Error: "Database Update failed!!! Version rolled back to next earliest version completed"
Feedback
Yes
No
Powered by
