BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 07-24-2012, 11:20 AM   #1 (permalink)
New Member
 
Join Date: Jul 2012
Model: 9900
PIN: N/A
Carrier: Swisscom
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Question BES upgrade 5.0.2 to 5.0.3

Please Login to Remove!

Hi everyone,

Desperately trying to upgrade our BES server, but always being prompted with the error message:

"The setup application determined that you are not running a supported version of Microsoft SQL Server or Microsoft SQL Server Express Edition. Before you continue the current installation process, you must upgrade the database server to a supported version. For more information about system requirements for Blackberry Enterprise Server databases, see the Blackberry Enterprise Server Upgrade Guide."

I can't quite follow it, as we use MS SQL 2008 SP2. BES database compatibility level is also set to 2008.

Any ideas?
Offline  
Old 07-24-2012, 12:27 PM   #2 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Passp
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,793
Post Thanks: 281
Thanked 298 Times in 282 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

did you have MSDE installed on the BES server?

BlackBerry - BlackBerry Enterprise Server Compatibility - US
__________________
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 Passport, Z30, Z10 and Q10
Offline  
Old 07-25-2012, 04:25 AM   #3 (permalink)
New Member
 
Join Date: Jul 2012
Model: 9900
PIN: N/A
Carrier: Swisscom
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

The infrastructure is here longer than I am. The BES database (2k8 64-bit) and BES administration (2k8 64-bit) servers are physically separated. From what I know the current database server was installed with SQL 2008 before it was upgraded to SQL 2008 SP2. Also I have been told that the Blackberry database apparently resided on the BES server itself, before it was moved to the dedicated database server. I am unsure of what DB version was running on the BES, but I assume it was SQL 2005.

Last edited by cdbesadmin : 07-25-2012 at 04:29 AM.
Offline  
Old 07-25-2012, 08:58 AM   #4 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Passp
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,793
Post Thanks: 281
Thanked 298 Times in 282 Posts
Exclamation Re: BES upgrade 5.0.2 to 5.0.3

if you are unable to determine if SQL or MSDE is installed on a server maybe you should have some one more experienced with IT look at it.



Find your Installed SQL Server Versions and Instances Learning SQL Server
__________________
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 Passport, Z30, Z10 and Q10
Offline  
Old 07-25-2012, 11:02 AM   #5 (permalink)
New Member
 
Join Date: Jul 2012
Model: 9900
PIN: N/A
Carrier: Swisscom
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

it's not that i don't know the difference between SQL and MSDE, I simply said I don't know if MSDE was installed before I joined the company. At the moment there is only SQL 2008 SP2 installed on the server the BES database is running on.
Offline  
Old 07-25-2012, 11:35 AM   #6 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Passp
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,793
Post Thanks: 281
Thanked 298 Times in 282 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

log onto the BES server, go to add remove programs and see if SQL is installed and report back please
__________________
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 Passport, Z30, Z10 and Q10
Offline  
Old 07-25-2012, 11:38 AM   #7 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Passp
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,793
Post Thanks: 281
Thanked 298 Times in 282 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

You can see what BES is useing for SQL with this
Change BES 5.0 Configuration Database

If BES has a version of SQL installed on it and you are using a different SQL server for your database. Uninstall SQL from BES.
__________________
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 Passport, Z30, Z10 and Q10
Offline  
Old 07-26-2012, 03:11 AM   #8 (permalink)
New Member
 
Join Date: Jul 2012
Model: 9900
PIN: N/A
Carrier: Swisscom
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

thanks knottyrope. Following your URL I can see that BES is using the correct DB on the dedicated DB server. On the BES server itself there is no MS SQL Server installed, but the SQL native clients installed seem to be out of date (2005.90.3042.00 and 2007.100.2531.00). do you think that could have an impact? I would need to request a maintenance window in order to update them.
Offline  
Old 07-26-2012, 04:47 AM   #9 (permalink)
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: 9780
PIN: N/A
Carrier: Swisscom
Posts: 1,579
Post Thanks: 5
Thanked 119 Times in 116 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

On your dedicated SQL server, check if all the components are really upgraded to SQL 2008, see:

Upgrade to BESX 5.0.3 - Not detecting SQL Upgrade - BlackBerry Support Community Forums

On the BES server, make sure that you have the "Microsoft SQL Server 2008 Native Client" installed.
Offline  
Old 07-26-2012, 05:55 AM   #10 (permalink)
New Member
 
Join Date: Jul 2012
Model: 9900
PIN: N/A
Carrier: Swisscom
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

SQL software on servers....

BES server:
Microsoft SQL Server 2008 Native Client (10.1.2531.0)
Microsoft SQL Server Native Client (9.00.3042.00)

DB server:
Microsoft SQL Server 2008 (64-bit)
Microsoft SQL Server 2008 Browser (10.2.4000.0)
Microsoft SQL Server 2008 Native Client (10.2.4064.0)
Microsoft SQL Server 2008 Setup Support Files (10.2.4064.0)
Microsoft SQL Server VSS Writer (10.2.4000.0)
Microsoft SQL Server 2005 Backward compatibility (8.05.2309)


May the version of 2008 Native Client on the BES be the problem?
Offline  
Old 07-26-2012, 06:17 AM   #11 (permalink)
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: 9780
PIN: N/A
Carrier: Swisscom
Posts: 1,579
Post Thanks: 5
Thanked 119 Times in 116 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

I have the same versions and the upgrade to SP3 worked for me. The native clients are installed by the BES setup, they are in the "Tools" subfolder:

sqlncli_x64.msi
sqlncli10_x64.msi

You can try to re-install from there, but I don't think that will help.

You should probably check the setup log to find a more detailed error.
Offline  
Old 08-21-2012, 04:34 AM   #12 (permalink)
New Member
 
Join Date: Jul 2012
Model: 9900
PIN: N/A
Carrier: Swisscom
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

unfortunately still haven't got any further. any other ideas? create a new db and import settings from existing?
Offline  
Old 08-21-2012, 05:21 AM   #13 (permalink)
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: 9780
PIN: N/A
Carrier: Swisscom
Posts: 1,579
Post Thanks: 5
Thanked 119 Times in 116 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

You should probably check the setup log to find a more detailed error.
Offline  
Old 08-21-2012, 05:45 AM   #14 (permalink)
New Member
 
Join Date: Jul 2012
Model: 9900
PIN: N/A
Carrier: Swisscom
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

Code:
...
[30000] (08/21 11:23:47.695):{0x2340} <5>Aug 21 11:23:47 BESserver  {0x1A90} 1011: (#30000) [ENV] [DB] Connection String = Server=BESdbserver;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[30000] (08/21 11:23:47.695):{0x2340} <5>Aug 21 11:23:47 BESserver  {0x1A90} 1012: (#30000) [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 10.00.4064;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 06.00.6002
[30000] (08/21 11:23:47.695):{0x2340} <5>Aug 21 11:23:47 BESserver  {0x1A90} 1013: (#35019) [ENV] [DB] Database Schema Version:  5.0.2 <5.0.2010.05.19>
[30000] (08/21 11:23:47.695):{0x2340} <5>Aug 21 11:23:47 BESserver  {0x1A90} 1014: (#30000) VerifyVersions: server: BESserver - version: 5.0.2.17
[30000] (08/21 11:23:47.695):{0x2340} <3>Aug 21 11:23:47 BESserver  {0x1A90} 1015: (#10000) [PIPTOOL]: 1. The setup application determined that you are not running a supported version of Microsoft SQL Server or Microsoft SQL Server Express Edition. Before you continue the current installation process, you must upgrade the database server to a supported version. For more information about system requirements for BlackBerry Enterprise Server databases, see the BlackBerry Enterprise Server Upgrade Guide.
...
doesn't really make sense to me. it determines a supported version, but it's telling me it's not supported.
Offline  
Old 08-21-2012, 06:41 AM   #15 (permalink)
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: 9780
PIN: N/A
Carrier: Swisscom
Posts: 1,579
Post Thanks: 5
Thanked 119 Times in 116 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

The only difference I see in my setup file is that the Provider version is

06.01.7600

So I guess you should try to upgrade the Microsoft SQL Server Native Client on the BES manually to match the version on the SQL server.
Offline  
Old 08-22-2012, 10:11 AM   #16 (permalink)
New Member
 
Join Date: Jul 2012
Model: 9900
PIN: N/A
Carrier: Swisscom
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

unfortunately, not something we can do during production.

in the meantime, we've created a copy of our BES database and performed a manual test db upgrade as described in the upgrade manual (via cmd). it worked like a charm. not sure why the upgrade isn't working using the upgrade app.
Offline  
Old 11-05-2012, 08:55 AM   #17 (permalink)
New Member
 
Join Date: Jul 2012
Model: 9900
PIN: N/A
Carrier: Swisscom
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: BES upgrade 5.0.2 to 5.0.3

for anyone interested i was finally able to install BES 5.0.4

I could not identify the problem to 100%, but assume it has to do with the DB server storing it's databases on mapped LUN drives on our storage, instead of local DB server disks.

I've back'ed up the BESMgmt DB and restored it on a different DB server with no LUNs connected, run the BES upgrade installer to upgrade the DB on the new server. I then made a backup of the upgraded DB, restored it on the original DB server and ran the upgrade installer again to point the DB server address to the original DB server.

As mentioned, the LUN thing is just an assumption, but the workaround seemed to do the trick.
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: BES upgrade 5.0.2 to 5.0.3
Thread Thread Starter Forum Replies Last Post
BES Upgrade 4.1.6 to 5.0.2 Kul BES Admin Corner 40 02-16-2011 11:38 AM
Question regarding the BES 5 upgrade key Aarzel BES Admin Corner 4 10-07-2010 10:02 AM
BES 5.0.1 to 5.0.2 upgrade - HA SQL Mirroring Question Tacfire11 BES Admin Corner 1 09-30-2010 02:55 AM
BES Upgrade from Ver 4.0.1.16 to Ver 4.1.6 buddi BES Admin Corner 1 03-25-2009 10:15 AM
Help required migrating from an old WinNT4 BES3.6 to Win2003 Server BES4.0 johnny_boy_uk BES Admin Corner 22 01-28-2008 01:44 PM





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