troubleshooting Question

Blackberry for exchange 4.1 upgrade to SP 5

Avatar of AblSysadmin
AblSysadmin asked on
ExchangeBlackBerry
1 Comment1 Solution1991 ViewsLast Modified:
I am running Black berry for Exchange v 4.1.4.26 and tried to upgrade to SP 5. When i do this upgrade i get stuck at upgrading the MDS db's.I have added all the persmissions i could, deleted and recreated the DB's , deleted the RIM sqljob and tried again but no luck.  


[30000] (05/21 21:17:50.586):{0x370} Current Date: 2008/05/21
[30000] (05/21 21:17:50.586):{0x370} [DIAG] EVENT=Thread_report, THREADID=0x370, THREADNAME="DebugLogger"
[30000] (05/21 21:17:50.602):{0x370} [ENV] Current Process: C:\T\Export\Setup.exe
[30000] (05/21 21:17:50.602):{0x370} [ENV] Current Process logged on as: UNIZA\Besadmin, Start Time: May 21 2008 21:17:50, Uptime (seconds): 0
[30000] (05/21 21:17:50.602):{0x370} [ENV] Current Process id: 1532
[30000] (05/21 21:17:50.602):{0x370} [ENV] Computer Host Name: XBERRY, OS Version: 5.2, Build number 3790, ServicePack Major 1, ServicePack Minor 0
[30000] (05/21 21:17:50.602):{0x370} [ENV] Processor Identifier: x86 Family 15 Model 4 Stepping 8
[30000] (05/21 21:17:50.602):{0x370} [ENV] Processor Vendor Identifier: GenuineIntel
[30000] (05/21 21:17:50.602):{0x370} [ENV] Processor Name String: Intel(R) Xeon(TM) CPU 2.66GHz
[30000] (05/21 21:17:50.602):{0x370} [ENV] Number of Processors: 2
[30000] (05/21 21:17:50.602):{0x370} [ENV] 29 percent of memory in use.
[30000] (05/21 21:17:50.602):{0x370} [ENV] Total size of physical memory: 1048008 KB
[30000] (05/21 21:17:50.602):{0x370} [ENV] Size of physical memory available: 734892 KB
[30000] (05/21 21:17:50.602):{0x370} [ENV] Size of the committed memory limit: 2528424 KB
[30000] (05/21 21:17:50.602):{0x370} [ENV] Size of available memory to commit: 2312756 KB
[30000] (05/21 21:17:50.602):{0x370} [ENV] Total size of the user mode portion of the virtual address space of the BES process: 2097024 KB
[30000] (05/21 21:17:50.602):{0x370} [ENV] Size of unreserved and uncommitted memory in the user mode portion of the virtual address space of the BES process: 2052244 KB
[30000] (05/21 21:17:50.602):{0x370} [ENV] Total HD bytes: 16096837632, Total free bytes = 3818336256
[30000] (05/21 21:17:50.633):{0x370} [ENV] System up time: 0 days 01 hrs 04 mins 46 secs
[30000] (05/21 21:17:50.633):{0x370} [ENV] Local Time Zone: South Africa Standard Time (GMT+02:00)
[30000] (05/21 21:17:50.633):{0x370} [ENV] TCP/IP provider (Winsock) File Version: 5.2.3790.0 (C:\WINDOWS\System32\wsock32.dll)
[30000] (05/21 21:17:50.633):{0x370} [ENV] Unable to provide HostName
[30000] (05/21 21:17:50.649):{0x370} [ENV] Winsock2 file: Network Location Awareness (NLA) Namespace, Version: 5.2.3790.1830 (C:\WINDOWS\System32\mswsock.dll)
[30000] (05/21 21:17:50.649):{0x370} [ENV] Microsoft XML Parser 4.0: C:\WINDOWS\system32\msxml4.dll, Version: 4.20.9818.0
[30000] (05/21 21:17:50.649):{0x370} [ENV] MDAC version: 2.82.1830.0
[30000] (05/21 21:17:50.649):{0x370} [ENV] MSADO15.DLL: C:\Program Files\Common Files\System\ado\msado15.dll, Version: 2.82.1830.0
[30000] (05/21 21:17:50.649):{0x370} [ENV] Running Process: System
[30000] (05/21 21:17:50.649):{0x370} [ENV] Running Process: smss.exe
[30000] (05/21 21:17:50.649):{0x370} [ENV] Running Process: csrss.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: winlogon.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: services.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: lsass.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: svchost.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: svchost.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: svchost.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: svchost.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: svchost.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: spoolsv.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: dllhost.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: schedul2.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: ECCService_MasterAgent.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: mstragent.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: svchost.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: mstragent.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: inetinfo.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: svchost.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: SavRoam.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: VMwareService.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: exmgmt.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: svchost.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: dllhost.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: msdtc.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: svchost.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: csrss.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: winlogon.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: wmiprvse.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: cmd.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: mnragent.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: rdpclip.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: ctfmon.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: explorer.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: VMwareTray.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: VMwareUser.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: VPTray.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: jusched.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: TrueImageMonitor.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: TimounterMonitor.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: schedhlp.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: mmc.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: logon.scr
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: notepad.exe
[30000] (05/21 21:17:50.664):{0x370} [ENV] Running Process: Setup.exe
[30000] (05/21 21:17:50.758):{0x320} [PIPTOOL]: Default language is en
[30000] (05/21 21:17:50.758):{0x320} [PIPTOOL]: Cannot initiale language value from the registry.
[40000] (05/21 21:17:51.586):{0x320} ConnectionPool: Created pool of 20 connections
[30000] (05/21 21:17:51.602):{0x320} [ENV] [DB] Connection String = Server=oltp1;Database=BESMgmt;Trusted_Connection=Yes
[30000] (05/21 21:17:51.602):{0x320} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.2187;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[35019] (05/21 21:17:51.602):{0x320}
[30000] (05/21 21:17:51.680):{0x320} [PIPTOOL]: Entering DBInfoDlg.
[30000] (05/21 21:17:55.883):{0x320} [PIPTOOL]: There are 20075MB space available on the disk of the data directory locates.
[30000] (05/21 21:17:55.977):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed database context to 'master'.
[30000] (05/21 21:17:55.977):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed language setting to us_english.
[40000] (05/21 21:17:55.977):{0x320} [CDBWrapper::UpgradeDB]: SQL server version [Microsoft SQL Server  2000 - 8.00.2187 (Intel X86)
      Mar  9 2006 11:38:51
      Copyright (c) 1988-2003 Microsoft Corporation
      Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
].
[40000] (05/21 21:17:56.070):{0x320} ConnectionPool: Created pool of 20 connections
[30000] (05/21 21:17:56.070):{0x320} [ENV] [DB] Connection String = Server=oltp1;Database=BESMgmt;Trusted_Connection=Yes
[30000] (05/21 21:17:56.070):{0x320} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.2187;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[35019] (05/21 21:17:56.070):{0x320}
[30000] (05/21 21:17:56.086):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeuse:  Changed database context to 'BESMgmt'.
[40000] (05/21 21:17:56.164):{0x320} ConnectionPool: Created pool of 20 connections
[30000] (05/21 21:17:56.180):{0x320} [ENV] [DB] Connection String = Server=oltp1;Database=BESMgmt;Trusted_Connection=Yes
[30000] (05/21 21:17:56.180):{0x320} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.2187;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[35019] (05/21 21:17:56.180):{0x320}
[30000] (05/21 21:17:56.180):{0x320} [PIPTOOL]: SELECT MailStoreType Exchange, FROM table ServerConfig. DoGetValue = 1, bExists = 1.
[30000] (05/21 21:17:56.180):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeuse:  Changed database context to 'BESMgmt'.
[30000] (05/21 21:17:56.180):{0x320} IsDbCurrent - Version from Database: 4.1.2
[30000] (05/21 21:17:56.180):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\
[30000] (05/21 21:17:56.195):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\
[30000] (05/21 21:17:56.195):{0x320} IsDbCurrent - Date from database [20070410], Date from script files [20070410]
[30000] (05/21 21:17:56.195):{0x320} IsDbCurrent - Schema is up to date
[30000] (05/21 21:17:56.195):{0x320} [CDBWrapper::upgradeDB]: IsDbCurrent returned 0, IsDbCurrent flag = 1.
[40000] (05/21 21:17:56.305):{0x320} ConnectionPool: Created pool of 20 connections
[30000] (05/21 21:17:56.305):{0x320} [ENV] [DB] Connection String = Server=oltp1;Database=BESMgmt;Trusted_Connection=Yes
[30000] (05/21 21:17:56.305):{0x320} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.2187;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[35019] (05/21 21:17:56.305):{0x320}
[30000] (05/21 21:17:56.305):{0x320} [PIPTOOL]: Leaving DBInfoDlg.
[30000] (05/21 21:17:56.320):{0x320} [PIPTOOL]: Entering AGDBDlg.
[30000] (05/21 21:18:05.320):{0x320} [PIPTOOL]: DB Upgrade after reboot and the script directory is: (C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases)
[30000] (05/21 21:18:05.320):{0x320} [PIPTOOL]: Upgrading AGDB.
[20000] (05/21 21:18:05.367):{0x320} COM Error 0x80004005 in ConnectionItem::ConnectToDB() - Cannot open database requested in login 'mdss_NEW'. Login fails. - Unspecified error (connection string - Provider=SQLOLEDB;Server=oltp1;Database=mdss_NEW;Trusted_Connection=Yes)
[10000] (05/21 21:18:05.367):{0x320} [CDBWrapper::ConnectDB]: Cannot open database requested in login 'mdss_NEW'. Login fails.0x80004005 NativeError=4060.
[30000] (05/21 21:18:06.882):{0x320} Schema is being installed
[30000] (05/21 21:18:06.882):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:18:06.882):{0x320} Determining progress bar range
[30000] (05/21 21:18:06.898):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed database context to 'master'.
[30000] (05/21 21:18:06.898):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed language setting to us_english.
[30000] (05/21 21:18:06.914):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:18:06.914):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\createdb.sql]
[30000] (05/21 21:18:06.914):{0x320} Adding 500 to range which now is 500
[30000] (05/21 21:18:06.914):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:18:06.914):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:18:06.914):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\adduser.sql]
[30000] (05/21 21:18:06.914):{0x320} Adding 500 to range which now is 1000
[30000] (05/21 21:18:06.914):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:18:06.914):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\create-server.sql]
[30000] (05/21 21:18:06.914):{0x320} Adding 500 to range which now is 1500
[40000] (05/21 21:18:06.914):{0x320} Progress Bar Max Value = 1500
[40000] (05/21 21:18:06.914):{0x320} Finished determining progress bar range
[30000] (05/21 21:18:06.914):{0x320} Processing file 4.1\createdb.sql
[30000] (05/21 21:18:06.929):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:18:06.929):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\createdb.sql]
[30000] (05/21 21:18:06.945):{0x320} Progress update 500.  Current position is 500 of 1500 = 33%
[30000] (05/21 21:18:06.945):{0x320} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\BES_SQL_Generated\createdbV080521211806.sql]
[30000] (05/21 21:18:06.945):{0x320} SQL being executed:
 
/*
 *  and  will default to the directory where the model database lives
 */
 
declare @path varchar(1024)
set @path = (select top 1 filename from tempdb.dbo.sysfiles)  


declare @indx int,
        @lastindx int,
        @notdone bit

set @notdone = 1
set @indx = 0
set @lastindx = 0

--find the last \
while (@notdone = 1)
begin
    set @indx = (select charindex('\',@path,@indx + 1))
    if @indx > 0
    begin
        set @lastindx = @indx
    end
    else
    begin
        set @notdone = 0;
    end
end

if @lastindx = 0
begin
    set @lastindx = len(@path)
end

set @path = substring(@path,1,@lastindx)

declare @pathdb varchar(1024),
        @pathlog varchar(1024),
        @dbfile varchar(1024),
        @logfile varchar(1024)

set @pathdb = ''
set @pathlog = ''

if @pathdb <> ''
begin
    set @dbfile = @pathdb + '\' + 'mdss_NEW.mdf'  
end
else
begin
    set @dbfile = @path + 'mdss_NEW.mdf'  
end

if @pathlog <> ''
begin
    set @logfile = @pathlog +
[30000] (05/21 21:18:09.523):{0x320} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  The CREATE DATABASE process is allocating 100.00 MB on disk 'mdss_NEW_data'.
[30000] (05/21 21:18:09.523):{0x320} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  The CREATE DATABASE process is allocating 25.00 MB on disk 'mdss_NEW_log'.
[30000] (05/21 21:18:09.523):{0x320} SQL executed successfully
[30000] (05/21 21:18:09.523):{0x320} SQL being executed:
 
alter database "mdss_NEW" set
    auto_close off,
    auto_create_statistics on,
    auto_update_statistics on,
    auto_shrink off
[30000] (05/21 21:18:10.007):{0x320} SQL executed successfully
[30000] (05/21 21:18:10.007):{0x320} SQL being executed:
     
/*
 * Allow the transaction log to be truncated if it fills up.  This is for the customers who aren't
 * doing regular backups.  
 *
 * If desired, it can be altered to FULL which gives the ability to restore to any point in time, not just
 * to the last backup.
 */
alter database "mdss_NEW" set recovery simple
[30000] (05/21 21:18:10.460):{0x320} SQL executed successfully
[30000] (05/21 21:18:10.460):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:18:10.492):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:18:10.492):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed language setting to us_english.
[30000] (05/21 21:18:10.492):{0x320} Processing file 4.1\adduser.sql
[30000] (05/21 21:18:10.492):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:18:10.492):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\adduser.sql]
[30000] (05/21 21:18:10.539):{0x320} Progress update 500.  Current position is 1000 of 1500 = 66%
[30000] (05/21 21:18:10.539):{0x320} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\BES_SQL_Generated\adduserV080521211810.sql]
[30000] (05/21 21:18:10.539):{0x320} SQL being executed:
 USE "mdss_NEW"
[30000] (05/21 21:18:10.539):{0x320} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:18:10.539):{0x320} SQL executed successfully
[30000] (05/21 21:18:10.539):{0x320} SQL being executed:
 
IF ((select Count(*) from sysobjects where name = 'RIM_GetLogin' and type='P') > 0)
begin
Drop Procedure dbo.RIM_GetLogin
end
[30000] (05/21 21:18:10.570):{0x320} SQL executed successfully
[30000] (05/21 21:18:10.570):{0x320} SQL being executed:
 
CREATE PROCEDURE dbo.RIM_GetLogin
    @LoginNamePattern       sysname = NULL
AS

-- install store proc only for SQL2005
IF ( CHARINDEX('9.00.', @@VERSION) = 0 )
begin
   Return -1
end

set nocount on

declare
            @exec_stmt nvarchar(3550)

declare
       @RetCode                        int
      ,@CountSkipPossUsers             int
      ,@Int1                           int

declare
       @c10DBName                      sysname
      ,@c10DBStatus                    int
      ,@c10DBSID                       varbinary(85)

declare
       @charMaxLenLoginName            varchar(11)
      ,@charMaxLenDBName               varchar(11)
      ,@charMaxLenUserName             varchar(11)
      ,@charMaxLenLangName             varchar(11)

declare
       @DBOptLoading                   int   --0x0020      32  "DoNotRecover"
      ,@DBOptPreRecovery               int   --0x0040      64
      ,@DBOptRecovering                int   --0x0080     128

      ,@DBOp
[30000] (05/21 21:18:10.648):{0x320} SQL executed successfully
[30000] (05/21 21:18:10.648):{0x320} SQL being executed:
SQL statements intentionally not shown
[20000] (05/21 21:18:10.648):{0x320} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 1038 Message: Cannot use empty object or column names. Use a single space if necessary.
[30000] (05/21 21:23:09.571):{0x320} [PIPTOOL]: Entering DBInfoDlg.
[30000] (05/21 21:23:10.649):{0x320} [PIPTOOL]: There are 19848MB space available on the disk of the data directory locates.
[30000] (05/21 21:23:10.680):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed database context to 'master'.
[30000] (05/21 21:23:10.680):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed language setting to us_english.
[40000] (05/21 21:23:10.680):{0x320} [CDBWrapper::UpgradeDB]: SQL server version [Microsoft SQL Server  2000 - 8.00.2187 (Intel X86)
      Mar  9 2006 11:38:51
      Copyright (c) 1988-2003 Microsoft Corporation
      Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
].
[40000] (05/21 21:23:11.196):{0x320} ConnectionPool: Created pool of 20 connections
[30000] (05/21 21:23:11.196):{0x320} [ENV] [DB] Connection String = Server=oltp1;Database=BESMgmt;Trusted_Connection=Yes
[30000] (05/21 21:23:11.196):{0x320} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.2187;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[35019] (05/21 21:23:11.212):{0x320}
[30000] (05/21 21:23:11.212):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeuse:  Changed database context to 'BESMgmt'.
[40000] (05/21 21:23:11.290):{0x320} ConnectionPool: Created pool of 20 connections
[30000] (05/21 21:23:11.290):{0x320} [ENV] [DB] Connection String = Server=oltp1;Database=BESMgmt;Trusted_Connection=Yes
[30000] (05/21 21:23:11.290):{0x320} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.2187;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[35019] (05/21 21:23:11.305):{0x320}
[30000] (05/21 21:23:11.337):{0x320} [PIPTOOL]: SELECT MailStoreType Exchange, FROM table ServerConfig. DoGetValue = 1, bExists = 1.
[30000] (05/21 21:23:11.337):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeuse:  Changed database context to 'BESMgmt'.
[30000] (05/21 21:23:11.337):{0x320} IsDbCurrent - Version from Database: 4.1.2
[30000] (05/21 21:23:11.337):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:11.337):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:11.337):{0x320} IsDbCurrent - Date from database [20070410], Date from script files [20070410]
[30000] (05/21 21:23:11.337):{0x320} IsDbCurrent - Schema is up to date
[30000] (05/21 21:23:11.337):{0x320} [CDBWrapper::upgradeDB]: IsDbCurrent returned 0, IsDbCurrent flag = 1.
[40000] (05/21 21:23:11.415):{0x320} ConnectionPool: Created pool of 20 connections
[30000] (05/21 21:23:11.415):{0x320} [ENV] [DB] Connection String = Server=oltp1;Database=BESMgmt;Trusted_Connection=Yes
[30000] (05/21 21:23:11.415):{0x320} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.2187;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[35019] (05/21 21:23:11.415):{0x320}
[30000] (05/21 21:23:11.415):{0x320} [PIPTOOL]: Leaving DBInfoDlg.
[30000] (05/21 21:23:11.430):{0x320} [PIPTOOL]: Entering AGDBDlg.
[30000] (05/21 21:23:12.180):{0x320} [PIPTOOL]: DB Upgrade after reboot and the script directory is: (C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases)
[30000] (05/21 21:23:12.180):{0x320} [PIPTOOL]: Upgrading AGDB.
[20000] (05/21 21:23:12.212):{0x320} COM Error 0x80004005 in ConnectionItem::ConnectToDB() - Cannot open database requested in login 'mdss'. Login fails. - Unspecified error (connection string - Provider=SQLOLEDB;Server=oltp1;Database=mdss;Trusted_Connection=Yes)
[10000] (05/21 21:23:12.212):{0x320} [CDBWrapper::ConnectDB]: Cannot open database requested in login 'mdss'. Login fails.0x80004005 NativeError=4060.
[30000] (05/21 21:23:13.696):{0x320} Schema is being installed
[30000] (05/21 21:23:13.696):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:13.696):{0x320} Determining progress bar range
[30000] (05/21 21:23:13.727):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed database context to 'master'.
[30000] (05/21 21:23:13.727):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed language setting to us_english.
[30000] (05/21 21:23:13.727):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:13.727):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\createdb.sql]
[30000] (05/21 21:23:13.727):{0x320} Adding 500 to range which now is 500
[30000] (05/21 21:23:13.727):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:13.727):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:13.727):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\adduser.sql]
[30000] (05/21 21:23:13.727):{0x320} Adding 500 to range which now is 1000
[30000] (05/21 21:23:13.727):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:13.727):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\create-server.sql]
[30000] (05/21 21:23:13.743):{0x320} Adding 500 to range which now is 1500
[40000] (05/21 21:23:13.743):{0x320} Progress Bar Max Value = 1500
[40000] (05/21 21:23:13.743):{0x320} Finished determining progress bar range
[30000] (05/21 21:23:13.743):{0x320} Processing file 4.1\createdb.sql
[30000] (05/21 21:23:13.743):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:13.743):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\createdb.sql]
[30000] (05/21 21:23:13.758):{0x320} Progress update 500.  Current position is 500 of 1500 = 33%
[30000] (05/21 21:23:13.758):{0x320} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\BES_SQL_Generated\createdbV080521212313.sql]
[30000] (05/21 21:23:13.758):{0x320} SQL being executed:
 
/*
 *  and  will default to the directory where the model database lives
 */
 
declare @path varchar(1024)
set @path = (select top 1 filename from tempdb.dbo.sysfiles)  


declare @indx int,
        @lastindx int,
        @notdone bit

set @notdone = 1
set @indx = 0
set @lastindx = 0

--find the last \
while (@notdone = 1)
begin
    set @indx = (select charindex('\',@path,@indx + 1))
    if @indx > 0
    begin
        set @lastindx = @indx
    end
    else
    begin
        set @notdone = 0;
    end
end

if @lastindx = 0
begin
    set @lastindx = len(@path)
end

set @path = substring(@path,1,@lastindx)

declare @pathdb varchar(1024),
        @pathlog varchar(1024),
        @dbfile varchar(1024),
        @logfile varchar(1024)

set @pathdb = ''
set @pathlog = ''

if @pathdb <> ''
begin
    set @dbfile = @pathdb + '\' + 'mdss.mdf'  
end
else
begin
    set @dbfile = @path + 'mdss.mdf'  
end

if @pathlog <> ''
begin
    set @logfile = @pathlog + '\' + '
[20000] (05/21 21:23:13.774):{0x320} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 5170 Message: Cannot create file 't:\sql2000\program files (x86)\microsoft sql server\MSSQL\data\mdss.mdf' because it already exists.
[20000] (05/21 21:23:13.774):{0x320} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 1802 Message: CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.
[20000] (05/21 21:23:13.774):{0x320} Terminating because we couldn't create the database.  See log file for details
[30000] (05/21 21:23:18.242):{0x320} [PIPTOOL]: Entering DBInfoDlg.
[30000] (05/21 21:23:19.383):{0x320} [PIPTOOL]: There are 19848MB space available on the disk of the data directory locates.
[30000] (05/21 21:23:19.414):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed database context to 'master'.
[30000] (05/21 21:23:19.414):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed language setting to us_english.
[40000] (05/21 21:23:19.429):{0x320} [CDBWrapper::UpgradeDB]: SQL server version [Microsoft SQL Server  2000 - 8.00.2187 (Intel X86)
      Mar  9 2006 11:38:51
      Copyright (c) 1988-2003 Microsoft Corporation
      Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
].
[40000] (05/21 21:23:19.492):{0x320} ConnectionPool: Created pool of 20 connections
[30000] (05/21 21:23:19.492):{0x320} [ENV] [DB] Connection String = Server=oltp1;Database=BESMgmt;Trusted_Connection=Yes
[30000] (05/21 21:23:19.492):{0x320} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.2187;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[35019] (05/21 21:23:19.492):{0x320}
[30000] (05/21 21:23:19.507):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeuse:  Changed database context to 'BESMgmt'.
[40000] (05/21 21:23:19.586):{0x320} ConnectionPool: Created pool of 20 connections
[30000] (05/21 21:23:19.586):{0x320} [ENV] [DB] Connection String = Server=oltp1;Database=BESMgmt;Trusted_Connection=Yes
[30000] (05/21 21:23:19.586):{0x320} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.2187;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[35019] (05/21 21:23:19.601):{0x320}
[30000] (05/21 21:23:19.617):{0x320} [PIPTOOL]: SELECT MailStoreType Exchange, FROM table ServerConfig. DoGetValue = 1, bExists = 1.
[30000] (05/21 21:23:19.617):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeuse:  Changed database context to 'BESMgmt'.
[30000] (05/21 21:23:19.617):{0x320} IsDbCurrent - Version from Database: 4.1.2
[30000] (05/21 21:23:19.617):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:19.617):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:19.632):{0x320} IsDbCurrent - Date from database [20070410], Date from script files [20070410]
[30000] (05/21 21:23:19.632):{0x320} IsDbCurrent - Schema is up to date
[30000] (05/21 21:23:19.632):{0x320} [CDBWrapper::upgradeDB]: IsDbCurrent returned 0, IsDbCurrent flag = 1.
[40000] (05/21 21:23:19.695):{0x320} ConnectionPool: Created pool of 20 connections
[30000] (05/21 21:23:19.695):{0x320} [ENV] [DB] Connection String = Server=oltp1;Database=BESMgmt;Trusted_Connection=Yes
[30000] (05/21 21:23:19.695):{0x320} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.2187;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[35019] (05/21 21:23:19.695):{0x320}
[30000] (05/21 21:23:19.695):{0x320} [PIPTOOL]: Leaving DBInfoDlg.
[30000] (05/21 21:23:19.711):{0x320} [PIPTOOL]: Entering AGDBDlg.
[30000] (05/21 21:23:25.491):{0x320} [PIPTOOL]: DB Upgrade after reboot and the script directory is: (C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases)
[30000] (05/21 21:23:25.491):{0x320} [PIPTOOL]: Upgrading AGDB.
[40000] (05/21 21:23:26.022):{0x320} ConnectionPool: Created pool of 20 connections
[30000] (05/21 21:23:26.038):{0x320} [ENV] [DB] Connection String = Server=oltp1;Database=mdss_NEW;Trusted_Connection=Yes
[30000] (05/21 21:23:26.038):{0x320} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.2187;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[25000] (05/21 21:23:26.038):{0x320}
[30000] (05/21 21:23:26.069):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed database context to 'master'.
[30000] (05/21 21:23:26.069):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed language setting to us_english.
[30000] (05/21 21:23:26.069):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeuse:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:23:26.069):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.execute:  Invalid object name 'DB_VERSION'.
[40000] (05/21 21:23:26.100):{0x320} CBESDBInstaller::GetDBVersionForSQLServer:  Version table DB_VERSION not found.  It could be that this is an empty database
[30000] (05/21 21:23:26.100):{0x320} IsDbCurrent - Version from Database:
[30000] (05/21 21:23:26.100):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:26.100):{0x320} IsDbCurrent - No.  DBVersion is [], script version is [4.1]
[30000] (05/21 21:23:26.100):{0x320} [CDBWrapper::upgradeAGDB]: IsDbCurrent returned 0, IsDbCurrent flag = 0.
[30000] (05/21 21:23:26.100):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeuse:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:23:26.100):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.execute:  Invalid object name 'DB_VERSION'.
[40000] (05/21 21:23:26.116):{0x320} CBESDBInstaller::GetDBVersionForSQLServer:  Version table DB_VERSION not found.  It could be that this is an empty database
[30000] (05/21 21:23:28.147):{0x320} Schema is being installed
[30000] (05/21 21:23:28.147):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:28.147):{0x320} Determining progress bar range
[30000] (05/21 21:23:28.147):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:28.147):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:28.147):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\adduser.sql]
[30000] (05/21 21:23:28.147):{0x320} Adding 500 to range which now is 500
[30000] (05/21 21:23:28.147):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:28.147):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\create-server.sql]
[30000] (05/21 21:23:28.147):{0x320} Adding 500 to range which now is 1000
[40000] (05/21 21:23:28.163):{0x320} Progress Bar Max Value = 1000
[40000] (05/21 21:23:28.163):{0x320} Finished determining progress bar range
[30000] (05/21 21:23:28.163):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:28.194):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:23:28.194):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed language setting to us_english.
[30000] (05/21 21:23:28.194):{0x320} Processing file 4.1\adduser.sql
[30000] (05/21 21:23:28.210):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:28.210):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\adduser.sql]
[30000] (05/21 21:23:28.225):{0x320} Progress update 500.  Current position is 500 of 1000 = 50%
[30000] (05/21 21:23:28.225):{0x320} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\BES_SQL_Generated\adduserV080521212328.sql]
[30000] (05/21 21:23:28.225):{0x320} SQL being executed:
 USE "mdss_NEW"
[30000] (05/21 21:23:28.241):{0x320} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:23:28.241):{0x320} SQL executed successfully
[30000] (05/21 21:23:28.241):{0x320} SQL being executed:
 
IF ((select Count(*) from sysobjects where name = 'RIM_GetLogin' and type='P') > 0)
begin
Drop Procedure dbo.RIM_GetLogin
end
[30000] (05/21 21:23:28.256):{0x320} SQL executed successfully
[30000] (05/21 21:23:28.256):{0x320} SQL being executed:
 
CREATE PROCEDURE dbo.RIM_GetLogin
    @LoginNamePattern       sysname = NULL
AS

-- install store proc only for SQL2005
IF ( CHARINDEX('9.00.', @@VERSION) = 0 )
begin
   Return -1
end

set nocount on

declare
            @exec_stmt nvarchar(3550)

declare
       @RetCode                        int
      ,@CountSkipPossUsers             int
      ,@Int1                           int

declare
       @c10DBName                      sysname
      ,@c10DBStatus                    int
      ,@c10DBSID                       varbinary(85)

declare
       @charMaxLenLoginName            varchar(11)
      ,@charMaxLenDBName               varchar(11)
      ,@charMaxLenUserName             varchar(11)
      ,@charMaxLenLangName             varchar(11)

declare
       @DBOptLoading                   int   --0x0020      32  "DoNotRecover"
      ,@DBOptPreRecovery               int   --0x0040      64
      ,@DBOptRecovering                int   --0x0080     128

      ,@DBOp
[30000] (05/21 21:23:28.303):{0x320} SQL executed successfully
[30000] (05/21 21:23:28.303):{0x320} SQL being executed:
SQL statements intentionally not shown
[20000] (05/21 21:23:28.303):{0x320} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 1038 Message: Cannot use empty object or column names. Use a single space if necessary.
[30000] (05/21 21:23:28.319):{0x320} Processing file 4.1\create-server.sql
[30000] (05/21 21:23:28.319):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:23:28.319):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\create-server.sql]
[30000] (05/21 21:23:28.350):{0x320} Progress update 500.  Current position is 1000 of 1000 = 100%
[30000] (05/21 21:23:28.350):{0x320} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\BES_SQL_Generated\create-serverV080521212328.sql]
[30000] (05/21 21:23:28.350):{0x320} SQL being executed:
 USE "mdss_NEW"
[30000] (05/21 21:23:28.366):{0x320} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:23:28.366):{0x320} SQL executed successfully
[30000] (05/21 21:23:28.366):{0x320} SQL being executed:
 

CREATE TABLE dbo.OPER_MAP
(
OPER_USE int NOT NULL,
OPER_STYLE int NOT NULL,
RESPONSE_SECURITY_MODE tinyint NOT NULL,
REQUEST_SECURITY_MODE tinyint NOT NULL,
OPER_NAMESPACE text NOT NULL,
OPER_LOCALNAME varchar(512) NOT NULL,
REQUEST_MESSAGE_CODE int NOT NULL,
RESPONSE_MESSAGE_CODE int,
EXPIRE_DELTA int NOT NULL,
OPER_MAP_ID bigint NOT NULL,
DELIVERY_MODE tinyint NOT NULL,
WICLET_ID bigint NOT NULL,
CONN_MAP_ID bigint,
FLAGS int NOT NULL,
  CONSTRAINT PK_OPER_MAP PRIMARY KEY (OPER_MAP_ID)
);


CREATE TABLE dbo.CONN_EXT
(
EXT_NAME varchar(512),
EXT_VALUE text,
CONN_EXT_ID bigint NOT NULL,
CONN_MAP_ID bigint NOT NULL,
  CONSTRAINT PK_CONN_EXT PRIMARY KEY (CONN_EXT_ID)
);


CREATE TABLE dbo.TYPE_MAP
(
DEFAULT_VALUE varchar(512),
LOCALNAME varchar(512) NOT NULL,
NAMESPACE text NOT NULL,
TYPE_LOCALNAME varchar(512) NOT NULL,
TYPE_NAMESPACE text NOT NULL,
ORD int NOT NULL,
TYPE_MAP_ID bigint NOT NULL,
OPER_TYPE tinyint NOT NULL,
PARENT_TYPE_MAP_ID bigint,

[30000] (05/21 21:23:28.475):{0x320} SQL executed successfully
[30000] (05/21 21:23:28.475):{0x320} SQL being executed:
 

INSERT INTO AG_PC_NAME (PC_NAME) VALUES('');

insert into JDBC_DRIVER (DRIVER_ID,CLASS_NAME,DB_DRIVER_TYPE,DESCRIPTION,JAR_NAME,MODIFY_NOT_ALLOWED) values('SqlServer2005', 'com.microsoft.sqlserver.jdbc.SQLServerDriver', 'SQLSERVER', 'default SQLSrv 2005 driver provided by the installation', 'sqljdbc.jar', 1);
insert into JDBC_DRIVER (DRIVER_ID,CLASS_NAME,DB_DRIVER_TYPE,DESCRIPTION,JAR_NAME,MODIFY_NOT_ALLOWED) values('DB2_8', 'com.ibm.db2.jcc.DB2Driver', 'DB2', 'default DB2 version 8 driver provided by the installation', 'db2jcc.jar;db2jcc_license_cu.jar', 1);
insert into JDBC_DRIVER (DRIVER_ID,CLASS_NAME,DB_DRIVER_TYPE,DOWNLOAD_URL) values('Oracle8i_8171', 'oracle.jdbc.driver.OracleDriver', 'ORACLE', 'http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html');
insert into JDBC_DRIVER (DRIVER_ID,CLASS_NAME,DB_DRIVER_TYPE,DOWNLOAD_URL) values('Oracle9i_1', 'oracle.jdbc.driver.OracleDriver', 'ORACLE', 'http://www.oracle.com/technology/s
[30000] (05/21 21:23:28.491):{0x320} SQL executed successfully
[30000] (05/21 21:23:28.491):{0x320} SQL being executed:
 
INSERT INTO ID (REALM_NAME, LAST_VALUE) VALUES ('mds_realm', 100);
[30000] (05/21 21:23:28.506):{0x320} SQL executed successfully
[30000] (05/21 21:23:28.506):{0x320} SQL being executed:
 
INSERT INTO MDS (MDS_ID, URL, FLAGS, MAX_LENGTH) VALUES (-1, '', 0, 32768);
[30000] (05/21 21:23:28.506):{0x320} SQL executed successfully
[30000] (05/21 21:23:28.506):{0x320} SQL being executed:
 
INSERT INTO SERVER (NAME, VALUE) VALUES('SERVER_VER', '1.1.2.15');
[30000] (05/21 21:23:28.522):{0x320} SQL executed successfully
[30000] (05/21 21:23:28.522):{0x320} SQL being executed:
 
ALTER TABLE dbo.OPER_MAP ADD CONSTRAINT relationship1 FOREIGN KEY (
WICLET_ID
)
REFERENCES WICLET (
WICLET_ID
);


ALTER TABLE dbo.CONN_EXT ADD CONSTRAINT relationship26 FOREIGN KEY (
CONN_MAP_ID
)
REFERENCES CONN_MAP (
CONN_MAP_ID
);


ALTER TABLE dbo.TYPE_MAP ADD CONSTRAINT relationship2 FOREIGN KEY (
OPER_MAP_ID
)
REFERENCES OPER_MAP (
OPER_MAP_ID
);


ALTER TABLE dbo.DEVICE ADD CONSTRAINT relationship12 FOREIGN KEY (
MDS_ID
)
REFERENCES MDS (
MDS_ID
);


ALTER TABLE dbo.DEVICE ADD CONSTRAINT relationship13 FOREIGN KEY (
POLICY_ID
)
REFERENCES POLICY (
POLICY_ID
);


ALTER TABLE dbo.DEVICE_WICLET ADD CONSTRAINT relationship7 FOREIGN KEY (
WICLET_ID
)
REFERENCES WICLET (
WICLET_ID
);


ALTER TABLE dbo.DEVICE_WICLET ADD CONSTRAINT relationship6 FOREIGN KEY (
DEVICE_ID
)
REFERENCES DEVICE (
DEVICE_ID
);


ALTER TABLE dbo.PUSH_DEVICE ADD CONSTRAINT relationship8 FOREIGN KEY (
TASK_ID
)
REFERENCES PUSH_TASK (
TASK_ID
);


ALTER TABLE dbo.PUSH_DEVICE AD
[30000] (05/21 21:23:28.616):{0x320} SQL executed successfully
[30000] (05/21 21:23:28.616):{0x320} SQL being executed:
 

-- EXEC sp_changedbowner
-- GO

IF ( CHARINDEX('9.00.', @@VERSION) > 0 )
begin
  -- this is SQL Server 2005
  DECLARE @t int;
  SET @t = CHARINDEX('\', '');
  IF ( (@t > 0) AND (NOT ('' = SYSTEM_USER)) )
  begin
    -- this is Windows login
    DECLARE @name nvarchar(64);
    DECLARE @cmd nvarchar(256);
    SET @name=SUBSTRING('', @t+1, LEN('') - @t);
    SET @cmd = 'CREATE USER ' + @name + ' FOR LOGIN [' + '' + '] WITH DEFAULT_SCHEMA = dbo';
    EXEC sp_executesql @cmd;
    SET @cmd = 'sp_addrolemember ''' + 'db_owner' + ''', ''' + @name + '''' ;
    EXEC sp_executesql @cmd;
  end
  ELSE
  begin
    -- this is SQL login
    IF ( (NOT ('' = 'sa')) AND (NOT ('' = SYSTEM_USER)) )
    begin
      EXEC sp_grantdbaccess '';
      EXEC sp_addrolemember db_owner, '';
    end
  end
end
[30000] (05/21 21:23:28.616):{0x320} SQL executed successfully
[30000] (05/21 21:23:28.616):{0x320} SQL being executed:
 
IF ( CHARINDEX('9.00.', @@VERSION) = 0 )
begin
  DECLARE @tt int;
  SET @tt = CHARINDEX('\', '');
  IF ( (@tt > 0) AND (NOT ('' = SYSTEM_USER)) )
  begin
    -- this is Windows login
    DECLARE @name1 nvarchar(64);
    DECLARE @cmd1 nvarchar(256);
    SET @name1=SUBSTRING('', @tt+1, LEN('') - @tt);
    SET @cmd1 = 'sp_grantdbaccess ' + '''' + '' + '''' + ', ' + '''' + @name1 + '''';
    EXEC sp_executesql @cmd1;
    SET @cmd1 = 'sp_addrolemember ''' + 'db_owner' + ''', ''' + @name1 + '''' ;
    EXEC sp_executesql @cmd1;
  end
  ELSE
  begin
    -- this is SQL login
    IF ( (NOT ('' = 'sa')) AND (NOT ('' = SYSTEM_USER)) )
    begin
      EXEC sp_grantdbaccess '';
      EXEC sp_addrolemember db_owner, ''
    end
  end
end
[20000] (05/21 21:23:28.694):{0x320} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 15007 Message: The login '' does not exist.
[20000] (05/21 21:23:28.709):{0x320} (Warning from CBESDBInstaller::DoCmd) Not updating the ServerDBVersion table as error was encountered
[30000] (05/21 21:24:11.923):{0x320} [PIPTOOL]: DB Upgrade after reboot and the script directory is: (C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases)
[30000] (05/21 21:24:11.923):{0x320} [PIPTOOL]: Upgrading AGDB.
[40000] (05/21 21:24:12.048):{0x320} ConnectionPool: Created pool of 20 connections
[30000] (05/21 21:24:12.064):{0x320} [ENV] [DB] Connection String = Server=oltp1;Database=mdss_NEW;Trusted_Connection=Yes
[30000] (05/21 21:24:12.064):{0x320} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.2187;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[25000] (05/21 21:24:12.064):{0x320}
[30000] (05/21 21:24:12.110):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed database context to 'master'.
[30000] (05/21 21:24:12.110):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed language setting to us_english.
[30000] (05/21 21:24:12.110):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeuse:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:24:12.110):{0x320} IsDbCurrent - Version from Database: 4.0
[30000] (05/21 21:24:12.110):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:12.110):{0x320} IsDbCurrent - No.  DBVersion is [4.0], script version is [4.1]
[30000] (05/21 21:24:12.110):{0x320} [CDBWrapper::upgradeAGDB]: IsDbCurrent returned 0, IsDbCurrent flag = 0.
[30000] (05/21 21:24:12.110):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeuse:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:24:13.891):{0x320} Schema is being upgraded
[30000] (05/21 21:24:13.891):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeuse:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:24:13.907):{0x320} SQL Informational Message from CBESDBInstaller::GetDBVersionForSQLServer.executeuse:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:24:13.907):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.938):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:24:13.938):{0x320} SQL Informational Message from CBESDBInstaller::Connect:  Changed language setting to us_english.
[30000] (05/21 21:24:13.938):{0x320} SQL Informational Message from CBESDBInstaller::determineProgressUpgradeFactor:  Invalid object name 'UserConfig'.
[40000] (05/21 21:24:13.938):{0x320} Progress upgrade factor is 0%
[30000] (05/21 21:24:13.938):{0x320} Determining progress bar range
[30000] (05/21 21:24:13.938):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.938):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.938):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.938):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060403.sql]
[30000] (05/21 21:24:13.938):{0x320} Adding 500 to range which now is 500
[30000] (05/21 21:24:13.938):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.938):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060415.sql]
[30000] (05/21 21:24:13.938):{0x320} Adding 500 to range which now is 1000
[30000] (05/21 21:24:13.938):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.938):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060502.sql]
[30000] (05/21 21:24:13.938):{0x320} Adding 500 to range which now is 1500
[30000] (05/21 21:24:13.938):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.938):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060519.sql]
[30000] (05/21 21:24:13.938):{0x320} Adding 500 to range which now is 2000
[30000] (05/21 21:24:13.938):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.938):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060529.sql]
[30000] (05/21 21:24:13.938):{0x320} Adding 500 to range which now is 2500
[30000] (05/21 21:24:13.954):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.954):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060619.sql]
[30000] (05/21 21:24:13.954):{0x320} Adding 500 to range which now is 3000
[30000] (05/21 21:24:13.954):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.954):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060626.sql]
[30000] (05/21 21:24:13.954):{0x320} Adding 500 to range which now is 3500
[30000] (05/21 21:24:13.954):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.954):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060724.sql]
[30000] (05/21 21:24:13.954):{0x320} Adding 500 to range which now is 4000
[30000] (05/21 21:24:13.954):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.954):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060726.sql]
[30000] (05/21 21:24:13.954):{0x320} Adding 500 to range which now is 4500
[30000] (05/21 21:24:13.954):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.954):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060818.sql]
[30000] (05/21 21:24:13.954):{0x320} Adding 500 to range which now is 5000
[30000] (05/21 21:24:13.954):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.954):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060921.sql]
[30000] (05/21 21:24:13.954):{0x320} Adding 500 to range which now is 5500
[30000] (05/21 21:24:13.954):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.954):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20070412.sql]
[30000] (05/21 21:24:13.954):{0x320} Adding 500 to range which now is 6000
[30000] (05/21 21:24:13.954):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.954):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV99990101.sql]
[30000] (05/21 21:24:13.954):{0x320} Adding 500 to range which now is 6500
[40000] (05/21 21:24:13.954):{0x320} Progress Bar Max Value = 6500
[40000] (05/21 21:24:13.954):{0x320} Finished determining progress bar range
[30000] (05/21 21:24:13.954):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.954):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.954):{0x320} Processing file 4.1\UpgradeV20060403.sql
[30000] (05/21 21:24:13.970):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:13.970):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060403.sql]
[30000] (05/21 21:24:13.970):{0x320} Progress update 500.  Current position is 500 of 6500 = 7%
[30000] (05/21 21:24:13.970):{0x320} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\BES_SQL_Generated\UpgradeV20060403V080521212413.sql]
[30000] (05/21 21:24:13.985):{0x320} SQL being executed:
 USE "mdss_NEW"
[30000] (05/21 21:24:13.985):{0x320} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:24:13.985):{0x320} SQL executed successfully
[30000] (05/21 21:24:13.985):{0x320} SQL being executed:
 
if not exists(select name from sysobjects where xtype='U' and name='AG_PC_NAME')
begin
    CREATE TABLE dbo.AG_PC_NAME
    (
    PC_NAME varchar(64) NOT NULL,
    DB_TYPE varchar(16) NOT NULL DEFAULT ('server')
    );
end
[30000] (05/21 21:24:14.001):{0x320} SQL executed successfully
[30000] (05/21 21:24:14.001):{0x320} SQL being executed:
 
if ( (select count(*) from AG_PC_NAME) = 0 )
begin
    insert into AG_PC_NAME (PC_NAME) values('');
end
[30000] (05/21 21:24:14.001):{0x320} SQL executed successfully
[30000] (05/21 21:24:14.001):{0x320} Processing file 4.1\UpgradeV20060415.sql
[30000] (05/21 21:24:14.001):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:14.001):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060415.sql]
[30000] (05/21 21:24:14.016):{0x320} Progress update 500.  Current position is 1000 of 6500 = 15%
[30000] (05/21 21:24:14.016):{0x320} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\BES_SQL_Generated\UpgradeV20060415V080521212414.sql]
[30000] (05/21 21:24:14.016):{0x320} SQL being executed:
 USE "mdss_NEW"
[30000] (05/21 21:24:14.032):{0x320} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:24:14.032):{0x320} SQL executed successfully
[30000] (05/21 21:24:14.032):{0x320} SQL being executed:
 
if not exists(select name from sysobjects where xtype='U' and name='HTTP_PROXY_MAP')
begin
    CREATE TABLE dbo.HTTP_PROXY_MAP
    (
     URL_REG_EXPR     varchar(256) NOT NULL,
     PROXY_STRING     varchar(256) NOT NULL,
     PROXY_USER       varchar(64) NULL,
     PROXY_PASSWORD   varchar(64) NULL,
     PRIORITY         int NOT NULL,                
     DESCRIPTION      varchar(256) NULL,
        CONSTRAINT   IX_HTTP_PRIORITY    UNIQUE CLUSTERED (PRIORITY),
        CONSTRAINT   PK_HTTP_PROXY_MAP   PRIMARY KEY (URL_REG_EXPR)
    );
end
[30000] (05/21 21:24:14.032):{0x320} SQL executed successfully
[30000] (05/21 21:24:14.032):{0x320} SQL being executed:
 
if ( (select count(*) from SERVER where NAME='HTTP_PROXY_ENABLED') = 0 )
begin
   delete from SERVER where NAME='HTTP.PROXY.PROXY_HOST';
   delete from SERVER where NAME='HTTP.PROXY.PROXY_USERNAME';
   delete from SERVER where NAME='HTTP.PROXY.PROXY_PASSWORD';
   delete from SERVER where NAME='HTTP.PROXY.NON_PROXY_HOSTS';
   delete from SERVER where NAME='HTTP.PROXY.PROXY_ENABLED';
end
[30000] (05/21 21:24:14.032):{0x320} SQL being executed:
 
if not exists(select name from sysobjects where xtype='U' and name='JDBC_DRIVER')
begin
    CREATE TABLE dbo.JDBC_DRIVER
    (
      DRIVER_ID varchar(32) NOT NULL,
      CLASS_NAME varchar(128) NOT NULL,
      DB_DRIVER_TYPE varchar(16) NOT NULL,
      DESCRIPTION varchar(128) NOT NULL DEFAULT(''),
      DOWNLOAD_URL varchar(512) NOT NULL DEFAULT(''),
      LOCATION_PATH varchar(512) NOT NULL DEFAULT(''),
      JAR_NAME varchar(128) NOT NULL DEFAULT(''),
      MODIFY_NOT_ALLOWED tinyint NOT NULL DEFAULT(0),
      MODIFICATION_TIME datetime NOT NULL DEFAULT GetUtcDate(),
        CONSTRAINT   PK_JDBC_DRIVER   PRIMARY KEY (DRIVER_ID)
    );
end
[30000] (05/21 21:24:14.048):{0x320} SQL executed successfully
[30000] (05/21 21:24:14.048):{0x320} SQL being executed:
 
if ( (select count(*) from JDBC_DRIVER) = 0 )
begin
 insert into JDBC_DRIVER (DRIVER_ID,CLASS_NAME,DB_DRIVER_TYPE,DESCRIPTION,JAR_NAME,MODIFY_NOT_ALLOWED) values('SqlServer2005', 'com.microsoft.sqlserver.jdbc.SQLServerDriver', 'SQLSERVER', 'default SQLSrv 2005 driver provided by the installation', 'sqljdbc.jar', 1);
 insert into JDBC_DRIVER (DRIVER_ID,CLASS_NAME,DB_DRIVER_TYPE,DESCRIPTION,JAR_NAME,MODIFY_NOT_ALLOWED) values('DB2_8', 'com.ibm.db2.jcc.DB2Driver', 'DB2', 'default DB2 version 8 driver provided by the installation', 'db2jcc.jar;db2jcc_license_cu.jar', 1);
 insert into JDBC_DRIVER (DRIVER_ID,CLASS_NAME,DB_DRIVER_TYPE,DOWNLOAD_URL) values('Oracle8i_8171', 'oracle.jdbc.driver.OracleDriver', 'ORACLE', 'http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html');
 insert into JDBC_DRIVER (DRIVER_ID,CLASS_NAME,DB_DRIVER_TYPE,DOWNLOAD_URL) values('Oracle9i_1', 'oracle.jdbc.driver.OracleDriver', 'ORACLE', 'http://www.oracle.com/tec
[30000] (05/21 21:24:14.048):{0x320} SQL executed successfully
[30000] (05/21 21:24:14.048):{0x320} Processing file 4.1\UpgradeV20060502.sql
[30000] (05/21 21:24:14.048):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:14.048):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060502.sql]
[30000] (05/21 21:24:14.063):{0x320} Progress update 500.  Current position is 1500 of 6500 = 23%
[30000] (05/21 21:24:14.063):{0x320} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\BES_SQL_Generated\UpgradeV20060502V080521212414.sql]
[30000] (05/21 21:24:14.063):{0x320} SQL being executed:
 USE "mdss_NEW"
[30000] (05/21 21:24:14.063):{0x320} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:24:14.063):{0x320} SQL executed successfully
[30000] (05/21 21:24:14.063):{0x320} SQL being executed:
 
if not exists(select name from sysobjects where xtype='U' and name='FEATURE_VERSION')
begin
    CREATE TABLE dbo.FEATURE_VERSION
    (
      NAME varchar(256) NOT NULL,
      MIN_VERSION  varchar(128),
      MAX_VERSION varchar(128),
      CURRENT_VERSION varchar(128),
      DEVICE_ID bigint NOT NULL,
        CONSTRAINT   PK_FEATURE_VER   PRIMARY KEY (NAME,DEVICE_ID)
    );
end
[30000] (05/21 21:24:14.079):{0x320} SQL executed successfully
[30000] (05/21 21:24:14.079):{0x320} SQL being executed:
 
if not exists(select name from sysobjects where xtype='F' and name='relationship28')
begin
    ALTER TABLE dbo.FEATURE_VERSION ADD CONSTRAINT relationship28 FOREIGN KEY (
    DEVICE_ID
    )
    REFERENCES DEVICE (
    DEVICE_ID
    );
end
[30000] (05/21 21:24:14.079):{0x320} SQL executed successfully
[30000] (05/21 21:24:14.079):{0x320} SQL being executed:
 
SET NOCOUNT ON;
DECLARE @id bigint;
DECLARE tmp_cursor CURSOR FOR SELECT DEVICE_ID FROM DEVICE
OPEN tmp_cursor;
FETCH NEXT FROM tmp_cursor INTO @id;
WHILE @@FETCH_STATUS = 0
begin
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION)
                      VALUES (@id, 'Discovery', '1.1.0', '1.1.0', '1.1.0');
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION)
                      VALUES (@id, 'Provisioning', '1.1.0', '1.1.0', '1.1.0');
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION)
                      VALUES (@id, 'System', '1', '1', '1');
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION)
                      VALUES (@id, 'Transport', '1', '1', '1');
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION)
                      VALUES (@id, 'Security'
[30000] (05/21 21:24:14.095):{0x320} SQL executed successfully
[30000] (05/21 21:24:14.095):{0x320} SQL being executed:
 
-- ignore warning:
-- Caution: Changing any part of an object name could break scripts and stored procedures.
-- The COLUMN was renamed to 'FLAGS'.

DECLARE @tmi int;
SET @tmi=(select id from sysobjects where name='DEVICE');
IF ((select count(*) from syscolumns where id=@tmi and name='IS_DEFAULT') > 0 )
begin
  ALTER TABLE DEVICE DROP COLUMN SECURITY_VERSION;
  ALTER TABLE DEVICE ADD FIRST_REG_DATE datetime NOT NULL DEFAULT GetUtcDate();
  ALTER TABLE DEVICE ADD PRIMARY_REG_KEY varchar(512);
  ALTER TABLE DEVICE ADD SECONDARY_REG_KEY varchar(512);
  EXEC sp_rename 'DEVICE.[IS_DEFAULT]', 'FLAGS', 'COLUMN';
end;
[30000] (05/21 21:24:14.095):{0x320} SQL executed successfully
[30000] (05/21 21:24:14.095):{0x320} Processing file 4.1\UpgradeV20060519.sql
[30000] (05/21 21:24:14.110):{0x320} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (05/21 21:24:14.110):{0x320} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060519.sql]
[30000] (05/21 21:24:14.110):{0x320} Progress update 500.  Current position is 2000 of 6500 = 30%
[30000] (05/21 21:24:14.110):{0x320} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\BES_SQL_Generated\UpgradeV20060519V080521212414.sql]
[30000] (05/21 21:24:14.110):{0x320} SQL being executed:
 USE "mdss_NEW"
[30000] (05/21 21:24:14.110):{0x320} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  Changed database context to 'mdss_NEW'.
[30000] (05/21 21:24:14.110):{0x320} SQL executed successfully
[30000] (05/21 21:24:14.110):{0x320} SQL being executed:
 
update CONN_MAP set CLASS_NAME='net.rim.wica.ag.services.connector.soap.WSConnectorMapping' where TYPE=0
[20000] (05/21 21:24:14.110):{0x320} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'TYPE'.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros