BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 09-11-2009, 07:12 PM   #1 (permalink)
New Member
 
Join Date: Sep 2009
Model: 9000
PIN: N/A
Carrier: AT&T
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default An attempt to upgrade the database was unsuccessful

Please Login to Remove!

I have a Windows Server 2003 SP2 with Exchange 2003 and BES 4.1.3 and I attempted to upgrade to SP 4.1.6. After attempting the upgrade I received the following error: "An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement"

I've searched blackberry and the forums, but all the solutions don't seem to fit this error message. At least the solutions that I have found didn't contain the correct error msg's.

I would really appreciate any insight into this problem. Thank you.

Here are the last few lines from the Installer.log file:

[30000] (09/08 01:10:33.507):{0x2374} SQL executed successfully
[30000] (09/08 01:10:33.507):{0x2374} Processing file 4.1.2\SchedulePurgeJobs.sql
[30000] (09/08 01:10:33.507):{0x2374} GetScriptDir - Scripts loading from: C:\Documents and Settings\Besadmin\Desktop\BESSP6\Database\DBInstal lScripts\SqlServer\
[30000] (09/08 01:10:33.507):{0x2374} Replacing variables in [C:\Documents and Settings\Besadmin\Desktop\BESSP6\Database\DBInstal lScripts\SqlServer\4.1.2\SchedulePurgeJobs.sql]
[30000] (09/08 01:10:33.523):{0x2374} Progress update 500. Current position is 9000 of 9000 = 100%
[30000] (09/08 01:10:33.523):{0x2374} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\Logs\Installer\BES_SQL_Generated\SchedulePu rgeJobsV090908011033.sql]
[30000] (09/08 01:10:33.523):{0x2374} SQL being executed:
/************************************************** **************************
SchedulePurgeJobs.sql

This SQL script will create the jobs that will remove old data

Procedure List:

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

/*

Note - There is no easy of determining if these jobs exists unless one is a member of
sysadm (as queries would be needed against msdb tables and public doesn't have access).

Thus, the installer program running this script will suppress errors that get reported
when the job already exists.

*/

USE msdb
[30000] (09/08 01:10:33.523):{0x2374} SQL executed successfully
[30000] (09/08 01:10:33.523):{0x2374} SQL being executed:
/*+---------------------------------------------------------------------------
* RIMPurgeHistory - delete rows from ServerConfigHistory table
*+--------------------------------------------------------------------------*/
exec sp_add_job 'RIMPurgeHistoryBESMgmt',
@description = 'Remove old data from history table'
[30000] (09/08 01:10:33.523):{0x2374} SQL executed successfully
[30000] (09/08 01:10:33.523):{0x2374} SQL being executed:
exec sp_add_jobstep @job_name = 'RIMPurgeHistoryBESMgmt',
@step_id = 1,
@step_name = 'DoIt',
@database_name = 'BESMgmt',
@command = 'exec RemoveOldHistoryRows 60' -- 60 day retention
[20000] (09/08 01:10:33.523):{0x2374} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "SQL Server blocked access to procedure 'sys.xp_sqlagent_is_starting' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. " Native error = 15281
[30000] (09/08 01:10:33.523):{0x2374} SQL executed successfully
[30000] (09/08 01:10:33.523):{0x2374} SQL being executed:
exec sp_add_jobschedule @job_name = 'RIMPurgeHistoryBESMgmt',
@name = 'RIMPurgeHistory',
@freq_type = 8, -- weekly
@freq_interval = 1, -- Sunday
@freq_recurrence_factor = 1, -- every week
@active_start_time = 10000 -- 1:00 am
[20000] (09/08 01:10:33.538):{0x2374} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "SQL Server blocked access to procedure 'sys.xp_sqlagent_is_starting' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. " Native error = 15281
[20000] (09/08 01:10:33.538):{0x2374} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "SQL Server blocked access to procedure 'sys.xp_sqlagent_is_starting' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. " Native error = 15281
[20000] (09/08 01:10:33.538):{0x2374} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "SQL Server blocked access to procedure 'sys.xp_sqlagent_is_starting' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. " Native error = 22022
[20000] (09/08 01:10:33.538):{0x2374} [CBESDBInstaller::ExecuteDDL] SQL Error for exec sp_add_jobschedule @job_name = 'RIMPurgeHistoryBESMgmt',
@name = 'RIMPurgeHistory',
@freq_type = 8, -- weekly
@freq_interval = 1, -- Sunday
@freq_recurrence_factor = 1, -- every week
@active_start_time = 10000 -- 1:00 am
[30000] (09/08 01:15:47.690):{0x2374} [PIPTOOL]: Exiting PIPTool from DBInfoDlg.
====== END OF LOG ======
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.