BlackBerry Forums Support Community

dvine · 10-12-2009, 04:44 AM

Howdy,

A clean (first) install of BES 5.0 on my back-end exchange 2003 sp1 server using a remote sql (mssql 2000 sp3a) database clustered server install is generating the below log (error) messages.

I am not sure what is causing the error. I have tried deleting the DB via enterprise manager and recreate using the installer, but continuosly run into the same error message over and over and cannot get past this stage. "An attempt to install the database was unsuccessful. An error occurred while executing an SQL statement."

Help pointing me in the right direction would be greatly appreciated!

Cheers,

dvine

Code:

[30000] (10/12 20:24:16.093):{0x145C} [PIPTOOL]: There are 15210MB space available on the disk of the data directory location.
[30000] (10/12 20:24:16.093):{0x21C} CBESDBInstaller::CBESDBInstaller - working directory is [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script]
[30000] (10/12 20:24:16.093):{0x21C} Setting time zone offset in DB to:  10
[45059] (10/12 20:24:16.203):{0x21C} {ConnectionPool::InitializePool()}: Using connection pool with limit of 2 connections
[30000] (10/12 20:24:16.296):{0x21C} [ENV] [DB] Connection String = Server=win-vdwh01\dwhs;Database=master;Trusted_Connection=Yes
[30000] (10/12 20:24:16.296):{0x21C} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[45059] (10/12 20:24:16.500):{0x21C} {ConnectionPool::InitializePool()}: Using connection pool with limit of 2 connections
[30000] (10/12 20:24:16.609):{0x21C} [ENV] [DB] Connection String = Server=win-vdwh01\dwhs;Database=master;Trusted_Connection=Yes
[30000] (10/12 20:24:16.609):{0x21C} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[20000] (10/12 20:24:16.828):{0x21C} ConnectDB: Unable to connect to the database. Host: win-vdwh01\dwhs. Database Name: BESMgmt.
[30000] (10/12 20:24:19.812):{0x11D0} CBESDBInstaller::CBESDBInstaller - working directory is [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script]
[30000] (10/12 20:24:19.828):{0x11D0} Setting time zone offset in DB to:  10
[30000] (10/12 20:24:19.828):{0x11D0} Schema is being installed
[30000] (10/12 20:24:19.828):{0x11D0} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\
[30000] (10/12 20:24:19.828):{0x11D0} Determining progress bar range
[45059] (10/12 20:24:19.937):{0x11D0} {ConnectionPool::InitializePool()}: Using connection pool with limit of 2 connections
[30000] (10/12 20:24:20.031):{0x11D0} [ENV] [DB] Connection String = Server=win-vdwh01\dwhs;Database=master;Trusted_Connection=Yes
[30000] (10/12 20:24:20.031):{0x11D0} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830

.......

[30000] (10/12 20:24:21.265):{0x11D0} Processing file 5.0\createdb.sql
[30000] (10/12 20:24:21.281):{0x11D0} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\
[30000] (10/12 20:24:21.281):{0x11D0} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\5.0\createdb.sql]
[30000] (10/12 20:24:21.281):{0x11D0} Progress update 500.  Current position is 500 of 51000 = 0%
[30000] (10/12 20:24:21.281):{0x11D0} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\BES_SQL_Generated\createdbV091012202421.sql]
[30000] (10/12 20:24:21.281):{0x11D0} SQL being executed:
 /****************************************************************************
 createdb.sql
  
 This SQL script will create the initial BESMgmt database.


 Notes:


 (C) 1997-2004 Research In Motion Limited.
 ****************************************************************************/

/* 
 *  and  will default to the directory where the model database lives
 */
 
declare @path nvarchar(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(N'\',@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 nvarchar(1024),
        @pathlog nvarchar(102
[40000] (10/12 20:24:26.328):{0x11D0} [CBESDBInstaller::ExecuteDDL] The CREATE DATABASE process is allocating 100.00 MB on disk 'BESMgmt_data'.
[40000] (10/12 20:24:26.328):{0x11D0} [CBESDBInstaller::ExecuteDDL] The CREATE DATABASE process is allocating 25.00 MB on disk 'BESMgmt_log'.
[30000] (10/12 20:24:26.343):{0x11D0} SQL executed successfully
[30000] (10/12 20:24:26.343):{0x11D0} SQL being executed:
 -- INSTALL_PROGRESS_BAR=1188
alter database "BESMgmt" set
    auto_close off,
    auto_create_statistics on,
    auto_update_statistics on,
    auto_shrink off
[30000] (10/12 20:24:26.406):{0x11D0} SQL executed successfully
[30000] (10/12 20:24:26.406):{0x11D0} 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 "BESMgmt" set recovery simple
[30000] (10/12 20:24:26.468):{0x11D0} SQL executed successfully
[30000] (10/12 20:24:26.468):{0x11D0} SQL being executed:
 

/*
 *  Added this DB setting to make sure that the DB triggers aren't called recursively
 *  as it could cause an infinite number of recursive update calls to occur.
 */
EXEC sp_dboption N'BESMgmt', 'recursive triggers', 'FALSE'
[30000] (10/12 20:24:26.656):{0x11D0} SQL executed successfully
[30000] (10/12 20:24:26.656):{0x11D0} SQL executed successfully
[30000] (10/12 20:24:26.656):{0x11D0} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\
[45059] (10/12 20:24:26.765):{0x11D0} {ConnectionPool::InitializePool()}: Using connection pool with limit of 2 connections
[30000] (10/12 20:24:26.875):{0x11D0} [ENV] [DB] Connection String = Server=win-vdwh01\dwhs;Database=BESMgmt;Trusted_Connection=Yes
[30000] (10/12 20:24:26.875):{0x11D0} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.1830
[30000] (10/12 20:24:26.875):{0x11D0} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\
[30000] (10/12 20:24:26.875):{0x11D0} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\
[30000] (10/12 20:24:26.875):{0x11D0} Processing file 4.1.2\tables.sql
[30000] (10/12 20:24:26.875):{0x11D0} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\
[30000] (10/12 20:24:26.875):{0x11D0} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\DBInstallScripts\SqlServer\4.1.2\tables.sql]
[30000] (10/12 20:24:27.000):{0x11D0} Progress update 500.  Current position is 1000 of 51000 = 1%
[30000] (10/12 20:24:27.000):{0x11D0} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\script\BES_SQL_Generated\tablesV091012202426.sql]
[30000] (10/12 20:24:27.000):{0x11D0} SQL being executed:
 /****************************************************************************
 tables.sql
  
 This SQL script will create the initial BlackBerry Admin Server tables.
 

 Notes:


 (C) 1997-2004 Research In Motion Limited.
 ****************************************************************************/

/*
 *   Switch to the BESMgmt database  
 */
USE "BESMgmt"
[40000] (10/12 20:24:27.000):{0x11D0} [CBESDBInstaller::ExecuteDDL] Changed database context to 'BESMgmt'.
[30000] (10/12 20:24:27.000):{0x11D0} SQL executed successfully
[30000] (10/12 20:24:27.000):{0x11D0} SQL being executed:
 
set nocount on
[30000] (10/12 20:24:27.000):{0x11D0} SQL executed successfully
[30000] (10/12 20:24:27.000):{0x11D0} SQL being executed:
 
/*
 *  Create the ServerDBVersion table if it doesn't already exist.
 */    
IF NOT EXISTS (SELECT name FROM sysobjects WHERE name = 'ServerDBVersion' AND type = 'U')
begin
CREATE TABLE dbo.ServerDBVersion
(
   Id                   int IDENTITY (1,1) NOT FOR REPLICATION not null,
   CurrentVersion       nvarchar(32) NOT NULL,
   CreateDateTime       datetime DEFAULT GetUtcDate(),
   BuildDateTime        datetime null
)
ALTER TABLE ServerDBVersion ADD 
    CONSTRAINT PK_ServerDBVersion PRIMARY KEY  NONCLUSTERED (Id)
end
[30000] (10/12 20:24:27.015):{0x11D0} SQL executed successfully
[30000] (10/12 20:24:27.015):{0x11D0} SQL being executed:
 
/*
 *  Create the ITPolicy2 table if it doesn't already exist, otherwise convert existing to new 
 */
IF NOT EXISTS (SELECT name FROM sysobjects WHERE name = 'ITPolicy2' AND type = 'U')
begin
CREATE TABLE dbo.ITPolicy2
(
   Id                  int IDENTITY (1,1) NOT FOR REPLICATION NOT NULL,
   PolicyName          varchar(128) not null,
   AllowOtherEmailServices int not null default(1),
   AllowOtherBrowserServices int not null default(1),
   HandheldBlob        image,
   DesktopBlob         image,
   SessionId           int null,
   Lurnum              timestamp not null   
)
alter table ITPolicy2 add
        CONSTRAINT IX_ITPolicy2_PolicyName UNIQUE  CLUSTERED (PolicyName),
        CONSTRAINT ITPolicy2_PK PRIMARY KEY (Id)
end
[30000] (10/12 20:24:27.015):{0x11D0} SQL executed successfully
[30000] (10/12 20:24:27.015):{0x11D0} SQL being executed:
 
/*
 * add default policy
 */
if not exists (select PolicyName from itpolicy2 where PolicyName = 'Default')
begin
    insert into itpolicy2 (PolicyName, HandheldBlob) 
                   values ('Default', 0x050744656661756c7401)
end
[20000] (10/12 20:24:27.015):{0x11D0} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E37 - IDispatch error #3127 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Invalid object name 'itpolicy2'." Native error = 208
[20000] (10/12 20:24:27.015):{0x11D0} [CBESDBInstaller::ExecuteDDL] SQL Error for:

/*
 * add default policy
 */
if not exists (select PolicyName from itpolicy2 where PolicyName = 'Default')
begin
    insert into itpolicy2 (PolicyName, HandheldBlob) 
                   values ('Default', 0x050744656661756c7401)
end
[10000] (10/12 20:24:27.031):{0x11D0} An attempt to install the database was unsuccessful. An error occurred while executing an SQL statement.. Failed to create the database [BESMgmt].

BlackBerry Forums Support Community

Fresh Install 5.0 Remote SQL Error