[abaack]

I just started installing SP5 on a 100 user BES install. Everything went smoothly up until the Database Upgrade step and now it just shows five bars for the installing/upgrading database status. It's been this way for about 15-20 minutes with the setup.exe process using about 25% of the cpu usage so it looks like it's doing something.

Is this normal or is my process hung and I should restart... if so how dangerous is it to restart the install now? If it's actually doing something I don't want to stop the install.

I do have some events in my application log that started during the install:

SQL Error: 17883, Severity: 1, State: 0
The Scheduler 3 appears to be hung. SPID 53, ECID 0, UMS Context 0x04B96978

Any help is appreciated!

[fadmin]

Make sure all connections to a database are closed. (All BB managers should be closed)

[abaack]

We only have the blackberry manager installed on the server and it's not open... it's still at the same point!

[fadmin]

How about permissions on SQL database? Is it remote SQL ol local MSDE?

[abaack]

We do have the Blackberry BAS (where you can connect the devices through a website) installed on a different computer. Don't know if that could effect it, but I just shut down that computer to see if it'll help. Do I need to restart the install?

[abaack]

Running the SQL Server desktop engin. Windows Authentication.

[fadmin]

And you are logged on as besadmin account,right?

[abaack]

Yes... I logged in the server with the same account I installed everything with.

[fadmin]

Also I usually stop all BES services before I start upgrade.

[abaack]

It stopped those automatically. No Blackberry services are running.

[abaack]

This is the last part in the installer.log file... looks like it was trying to do a backup?

[30000] (04/18 07:48:42.534):{0x3F8} SQL being executed:
/************************************************** **************************
backup.sql

This SQL script will backup the BES Mgmt database

(C) 2001-2004 Research In Motion Limited.
************************************************** **************************/
/*
* Backup to database to BACKUPDIR\DATABASENAMEBKUP.bak
*
* Note BACKUPDIR will be defaulted to location of the DATABASENAME files
*/

declare @path varchar(1024)
set @path = (select top 1 filename from sysfiles where name like 'BESMgmt2%')
if @path is null
begin
set @path = (select top 1 filename from sysfiles)
end


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

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

--find the last . so we can drop everything after it and replace with bak
while (@notdone = 1)
begin
set @indx = (select charindex('.',@path,@indx + 1))
if @indx > 0
begin
set @lastindx = @indx
end
else
begin

[fadmin]

I use remote full sql so it is hard to say what might be different. Is it still at the 5 bars? For me complete upgrade took 10 minutes.

[fadmin]

You upgraded from 4.1.4 or ? Exchange?

[abaack]

Yep, nothing's changed.... I'm going to try and restart it.

[fadmin]

Good luck and hope you had backup done before you started upgrade.

[abaack]

4.1.4 for Exhange 2003

[abaack]

Woohoo... rebooted server... made sure none of the BES services started up automatically. Also, I noticed the sql agent had not been running so I started that up and ran all the optimization jobs and reran the setup and it's flying now! Thanks again!

[fadmin]

Great. Have a good weekend.

[abaack]

Also, my server had the one BES database consistency service set to manual and not running. Is this correct?

[fadmin]

That is ok.