please can someone offer some advice on this issue...

I have a fully working BES express 5.0.1 installation on an exchange 2007 server sitting on a server2008 x64 machine....

When i try to install the 5.0.2 update, at the first step it asks to upgrade the BESmgmt database... - i say yes, it sits and waits for half an hour showing "upgrading blackberry configuration database",

then fails saying "An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement."

if i look in the installer log it says:

---

[20000] (08/19 14:52:18.256):{0x1324} [CBESDBInstaller::executeRetryDDL] Timeout expired 0x80040E31
[20000] (08/19 14:52:18.256):{0x1324} [CBESDBInstaller::executeRetryDDL] SQL Error for:
--/************************************************** **************************
-- NotifyUnInstall.sql

-- This SQL script will remove the database notification service.


-- Notes:


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


-- first step - delete notification triggers
IF object_id('dbo.objectdefn') IS NOT NULL
BEGIN
DECLARE @trigger_name sysname
DECLARE @dropstr varchar(8000)
DECLARE i_ptr CURSOR LOCAL FAST_FORWARD FOR
SELECT name FROM objectdefn
OPEN i_ptr
FETCH i_ptr INTO @trigger_name
WHILE (@@fetch_status<>-1)
BEGIN
SET @trigger_name = 'dbo.[TR_NTF_' + RTRIM(@trigger_name) + ']'
SET @dropstr='DROP TRIGGER ' + @trigger_name
IF object_id(@trigger_name) IS NOT NULL
EXEC(@dropstr)
FETCH i_ptr INTO @trigger_name
END
CLOSE i_ptr
DEALLOCATE i_ptr
END
[10000] (08/19 14:52:18.256):{0x1324} An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement.

---

Any ideas how to fix this? - I have double checked the servername/database name, account for authentication etc against the existing 5.0.1 config, and all is the same....

Do you have a Database team? looks like the SQL database config is not set up correctly. I know when I was upgrading our VMware (I know it's not BB, but it might still help), it wouldn't upgrade the DB cause it was trying to delete a table that it couldn't delete. The Database guys actually had to go manually delete it, and recreate it. Also, check your logs on the SQL server, maybe they will tell you more of what is going on.

Fixed!!!!

rebooted server after work, logged onto console rather than via RDC.. intall worked first time without a hiccup...

Computers eh? lol