[Stafast]

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

[penguin3107]

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.

[Stafast]

Thank you much, I look forward to any additional assistance you or anyone else can provide.

[Stafast]

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!

[penguin3107]

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.

[Stafast]

Ok then- thanks for trying.

[msingewald]

Check in over at Pinstack.com Seems to be alot of BB Admins there.