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

Cause

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

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

Have more questions?

Was this article helpful?

0 out of 0 found this helpful

Provide feedback for the Documentation team!