Ask the Community
Groups
Schema fails when upgrading from old versions to the new - Connect IT Community | Kaseya
<main> <article class="userContent"> <h1 data-id="problem"><strong>Problem</strong></h1> <p>When the VSA update is run from 9.2 to new, it fails with the below error</p> <p> </p> <p><em>Fatal MessageSys Error: CoreVsa/script/scriptStatusIdToBigint.sql</em></p> <p> </p> <p><em><img src="https://us.v-cdn.net/6032361/uploads/migrated/OWFA52OQD11C/mceclip0.png" alt="mceclip0.png" class="embedImage-img importedEmbed-img"></img></em></p> <p> </p> <h1 data-id="cause"><strong>Cause</strong></h1> <p><em>Indexes on the table scriptStatus table are dependent on the table's column called 'id'</em></p> <p> </p> <p><em><img src="https://us.v-cdn.net/6032361/uploads/migrated/55IJ8AE5Q5SH/mceclip1.png" alt="image" class="embedImage-img importedEmbed-img"></img></em></p> <h1 data-id="resolution"> <strong>Resolution</strong> </h1> <p> </p> <p>Manually drop the indexes that are giving the issues by running the query below.<br><br></p> <p><em>DROP INDEX index_name ON scriptStatus</em></p> <p>Now rerun the Database schema which should fix the issue.</p> <p> </p> <p><strong>APPLIES TO </strong>(if applicable) 9.2 and above<br><br><br></p> </article> </main>