Avatar of AblSysadmin
AblSysadmin asked on

Blackberry for exchange 4.1 upgrade to SP 5

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'.
ExchangeBlackBerry

Avatar of undefined
Last Comment
Kurt_Braeckmans

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Kurt_Braeckmans

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.
fblack61