Check the MSM Config before running the upgrade as they use the MSM config to connect into the Database.
Prerequisites:
- Verify that you have the VC_Redist ran or the Upgrade_XXX.exe.
- Take a backup of the Database.
- Make a copy of the Manitou directory and rename it with the current version.
- Have operators write down some of the changes they have been working on in regards to their customer activity, address changes, new action patterns, or contact changes. After the upgrade the operators will go back and verify that those changes are still there before starting the FEP.
- Take a screenshot of the fep commander to quickly identify which receivers are not coming up if any after the upgrade.
- Take a screenshot of the license information for the server, as you will have to licence with the 1.6.3 License Manager.
Upgrade Procedure:
- Push out package 3, this will put the upgrade files in the manitou directory.
- Push the 1.6.3 Patch out to the server and all workstations.
- Rename the sqlbold.dll file int the manitou directory newsqlbold.dll
- From the backup you took of the manitou directory grab the old sqlbold.dll and put it into the now patched 1.6.3 directory
- Run the Upgrade_151.exe once, verify it completes then move on.
The 1.5.2 upgrade will only affect the current month and last month in the database. BObjects will need to be updated via normal upgrade procedures.
- Run the Upgrade_152.exe, once it crashes go into SSMS and edit the moptions table and change line 100 OPTCHAR to 1.5.1 and line 119 to 11 where its = 3
- Then run the following script to work through all the CLOG tables:
DECLARE @CLOGTable as nvarchar(10);
DECLARE @SQLString as nvarchar(1024);
SET NOCOUNT ON;
DECLARE CLOG_Cursor CURSOR FOR
SELECT NAME FROM SYSOBJECTS WHERE XTYPE = 'U' AND NAME LIKE 'CLOG%' ORDER BY NAME DESC
OPEN CLOG_Cursor
FETCH NEXT FROM CLOG_Cursor
INTO @CLOGTable
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT 'Processing Table: ' + @CLOGTable;
--// Entity SUBTYPE value moved from QUAL5 (VarChar) to QUAL8 (SmallInt)
SET @SQLString = N'UPDATE ' + @CLOGTable + N' '
+ N'SET ' + @CLOGTable + N'.QUAL8 = (SELECT MANITOU..CONTACT.SUBTYPE '
+ N' FROM MANITOU..CONTACT '
+ N' WHERE MANITOU..CONTACT.CONTTYPE = ' + @CLOGTable + N'.QUAL2 AND MANITOU..CONTACT.SERIALNO = ' + @CLOGTable + N'.QUAL3) '
+ N'WHERE ' + @CLOGTable + N'.EVTYPE = 3 AND ' + @CLOGTable + N'.QUAL = 1 ';
EXECUTE sp_executesql @SQLString;
SET @SQLString = N'UPDATE ' + @CLOGTable + N' '
+ N'SET ' + @CLOGTable + N'.QUAL8 = ' + @CLOGTable + N'.QUAL5 '
+ N'WHERE ' + @CLOGTable + N'.EVTYPE = 3 AND ' + @CLOGTable + N'.QUAL = 1 AND ' + @CLOGTable + N'.QUAL8 = NULL ';
EXECUTE sp_executesql @SQLString;
SET @SQLString = 'UPDATE ' + @CLOGTable + ' '
+ N'SET ' + @CLOGTable + N'.QUAL5 = NULL '
+ N'WHERE ' + @CLOGTable + N'.EVTYPE = 3 AND ' + @CLOGTable + N'.QUAL = 1 ';
EXECUTE sp_executesql @SQLString;
--// Capture CONTID into the agency reference comment CLOG records - used by reports for selection criteria (i.e., Custom Police)
SET @SQLString = 'UPDATE ' + @CLOGTable + ' '
+ N'SET ' + @CLOGTable + N'.KEYALM = (SELECT MANITOU..AUTHORITY.CONTID '
+ N' FROM MANITOU..AUTHORITY '
+ N' WHERE MANITOU..AUTHORITY.SERIALNO = ' + @CLOGTable + N'.QUAL3) '
+ N'WHERE ' + @CLOGTable + N'.EVTYPE IN (27,28,37) ';
EXECUTE sp_executesql @SQLString;
FETCH NEXT FROM CLOG_Cursor
INTO @CLOGTable
END
CLOSE CLOG_Cursor
DEALLOCATE CLOG_Cursor
PRINT 'Done.'
SET NOCOUNT OFF;- Run the Upgrade_153.exe twice. 1st run the upgrade with "Skip previous CLOGs" checked, then run the CLOG upgrade.
This can take a long time on a large database.
- Run the Upgrade_160.exe once, verify it completes then move on.
- Run the Upgrade_161.exe twice. 1st run the upgrade, then run the history upgrade.
- You need to rename the newSQLbold.dll to sqlbold.dll in the manitou directory from this point on.
- After this you install and use the 1.6.3 DBManager to do a database upgrade and health check.
Post Database upgrade Procedure:
- Install the 1.6.3 license manager and client and license the servers.
- After they have been licensed bring the msm up and do a start all on the broker.
- Have operators log in and verify the changes they wrote down pre upgrade are still there.
- Once they have verified the changes are there start the FEP.
- Verify that the receivers start back up as they were in the screenshot you took pre upgrade.
