BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-08-2011, 06:52 PM   #1 (permalink)
BlackBerry Extraordinaire
 
Join Date: Mar 2006
Model: 9700
Carrier: t-mobile Germany
Posts: 1,362
Post Thanks: 11
Thanked 69 Times in 66 Posts
Default Moving database - "Error initializing system" Catch22 ?

Please Login to Remove!

I moved the Database of a BES 5.0.3 for Exchange to a different SQL server, using the detach and reattach method described in KB03112-How to move the BlackBerry Configuration Database to a new Microsoft SQL Server instance .

However, after that, as the article tells, the BES controlpanel has no GUI for changing the database server. Instead, it recommends to run the setup application again.
Now, when I did that, the setup will hang a little and then quit with the error message "Error initializing system".
I looked this up, and it is documented as a problem with BES 5.0.2, no resulution known. As a workaround, you have to remove the Entry of the Database server from the registry.
Ok, I did this, and even did a restart afterwards.
Still, the setup refused to start, same error message.
Since in the registry key is the name of the database server, I restored that from a previous backup i made, and, manually changed the name of the Database server, restarted, and it looked like everything was ok.

I checked again, if the setup will now start because the database server was correct, but no. Same error, but since the server was working I ignored this problem.

Then, I thought, I clean up a little, and, removed the local Sql 2005 express server. After this and a reboot, a ton of error messages appeared in the applications log, and some of the BES services did not start.

After reading the logs It turned out, that the deinstallation of SQL Express did remove the msxml6 parser. Since I did not know, what else might have been removed, I tried to reinstall the BES. But, this was impossible since it keeps telling ""Error initializing system".
I could not fix that, and because I did not wanted to start from scratch I reinstalled msxml6 and now ther server works again.

Question:
What do I loose if I remove all registry entries in the system and reinstall the BES ?
What went wrong during the database move ? You have to turn off the server, then detach the databases. Of course, afterwards the server/the setup will not find the previous sql-server because it has been moved, but its unlikely that i am expected to do a clean install after moving the database.

any thoughts ?

Last edited by nobody7290 : 08-08-2011 at 06:55 PM.
Offline  
Old 08-13-2011, 02:32 PM   #2 (permalink)
BlackBerry Extraordinaire
 
Join Date: Mar 2006
Model: 9700
Carrier: t-mobile Germany
Posts: 1,362
Post Thanks: 11
Thanked 69 Times in 66 Posts
Default Re: Moving database - "Error initializing system" Catch22 ?

This is getting annoying and making me nervous a little.

I tried to install Maintenance release 3 for 5.0.3, but no joy, the installer cannot login on the database or does not find it.

Below, two logs:
one old log from a previous upgrade installation some time ago which was succesful
one new log from the current installation, where it fails.

old log:
Code:
[40000] (05/14 22:58:49.324):{0xD84} {DbConfig::setConfigValues} No Encoded SQL Auth keys found
[40000] (05/14 22:58:49.324):{0xD84} {DbConfig::setConfigValues} No SQL Auth keys found
[30000] (05/14 22:58:53.710):{0xD84} ADO ConnectionTimeout value = 30s
[30000] (05/14 22:58:53.710):{0xD84} ADO ConnectionTimeout for re-initalizing the pool = 45s
[45059] (05/14 22:58:53.756):{0xD84} {ConnectionPool::PostConnectWork()}: Using connection pool with limit of 100 connections
[30000] (05/14 22:58:53.772):{0xD84} [ENV] [DB] Connection String = Server=MY-DBSERVER,1433;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[30000] (05/14 22:58:53.772):{0xD84} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 09.00.4035;  Provider Name = sqlncli.dll;  Provider Friendly Name = Microsoft SQL Native Client;  OLE DB Version = 02.80;  Provider Version = 9.00.4035.00;  Failover Partner =
[35019] (05/14 22:58:53.772):{0xD84} [ENV] [DB] Database Schema Version:  5.0.3 <5.0.2011.02.11>
[40000] (05/14 22:58:53.772):{0xD84} Connected to BESMgmt successfully.
new (unsucessfull install attempt) log:
Code:
[40000] (08/13 20:47:05.477):{0x2324} {DbConfig::setConfigValues} No SQL Auth keys found
[30000] (08/13 20:47:23.724):{0x2324} ADO ConnectionTimeout value = 30s
[30000] (08/13 20:47:23.724):{0x2324} ADO ConnectionTimeout for re-initalizing the pool = 45s
[25137] (08/13 20:47:56.381):{0x2324} 
[25000] (08/13 20:47:56.381):{0x2324}  IDS_25000               ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unbekannter Fehler - Source: Microsoft OLE DB Provider for SQL Server - Description [DBNETLIB][ConnectionOpen (Connect()).]SQL Server existiert nicht oder Zugriff verweigert. - Command: ConnectionItem::ConnectToDB
[10000] (08/13 20:47:56.381):{0x2324} [CDBComp::ConnectToHost]: Cannot connect to DB server.
[30000] (08/13 20:47:56.381):{0x2324} Step GatherInfo failed
[10000] (08/13 20:47:56.381):{0x2324} [CDataStore::GatherProdInfo]: Failure in ProdDataCon
Sorry, the installation log is in german, I can translate this in english if that help if someone is interested.

my best guess today was, to install the SQL native client for SQL2008R2 (which is where the database is running now), but this did not help.

TIA for an Idea.
Offline  
Old 08-15-2011, 12:03 PM   #3 (permalink)
BlackBerry Extraordinaire
 
Join Date: Mar 2006
Model: 9700
Carrier: t-mobile Germany
Posts: 1,362
Post Thanks: 11
Thanked 69 Times in 66 Posts
Default Re: Moving database - "Error initializing system" Catch22 ?

This was a problem ME not reading the instructions in the KB article to the end.

The article says, you have to remove/change the entry in:
HKEY_LOCAL_MACHINE\SOFTWARE\Research In Motion\BlackBerry Enterprise Server
Remove the Database registry key

however, the article continues, and you also have to do the same in:
HKEY_CURRENT_USER\SOFTWARE\Research In Motion\BlackBerry Enterprise Server

the BES installer obviously does only check the value under HKCU but not under HKLM.

RTFM and dont think that just because you did somthing several times you remeber everything correct.
Offline  
The Following User Says Thank You to nobody7290 For This Useful Post:
knottyrope (08-15-2011)
Old 08-15-2011, 03:53 PM   #4 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,724
Post Thanks: 272
Thanked 288 Times in 272 Posts
Default Re: Moving database - "Error initializing system" Catch22 ?

nice catch
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Offline  
Old 08-15-2011, 04:59 PM   #5 (permalink)
BlackBerry Extraordinaire
 
Join Date: Mar 2006
Model: 9700
Carrier: t-mobile Germany
Posts: 1,362
Post Thanks: 11
Thanked 69 Times in 66 Posts
Default Re: Moving database - "Error initializing system" Catch22 ?

I am still banging my head against an invisible wall because of this.

catched by the own arrogance.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads for: Moving database - "Error initializing system" Catch22 ?
Thread Thread Starter Forum Replies Last Post
BB and a NATIVE linux desktop manager gijimbo911 Linux Users Corner 0 02-01-2010 04:02 PM
BES 5.0 Exchange/Domino final documentation posted illy BES Admin Corner 9 05-12-2009 11:16 AM
Need help moving BES database from one SQL2000 server to another (createdb.exe) visabureau BES Admin Corner 10 09-25-2008 06:09 PM
BES 4.1 SP2 for Microsoft Exchange - Now Available jibi BES Admin Corner 51 01-10-2007 09:30 AM
HOWTO: Migrate MSDE2K or SQL2K database to new server jibi BES Admin Corner 18 09-14-2005 11:20 PM





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.