Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

Reply
New Contributor
Posts: 2
Registered: ‎08-19-2012
My Device: Torch 9800
My Carrier: Vodafone
Accepted Solution

BES 4.1.7 and/or 5.0 upgrades failing with SQL errors

I've recently started a new job at a company that has an old BES environment, and I'm in the process of getting it updated and moved to new hardware.

 

I'm running in to some issues whilst trying to perform database upgrades from version 4.1.7 or higher.

 

Some background on the BES setup:

 

Original envorinment = BES version 4.1.5 on a Win2K3 server, with it's database on a SQL 05 cluster.

 

New environment = Will be performing a cut over to BES version 5.0.3 on a new Win2K8 R2 server, with the database on a SQL 08 R2 cluster.

 

Current enivornment = BES version 4.1.6 MR7 on existing Win2K3 server, with it's database on the SQL 08 R2 cluster.

 

1. I have moved the database from the older SQL 05 cluster to the new SQL 08 R2 cluster. I have configured the existing BES server/manager to point to this new cluster. All services are running fine after the move.

 

2. I attempted to install version 5.0 on a new server and perform a cut over upgrade using the existing BB config database. This resulted in a SQL error being thrown up during the database upgrade process.

 

I tried doing some investigation on this error but found minimal info.

 

I suspected that the existing database may of had database issues, and figured an incremental upgrade approach may help correct them. I then upgrades the existing BES to version 4.1.6, followed by the MR7 update. These both applied without issue.

 

I then tried to upgrade to 4.1.7, but this is also throwing up the same SQL error that the 5.0 upgrade did.

 

I have tried manually updating the database by running the "createdb" application, but this also results in the same SQL error.

 

Going through the log files from the "createdb" process, the errors being reported (by both version upgrades) are as below:

 

[30000] (08/20 10:57:14.951):{0x18C0} SQL being executed:   IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_ITAdminQueue_UserConfig' AND type = 'F')     ALTER TABLE ITAdminQueue ADD CONSTRAINT FK_ITAdminQueue_UserConfig FOREIGN KEY (UserConfigId)         REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE [20000] (08/20 10:57:14.967):{0x18C0} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E2F - IDispatch error #3119 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_ITAdminQueue_UserConfig". The conflict occurred in database "BESMgmt", table "dbo.UserConfig", column 'Id'." Native error = 547 [20000] (08/20 10:57:14.967):{0x18C0} [CBESDBInstaller::ExecuteDDL] SQL Error for:   IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_ITAdminQueue_UserConfig' AND type = 'F')     ALTER TABLE ITAdminQueue ADD CONSTRAINT FK_ITAdminQueue_UserConfig FOREIGN KEY (UserConfigId)         REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE ====== END OF LOG ======

 

I am not familiar enough with SQL to work out exactly what it is trying to do, and what it is exactly failing on.

 

Is anyone here able to offer any advice, or am I bes off logging a support ticket with RIM?

 

Cheers!

 

 

Blackberry Certified Support Specialist (v5.0)
Guru III
Posts: 32,116
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry PRIV, Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook,BT Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BES 4.1.7 and/or 5.0 upgrades failing with SQL errors

4.x is not supported on SQL 2008.

 

Blackberry Enterprise Server compatibility chart
http://us.blackberry.com/support/software/server_compatibility.jsp#tab_tab_compatibility

 

for those SQL errors I would call RIM now that you hav moved to it.

 

you might be OK moving back to 2005

 

KB03112 - How to move the BlackBerry Configuration Database to a new Microsoft SQL Server instance

 

 

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


New Contributor
Posts: 2
Registered: ‎08-19-2012
My Device: Torch 9800
My Carrier: Vodafone

Re: BES 4.1.7 and/or 5.0 upgrades failing with SQL errors

Thanks for the reply.

 

I did notice that SQL 08 wasn't supported by BES 4.1.X after I have moved the database, so ended up moving it back to the SQL 05 cluster almost straight away.

 

Regardless of whether the database was on SQL 05 or 08 it still had the same error.

 

I end up getting through to RIM after logging an incident with our Telco, and RIM basically said to forget about doing cut over with existing config database. I don't know whether the error was fixable... I assume it was but it was quicker/easier for them to say start from scratch.

 

I ended up doing a new install of 5.0.3, creating a new config database, and moving all of the users over with the BB enterprise transporter tool.

Blackberry Certified Support Specialist (v5.0)
Highlighted
Guru III
Posts: 32,116
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry PRIV, Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook,BT Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BES 4.1.7 and/or 5.0 upgrades failing with SQL errors

glad to see your doing well and thanks for sharing your outcome

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V