-
标题
SQL Update to 5.15 Update 1 or 2 fails -
说明
After installing 5.15 update 1 or 2 and opening the client, the database will be updated, but may fail with the following:
Connecting to Version Control store
[2/25/2021 1:58:42 PM] Current Database Name: 'GPOADmin'
[2/25/2021 1:58:42 PM] Current Database Version: '5.15.0.0'
[2/25/2021 1:58:42 PM] Script Version: '5.15.x.0'
[2/25/2021 1:58:42 PM] Executing: 'D:\Program Files\Quest\GPOADmin\Database Scripts\Upgrades\5.15.1.0\GPOADmin_5.15.x.0_Upgrade.sql'
[2/25/2021 1:58:42 PM] Removing Constraints...
[2/25/2021 1:58:43 PM] Constraints removed successfully.
[2/25/2021 1:58:43 PM] Updating the UndoItemCheckOut stored procedure...
[2/25/2021 1:58:43 PM] Stored procedure "UndoItemCheckOut" updated successfully.
[2/25/2021 1:58:43 PM] Updating the GetItemsFiltered stored procedure...
[2/25/2021 1:58:43 PM] Stored procedure "GetItemsFiltered" updated successfully.
[2/25/2021 1:58:43 PM] Updating AddDefaultRoles stored procedure...
[2/25/2021 1:58:43 PM] Stored procedure "AddDefaultRoles" updated successfully.
An exception occurred while executing a Transact-SQL statement or batch.
Error!
-
原因
Update script failed to run successfully. -
解决办法
Run the script manually in SQL management studio as follows (adjust to the correct script based on the update you installing)
- Log in to the GPOADmin SQL Server using SQL Server Management studio, as a user with sysadmin privileges.
- Take a backup of the GPOADmin database (Right-click > Tasks > Back up...)
- Copy GPOADmin_5.15.x.0_Upgrade.sql from C:\Program Files\Quest\GPOADmin\Database Scripts\Upgrades\5.15.x.0 on the GPOADmin server to the SQL server.
- Open the script in SQL Server Management Studio
- If your database is called GPOADmin, run the script as is.
- If you have changed the name of the database to something other than GPOADmin, please change lines 1, 1158 and 1161 to match your database name and run the script.The following message may be seen, but can be safely ignored as it is due to the upgrade failing through the client:
Msg 1781, Level 16, State 1, Line 662
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 662
Could not create constraint or index. See previous errors.
- Restart all GPOADmin services.
- Run the client, connect to SQL and no more errors will be seen.