Schema fails when upgrading from old versions to the new

Problem

When the VSA update is run from 9.2 to new, it fails with the below error

 

Fatal MessageSys Error: CoreVsa/script/scriptStatusIdToBigint.sql

 

mceclip0.png

 

Cause

Indexes on the table scriptStatus table are dependent on the table's column called 'id'

 

Resolution 

 

Manually drop the indexes that are giving the issues by running the query below.

DROP INDEX index_name ON scriptStatus

Now rerun the Database schema which should fix the issue.

 

APPLIES TO (if applicable) 9.2 and above


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us