-
Title
Upgrade from 6.1.1 to 6.5.1 failed when executing PR_SetPermissions store procedure -
Description
Upgrade from 6.1.1 to 6.5.1 failed when executing PR_SetPermissions store procedure with error found in QInstaller.log
EXEC PR_SetPermissions
THE ERROR DESCRIPTION IS:
Invalid object name 'dbo.PR_AddJob' -
Cause
The user account used to run the migration script (MessagestatsMigration.sql) doesn't have sufficient permission on SQL.
-
Resolution
Perform the following steps:
1. Make sure the user running the script has dbo, or even better sys admin privileges. If the user already has the required permission, continue to point 2 and 3.
2. Re-run MessageStatsMigration.SQL script. Please refer to "Steps on how to run MessageStatsMigration.SQL script" below in this article
3. Rename the version and build in T_Configuration table to Version 6.5.1 and Build 6.5.1.1276. Please refer to "Steps on how to rename version and build" below in this article
Steps on how to run MessageStatsMigration.SQL script:
1. Launch SQL Server Management Studio.
2. Connect to the SQL Server hosting the MessageStats Database (for example, Server Type = Database Engine, Server Name = SQL Server Name and Authentication = either Windows Authentication or SQL Server Authentication.
3. Expand SQL Server Name.
4. Expand Databases.
5. Right click on MessageStats Database and select New Query.
6. After the Query window opens, select the File | Open | File.
7. Locate the MessageStatsMigration.sql script on the server where MessageStats is installed (default location: C:Program FilesQuest SoftwareMessageStatsSQL)
8. Select the Query Menu and then Execute.
Steps on how to rename version and build:
1. Using SQL Server Management Studio locate the T_Configuration Table under the MessageStats database in Tables.
2. Right click the T_Configuration Table, select Open Table.
3. Change the following columns to:
Version = 6.5.1 ; Build = 6.5.1.1276 ; and then close the Table.