BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-19-2010, 08:56 AM   #1 (permalink)
New Member
 
Join Date: May 2009
Model: 9000
PIN: N/A
Carrier: O2
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default can't upgrade BESx from 5.0.1 to 5.0.2 - sql error

Please Login to Remove!

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....
Offline  
Old 08-19-2010, 10:04 AM   #2 (permalink)
Thumbs Must Hurt
 
Join Date: Sep 2009
Location: Ft. Bragg
Model: 9000
OS: 4.6.0.304
PIN: N/A
Carrier: ATT
Posts: 67
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Offline  
Old 08-19-2010, 01:13 PM   #3 (permalink)
New Member
 
Join Date: May 2009
Model: 9000
PIN: N/A
Carrier: O2
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Fixed!!!!

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

Computers eh? lol
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.