[ronpaar]

We have an existing BES 4.1.0.38 running on an old server, which we want to move to a new server, by performing a Knife-edge cutover, based on BB KB10278.

I have followed all the tasks indicated in the article, including KB03112, How to move the BlackBerry Configuration Database to a new Microsoft SQL Server.

Here is where I have the problem. On the new server, which is a DC, I have to first install BES 3.6.2, which was the original version this company started with. Then, I have an upgrade CD for BES 4.1. When I try to run the upgrade, it fails at the User Migration stage. I will copy part of the UserMigration.log for reference.

Is there something I am missing?

Committing properties to the database
Failed to update/create database record. Error message "08/08/22 11:44:01 (TID 0x101C) TMServer '[ODBCRecord::DoSetValue] SQL error: [0x80040E14 Error 70000, severity 10, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.] Source: [Microsoft OLE DB Provider for SQL Server] SQL State: [42000] NativeError: [18054]'08/08/22 11:44:01 (TID 0x101C) TMServer '[ODBCRecord::DoSetValue] SQL error: [0x80040E14 Error 70010, severity 10, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.] Source: [Microsoft OLE DB Provider for SQL Server] SQL State: [42000] NativeError: [18054]'08/08/22 11:44:01 (TID 0x101C) TMServer '[ODBCRecord::DoSetValue] COM Error 0x80040E14 - 1869112 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Error 70000, severity 10, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage."'08/08/22 11:44:01 (TID 0x101C) TMServer '[ODBCRecord::DoSetValue] SQL = "UPDATE ServerConfig SET DisplayName = ?, SRPPort = ?, SRPHostName = ?, SRPid = ?, SRPKey = ?, ExternalServices = ?, RPCEndPoint = ?, OTAFMSupport = ?, OTAFMEnable = ?, MigrationComplete = ?, SessionId = ? WHERE Id = ?".'08/08/22 11:44:01 (TID 0x101C) TMServer '[ODBCRecord::DoSetValue] DATA = "DisplayName[LBRDC01] SRPPort[3101] SRPHostName[srp.na.blackberry.net] SRPid[S4943184] SRPKey(first 32 bytes)[2c7j-yea6-r7ps-c5py-ydhk-adnu-88] ExternalServices[1] RPCEndPoint[\pipe\BESMonitorLBRDC01] OTAFMSupport[15] OTAFMEnable[1] MigrationComplete[0] SessionId[0] Id[1] ".'", Error code -1
BlackBerry Server LBRDC01: Failed to acquire or update
BlackBerry Server LBRDC01: Failed to update
Migrating properties
Property SessionId: Migrating...
Property PeerToPeerKeyData: Migrating...
Committing properties to the database
Database record successfully created/updated
BlackBerry Server LBRDC01: Peer to peer key sequence added
Migration finished with return code 12004
Writing status to file C:\Program Files\Research In Motion\BlackBerry Enterprise Server\Logs\Installer\UserMigrationStatus.bin
Status written to C:\Program Files\Research In Motion\BlackBerry Enterprise Server\Logs\Installer\UserMigrationStatus.bin
Uninitializing migration module
Disconnecting the database
Database disconnect OK
Closing the log file
=== Log ended on 8/22/2008 at 11:44:1

Any help would be greatly appreciated.

Ron

[shuman]

Does your old BES server and the new server have the same name? If you are using the same DB as the old BES server it must have the same name. I am assuming that you don't have TSupport with RIM?

[ronpaar]

Originally Posted by shuman

Does your old BES server and the new server have the same name? If you are using the same DB as the old BES server it must have the same name. I am assuming that you don't have TSupport with RIM?

Yes, I have tried to use the same name as the old BES. I have tried to follow KB10278, How to perform a knife-edge cutover for BES software versions 4.0 and 4.1. I think the issue is when I am trying to move the BlackBerry Configuration Database to the new server, KB03112.

I just started at this new company, and this project had been put on hold for quite sometime. I have been a BlackBerry admin for several years, but, never had to perform this type of move/upgrade.

The company does not currently have TSupport with RIM.

Ron

[ronpaar]

You can close this, I think I have this resolved.

Ron

[CanadianCrack]

Hi Ron,
I have plans to do a knife-edge cutover.
If you don't mind me asking....why was it failing and
what did you do to fix it?

[ronpaar]

Originally Posted by CanadianCrack

Hi Ron,
I have plans to do a knife-edge cutover.
If you don't mind me asking....why was it failing and
what did you do to fix it?

Well, there must have been something done incorrectly, as we were also using an outside source to assist with this.

I simply undid what was done, and followed the steps one by one, and was successful. The two issues I faced after getting 4.1 on the new server is:

1. Had to remove and add 5 users, who had the original 3.6 licenses. Once I removed them from the server, wiped their devices, added them back, and ran Enterprise Activation, they were up and running.

2. Had a problem with MDS, which I recently discovered cannot be used if you are running Microsoft SQL Server 2005 Express, so, I will need to uninstall this, as we are not using it.

Ron