Upgrading a database is timing out.

Owned by Beth Blok (Unlicensed)
Last updated: Sept 26, 2019
1 min read

Upgrading a database may report a timeout error when running a particular script.

Step-by-step guide

SQL Knowledge is required

A working knowledge of SQL Management Studio is required to complete this task

Follow these steps to allow the upgrade to complete.

  1. Upgrade until timeout error occurs

  2. Copy the failed script from the SY_UpgradeScripts table (SELECT * FROM SY_UpgradeScripts WHERE Status =2), and run it manually in SQL Management Studio (it has no timeout)

  3. Update the failed script's status to Succeeded in the SY_UpgradeScripts table (UPDATE SY_UpgradeScripts SET Status = 1 WHERE Status =2)

  4. Run the upgrade again, choosing to "Resume"

  5. Repeat steps 2 to 4 for each timeout until the upgrade is complete