Database Upgrade failed when upgrading from version 123 to Version 124

Database Upgrade failed when upgrading from version 123 to Version 124

book

Article ID: KB0082393

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.0

Description

 Statistica database upgrade fails while upgrading from Version 123 to Version 124 (while upgrading to Statistica version 13.0) .

    User-added image

Cause: One of the probable cause is that the database credential used for the upgrade does not have permission to create / update tables/ views in the database.  

Issue/Introduction

Database Upgrade failed when upgrading from version 123 to Version 124

Resolution

Note: The resolution is very specific to upgrade failing while updating Version 124. If the error indicates errors while upgrading to a different version, please open a case here.

1.  Connect to the Statistica meta database using a SQL Editor (such as SQL Server management Studio, Toad or SQL Developer depending on the database you are connecting to)  as a user with credentials to Create and drop tables.
2. Execute the below SQL commands :

      Drop Table CSEXDB;

      Drop View  CSEXDBV;

      Drop Table CSEXDBRN;

      Commit;

3.  Open Statistica login dialog and continue with the upgrade.

DISCLAIMER:

If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by TIBCO Statistica Support and Development.
Statistica Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it.
Powered by Wolken Software