Skip to end of metadata
Go to start of metadata

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