Migrating from corrupt BES 4.1 to new BES 4.1

[BDO]

Hi all,

My BES4.1 is having disk corruption issues so i've build another BES4.1 server.

I was unable to "Migrate the BlackBerry Enterprise Server to new hardware.htm" doco as it would not see the "old" server.

So I want to migrate the db from the old BES4.1 to the new BES4.1.
I'm using MSDE as the DB.

I'm following this document...
How to move the BlackBerry Configuration Database to a new Microsoft SQL Server or instance. Doc ID : KB03112

I keep getting the following error when trying to detach the DB.

1> osql -E -S blackberry\besmgmt
2> exec sp_detach_db @dbname = "blackberry\besmgmt"
3> go
Msg 170, Level 15, State 1, Server BLACKBERRY, Line 1
Line 1: Incorrect syntax near 'E'.

No matter what I put as Line 1 for the blackberry server and besmgmt it gives the same error.

I've tried...
besmgmt
blackberry\besmgmt
the above with "" quotes around it, as well as "< >" around the above examples. I believe the original setup was pretty standard.

Any ideas how to either do the above or another doc/way to migrate to a new BES4.1 server?

Thanks.

[GaryCutri]

Originally Posted by BDO

Hi all,

My BES4.1 is having disk corruption issues so i've build another BES4.1 server.

I was unable to "Migrate the BlackBerry Enterprise Server to new hardware.htm" doco as it would not see the "old" server.

So I want to migrate the db from the old BES4.1 to the new BES4.1.
I'm using MSDE as the DB.

I'm following this document...
How to move the BlackBerry Configuration Database to a new Microsoft SQL Server or instance. Doc ID : KB03112

I keep getting the following error when trying to detach the DB.

1> osql -E -S blackberry\besmgmt
2> exec sp_detach_db @dbname = "blackberry\besmgmt"
3> go
Msg 170, Level 15, State 1, Server BLACKBERRY, Line 1
Line 1: Incorrect syntax near 'E'.

No matter what I put as Line 1 for the blackberry server and besmgmt it gives the same error.

I've tried...
besmgmt
blackberry\besmgmt
the above with "" quotes around it, as well as "< >" around the above examples. I believe the original setup was pretty standard.

Any ideas how to either do the above or another doc/way to migrate to a new BES4.1 server?

Thanks.

In this situation I would just install the free SQL 2005 Express Manager and use this to perform the backup and install. Using this manager will give you a much simpler means of moving and restore the database; also it will allow you to edit the SQL tables (e.g. edit the ServerConfig & MDSConfig table to update the server name once the move is performed)

[BDO]

Thanks Gary,
worked a charm!

[GaryCutri]

Originally Posted by BDO

Thanks Gary,
worked a charm!

That's great to hear and thank you for the feedback.

[BDO]

Hi all,

after fixing the CDO.dll version problem (i hope) after the corruption, i am getting the following errors in the application error log...


BlackBerry Messaging Agent BLACKBERRY2 Agent 1
Event ID 20216
Synchronize() failed: ERR_FAIL, Tag=5814


and every second error message has...


BlackBerry Router
Event ID 10000
[SERVICE_RELAY_SESSION:S79181847:00b92738] Service transaction not found. SERVICESESSION_TAG=17107345

I'm still searching forums but any clues appreciated.

[GaryCutri]

Originally Posted by BDO

Hi all,

after fixing the CDO.dll version problem (i hope) after the corruption, i am getting the following errors in the application error log...


BlackBerry Messaging Agent BLACKBERRY2 Agent 1
Event ID 20216
Synchronize() failed: ERR_FAIL, Tag=5814


and every second error message has...


BlackBerry Router
Event ID 10000
[SERVICE_RELAY_SESSION:S79181847:00b92738] Service transaction not found. SERVICESESSION_TAG=17107345

I'm still searching forums but any clues appreciated.

Assuming BES is on a separate server to Exchange and you are running Exchange 2003 please do the following:

1. Stop all the Blackberry Services and disable them

2. Uninstall Exchange System Manager (you need to be logged on as Administrator to complete this task)

3. If Outlook is installed on the BES uninstall it

4. Search the server for any other cdo.dll or mapi32.dll files and unregister them (e.g. regsvr32 /u c:\windows\system32\cdo.dll)

5. Restart the BlackBerry server

6. Install Exchange System Manager

7. Install any Exchange service packs on Exchange System Manager that are on you main server (e.g. SP2). To check this details log onto the main Exchange server and go to Add\Remove programs and select the "Show Updates" option.

8. Go to START > Programs > BlackBerry Enterprise Server and open “Edit MAPI Profile” and ensure the profile is set to BESadmin.

9. Go to START > Programs > BlackBerry Enterprise Server > Blackberry Server Configuration and from the Blackberry Server tab open “Edit MAPI Profile”. Confirm that the MAPI profile is set to BESadmin

10. Set all the Blackberry Services back to automatic and restart the Blackberry server.

[BDO]

Hi Gary,

1. Stop all the Blackberry Services and disable them
Done.

2. Uninstall Exchange System Manager (you need to be logged on as Administrator to complete this task)
Done.

3. If Outlook is installed on the BES uninstall it
Outlook express was there and I left it there. Full blown Outlook was not installed.

4. Search the server for any other cdo.dll or mapi32.dll files and unregister them (e.g. regsvr32 /u c:\windows\system32\cdo.dll)
Done.

5. Restart the BlackBerry server
Done.

6. Install Exchange System Manager
Done.

7. Install any Exchange service packs on Exchange System Manager that are on you main server (e.g. SP2). To check this details log onto the main Exchange server and go to Add\Remove programs and select the "Show Updates" option.
Done.

8. Go to START > Programs > BlackBerry Enterprise Server and open “Edit MAPI Profile” and ensure the profile is set to BESadmin.
Done.

9. Go to START > Programs > BlackBerry Enterprise Server > Blackberry Server Configuration and from the Blackberry Server tab open “Edit MAPI Profile”. Confirm that the MAPI profile is set to BESadmin
Done.

10. Set all the Blackberry Services back to automatic and restart the Blackberry server.
Done.


What is happening now is still lots of errors as below...

Synchronize() failed: ERR_FAIL, Tag=

[SERVICE_RELAY_SESSION:S79181847:00b91fb0] Service transaction not found. SERVICESESSION_TAG=21850841

Unable to save configuration settings or statistics

ReloadFolders LoadFolderList failed

MAPIMailbox::LoadFolderList - OpenEntry (0x80040115) failed

GetNewMessages() failed: ERR_NETWORK_PROBLEM

MAPIMailbox::GetNewMessages - GetContentsTable (0x80040115) failed

MAPIMailbox::GetNewMessages - GetProps (0x80040115) failed


These are not all one after the other. The most common is...
"Unable to save configuration settings or statistics"

I've noticed that some users BBs have not been contacted by the BB server for over 9 hours. However these users are in Hong Kong and the BB server is in Sydney. Could this be communication problem or config problem?

Is it worth rebuilding the BB server again?
The original BB server was called blackberry. This new server I've called blackberry2. That's because the original was hobbling along while the new one came into being. Should I rebuild another called blackberry and chuck the backup of the original BB server on it?

Anyway thanks for your help.
Ben

[GaryCutri]

What did you set the MAPI profile to when you went to "Edit MAPI Profile"? You may need to log on as your BlackBerry client (e.g. BESadmin) and edit the profile again and ensure it is set to BESadmin (assuming this is the account configured to have to correct access to exchange).

[BDO]

sorry about the time to reply.
still getting lots of errors.
the mapi profile is pointing to the besadmin user on the correct email server.

with faulty calendar items where the time is off by 1 hour, I have had some success in creating a duplicate calendar entry exactly the same as the faulty entry, but with the correct times. if the new entry is correct then i've deleted the incorrect one.

i also tried deleting the entire calendar from the BB and re-syncing it. the calendar came down with the same incorrect entries but they were correct on exchange.

[GaryCutri]

Originally Posted by BDO

sorry about the time to reply.
still getting lots of errors.
the mapi profile is pointing to the besadmin user on the correct email server.

with faulty calendar items where the time is off by 1 hour, I have had some success in creating a duplicate calendar entry exactly the same as the faulty entry, but with the correct times. if the new entry is correct then i've deleted the incorrect one.

i also tried deleting the entire calendar from the BB and re-syncing it. the calendar came down with the same incorrect entries but they were correct on exchange.

At this stage I would consider creating a new BlackBerry Service Account (I believe the current profile is corrupt) and setting all the required permissions on the server and within Exchange. Once the account is created log onto the server with this new account and install the latest service pack (SP6) and it will recreate the registry entries and MAPI profiles for BES. Worst case scenario we can clean uninstall of BES (leaving the database intact) and then reinstall using the newly created BlackBerry account.