Stafast
07-23-2009, 10:32 AM
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;Trusted_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;Trusted_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;Trusted_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
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;Trusted_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;Trusted_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;Trusted_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