Removing user from one database to another

[loicdonadieu]

Hi all,

We've been having issues with our BES insofar that when it is rebooted (Windows updates, etc), a number of handsets no longer connect. Previously we have just removed/reactivated the devices, but it is becoming a bit of a pain, especially with the MD's device not working whilst he's on holiday right now.

Looking at the error log, this is displaying:

User <user@address.com> appears to be running on a BES administered with separate database. Other database user id = 100, our database user id = 105. When this problem is addressed please reload the user.

Googling returned this handy document:
http://www.blackberry.com/btsc/artic...es/TA00158.pdf

which recommends the following action:
"The BlackBerry device user exists on two separate BlackBerry Configuration Databases.
Troubleshooting: Remove the BlackBerry smartphone user from the original BlackBerry® Configuration Database before adding the BlackBerry device user to the new BlackBerry Configuration Database."

How about do I go about performing the above?

Thanks in advance for your help.

[GaryCutri]

Hi,

Do you have more than one BlackBerry server in your domain? Also when you open BlackBerry Manager is there more than one server listed? In the past I have seen this error when a trial BES (or old BES) was setup and then a new BES was installed with a new database. The error was caused by the users not being removed from the old BES before being added into the new server. To correct this issue I have connected the BES (without starting the services) to the existing database and removed the user/s.

Thanks,

Gary

[loicdonadieu]

Hi Gary, thanks for the reply.
We only have one BES. There is only one server and the corresponding _MDS-CS_1 connection service listed within the manager. I'm pretty sure this was all set up at once ie we didn't upgrade from a Trial install or anything.

The curious thing is that, as I mentioned, we fix the issue by deleting the users, then re-creating them. Surely this should have created the users in the correct 'new' database? Where can I find where about the user's data is stored?

Thanks once again.

[GaryCutri]

Originally Posted by loicdonadieu

Hi Gary, thanks for the reply.
We only have one BES. There is only one server and the corresponding _MDS-CS_1 connection service listed within the manager. I'm pretty sure this was all set up at once ie we didn't upgrade from a Trial install or anything.

The curious thing is that, as I mentioned, we fix the issue by deleting the users, then re-creating them. Surely this should have created the users in the correct 'new' database? Where can I find where about the user's data is stored?

Thanks once again.

If you have full SQL just open the Manager and see if any other database have been created. If you have MSDE or SQL 2005 Express just install SQL Server Management Studio Express which will enable you to view all the active databases. Let us know what you find and we can help you from there.

[loicdonadieu]

Ok, here's what I have found out:

Before I had joined the company, the BES database was stored on a SQL express 2005 Server, after which, an external engineer came and migrated the data to a different server that has full SQL Server 2005.

I've had a look in the SQL express server and cannot see any reference to the old BES database whatsoever. It appears to have been removed cleanly.
The only thing I think it could be would be a link in the migrated database that referrs to the old server somehow.
Is there a way of checking this?

Again, thanks for all your assistance.

[GaryCutri]

Originally Posted by loicdonadieu

Ok, here's what I have found out:

Before I had joined the company, the BES database was stored on a SQL express 2005 Server, after which, an external engineer came and migrated the data to a different server that has full SQL Server 2005.

I've had a look in the SQL express server and cannot see any reference to the old BES database whatsoever. It appears to have been removed cleanly.
The only thing I think it could be would be a link in the migrated database that referrs to the old server somehow.
Is there a way of checking this?

Again, thanks for all your assistance.

If you have access to the database in SQL Manager you can open the ServerConfig table and that will display the servers configured in that database.

[loicdonadieu]

I logged into the SQL 2005 Server, went to the ServerConfig table and did a Script -> Select to to inspect everything, and could not see a reference to the old server in the table. Was this the correct process?

if so, then perhaps there's a way to inspect all the tables for a reference to the old server?

Thanks again.

[GaryCutri]

Originally Posted by loicdonadieu

I logged into the SQL 2005 Server, went to the ServerConfig table and did a Script -> Select to to inspect everything, and could not see a reference to the old server in the table. Was this the correct process?

if so, then perhaps there's a way to inspect all the tables for a reference to the old server?

Thanks again.

You can just right mouse click the table and select Open table. In the table view each server will be listed on a separate row. When you deleted the users account from the BES did you select the option to remove the BlackBerry information from the user’s mailbox?

[loicdonadieu]

Hi, yes, this returns the same info: no references to the old server.

This is the curious thing, we remove the user completely, selecting the option to remove all data, then re-add it. It's only a select few (I think 5) users who when you re-add them, somehow seem to be recreated with older data.

[GaryCutri]

Originally Posted by loicdonadieu

Hi, yes, this returns the same info: no references to the old server.

This is the curious thing, we remove the user completely, selecting the option to remove all data, then re-add it. It's only a select few (I think 5) users who when you re-add them, somehow seem to be recreated with older data.

I still think you may have an old Blackberry server or configuration database sitting on a SQL or MSDE server somewhere in your network.