BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 07-23-2009, 10:32 AM   #1 (permalink)
New Member
 
Join Date: Jul 2009
Model: 8330
PIN: N/A
Carrier: Verizon
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES Service Pack Upgrade- HELP PLEASE!

Please Login to Remove!

Hi all-
I'm in search of some assistance in upgrading my BES from 4.1.2.25 to 4.6.

I run the installation and get to where it is attempting to upgrade the database and get the following error:
"An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement."

The last few lines of the setup log looks like:

*** Begin Log Snipet ***

[30000] (07/22 12:56:05.330):{0x588} SQL being executed:

update GlobalSettings set HandheldMgmtConfigProperties =
'<HandheldMgmtConfigParms><HandheldSoftwarePath></HandheldSoftwarePath><OTASLLastRefreshTime>0</OTASLLastRefreshTime><OTASLRefreshInterval>86400</OTASLRefreshInterval><OTASLPASUrl>https://%s.otasl.blackberry.com/pas/pas</OTASLPASUrl></HandheldMgmtConfigParms> '
where Container = 'Site'
[20000] (07/22 12:56:05.330):{0x588} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Unable to set MDSPushMaxStoredMessages as this feature is disabled for MSDE" Native error = 50000
[20000] (07/22 12:56:05.330):{0x588} [CBESDBInstaller::ExecuteDDL] SQL Error for
update GlobalSettings set HandheldMgmtConfigProperties =
'<HandheldMgmtConfigParms><HandheldSoftwarePath></HandheldSoftwarePath><OTASLLastRefreshTime>0</OTASLLastRefreshTime><OTASLRefreshInterval>86400</OTASLRefreshInterval><OTASLPASUrl>https://%s.otasl.blackberry.com/pas/pas</OTASLPASUrl></HandheldMgmtConfigParms> '
where Container = 'Site'
[30000] (07/22 12:57:46.532):{0x588} [PIPTOOL]: There are 4838MB space available on the disk of the data directory locates.
[30000] (07/22 12:57:46.532):{0x588} CBESDBInstaller::CBESDBInstaller - working directory is [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\Logs\Installer]
[40000] (07/22 12:57:46.532):{0x588} ConnectionPool: Created pool of 2 connections
[30000] (07/22 12:57:46.547):{0x588} [ENV] [DB] Connection String = Server=STAFASTPVEXCH2\BKUPEXEC;Database=master;Tru sted_Connection=Yes
[30000] (07/22 12:57:46.547):{0x588} [ENV] [DB] DBMS Name = Microsoft SQL Server; DBMS Version = 08.00.0760; Provider Name = sqloledb.dll; Provider Friendly Name = Microsoft OLE DB Provider for SQL Server; OLE DB Version = 02.70; Provider Version = 08.10.3959
[40000] (07/22 12:57:46.547):{0x588} ConnectionPool: Created pool of 2 connections
[30000] (07/22 12:57:46.547):{0x588} [ENV] [DB] Connection String = Server=STAFASTPVEXCH2\BKUPEXEC;Database=master;Tru sted_Connection=Yes
[30000] (07/22 12:57:46.547):{0x588} [ENV] [DB] DBMS Name = Microsoft SQL Server; DBMS Version = 08.00.0760; Provider Name = sqloledb.dll; Provider Friendly Name = Microsoft OLE DB Provider for SQL Server; OLE DB Version = 02.70; Provider Version = 08.10.3959
[40000] (07/22 12:57:46.563):{0x588} ConnectionPool: Created pool of 2 connections
[30000] (07/22 12:57:46.563):{0x588} [ENV] [DB] Connection String = Server=STAFASTPVEXCH2\BKUPEXEC;Database=BESMgmt;Tr usted_Connection=Yes
[30000] (07/22 12:57:46.563):{0x588} [ENV] [DB] DBMS Name = Microsoft SQL Server; DBMS Version = 08.00.0760; Provider Name = sqloledb.dll; Provider Friendly Name = Microsoft OLE DB Provider for SQL Server; OLE DB Version = 02.70; Provider Version = 08.10.3959
[35019] (07/22 12:57:46.563):{0x588} [ENV] [DB] Database Schema Version: 4.1.4 <4.1.2.2007.04.09>
[40000] (07/22 12:57:46.563):{0x588} ConnectionPool: Created pool of 2 connections
[3000

*** End Log Snipet ***

We're running Windows Server 2003, SP2- and no custom applications in the Blackberry software...

Any assistance/suggestions are greatly appreciated, let me know if there's any additional information I should be looking at to get a resolution here- thank you!

JRB
Offline  
Old 07-23-2009, 10:38 AM   #2 (permalink)
BlackBerry God
 
penguin3107's Avatar
 
Join Date: Jan 2005
Model: iOS 5
Carrier: VZW
Posts: 11,701
Post Thanks: 1
Thanked 235 Times in 218 Posts
Default

See here:
KB15451 - An attempt to upgrade the database was unsuccessful. An error occurred - Port3101.org : Your BES Connection

EDIT: Sorry.. I provided the wrong KB article.
I'll look for the correct one.
__________________
BCSA
BES 5.0.3 MR4 :-: Exchange 2007 SP3 RU3
http://port3101.org

Last edited by penguin3107 : 07-23-2009 at 10:40 AM.
Offline  
Old 07-23-2009, 11:38 AM   #3 (permalink)
New Member
 
Join Date: Jul 2009
Model: 8330
PIN: N/A
Carrier: Verizon
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you much, I look forward to any additional assistance you or anyone else can provide.
Offline  
Old 07-24-2009, 09:04 AM   #4 (permalink)
New Member
 
Join Date: Jul 2009
Model: 8330
PIN: N/A
Carrier: Verizon
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Any additional information anyone can provide for us please?
We have 6 traveling sales reps whose contacts aren't syncing right now- trying to get this resolved but cannot get past the DB upgrade...
Thanks in advance for any assistance!
Offline  
Old 07-24-2009, 09:12 AM   #5 (permalink)
BlackBerry God
 
penguin3107's Avatar
 
Join Date: Jan 2005
Model: iOS 5
Carrier: VZW
Posts: 11,701
Post Thanks: 1
Thanked 235 Times in 218 Posts
Default

Revert to your backup and call RIM.
If you're in a crisis, don't rely on public message boards to get you back up and running.

I haven't found anything related to your specific DB issue.
__________________
BCSA
BES 5.0.3 MR4 :-: Exchange 2007 SP3 RU3
http://port3101.org
Offline  
Old 07-24-2009, 09:20 AM   #6 (permalink)
New Member
 
Join Date: Jul 2009
Model: 8330
PIN: N/A
Carrier: Verizon
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ok then- thanks for trying.
Offline  
Old 07-25-2009, 05:17 AM   #7 (permalink)
Thumbs Must Hurt
 
Join Date: Feb 2005
Model: 8130
Carrier: Verizon
Posts: 69
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Check in over at Pinstack.com Seems to be alot of BB Admins there.
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

1/4'' Shut off Switch Valve Pneumatic Vacuum Push Connector Air Fittings
$4.51
1/4'' Shut off Switch Valve Pneumatic Vacuum Push Connector Air Fittings picture12 Car Boat Latching Dash OFF-ON Push Button Switch Red
$4.44
12 Car Boat Latching Dash OFF-ON Push Button Switch Red pictureReverse Polarity Rocker Switch DC Control Momentary Linear Actuator 12V
$9.01
Reverse Polarity Rocker Switch DC Control Momentary Linear Actuator 12V picture85-250V 1 Channel 433MHZ Wireless Remote Control Switch 50m OFF/ON Motor
$13.26
85-250V 1 Channel 433MHZ Wireless Remote Control Switch 50m OFF/ON Motor picture






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