Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

BlackBerry® Enterprise Service 10

Reply
New Contributor
dvine
Posts: 7
Registered: ‎10-12-2009
My Device: Not Specified
Accepted Solution

Fresh Install 5.0 Remote SQL Error

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

 

[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].

Please use plain text.
Guru III
knottyrope
Posts: 30,349
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: Fresh Install 5.0 Remote SQL Error

You wrote

A clean (first) install of BES 5.0 on my back-end exchange 2003 sp1 server


 

Not a supported install. You may run into other issues.

 

Did you assign SQL permissions?

 

Read over this for your version, It contains info for many versions.

KB02276 - Assigning permissions for a BlackBerry Enterprise Server service account

 

 

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 5.0.4 and BES 10.2.2 with Exchange 2010 and SQL 2008


Please use plain text.
New Contributor
dvine
Posts: 7
Registered: ‎10-12-2009
My Device: Not Specified

Re: Fresh Install 5.0 Remote SQL Error

Hi knottyrope,

 

When you say unsupported, what exactly does that mean? The way I have installed the software (i.e. install on backend exchange), or are you referring to BES 5.0 on a backend exchange 2003/remote sql 2000 install?

 

What exactly is recommended? On a BES on a front end, or completely seperate server which is not utilised?

 

I guess my main concern at the moment is trying to get the software up and running.

 

Cheers,

 

dvine

Please use plain text.
Guru III
knottyrope
Posts: 30,349
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: Fresh Install 5.0 Remote SQL Error

BES should be installed on its own dedicated server and knot on exchange.

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 5.0.4 and BES 10.2.2 with Exchange 2010 and SQL 2008


Please use plain text.
New Contributor
dvine
Posts: 7
Registered: ‎10-12-2009
My Device: Not Specified

Re: Fresh Install 5.0 Remote SQL Error

Hi Knotty.

 

Thanks for your reply. I was able to install it on a seperate server using MSDE. I guess the problem was somewhere with SQL permissions. I guess this MSDE install will do fine considering we only have 5 blackberry users at the moment which might grow to about 10-15 max.

 

You first reply led me in the right direction (kinda). =)

 

Cheers for the heads.

 

dvine

 

 

Please use plain text.
Guru III
knottyrope
Posts: 30,349
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: Fresh Install 5.0 Remote SQL Error

MSDE will handle you for some time, after about 400 users you might run into issues.

 

Also for a neat backup for MSDE

http://sqlbackupandftp.com/

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 5.0.4 and BES 10.2.2 with Exchange 2010 and SQL 2008


Please use plain text.