BES 4.1.4 to 4.1.6 Upgrade query

[rqi253]

Hi All,

I was wondering if anyone can assist with an issue I am experiencing when attempting to upgrade my BES from 4.1.4 to 4.1.6.

When I ran through the upgrade process an error was returned with the following" An attempt to upgrade the database was unsuccessful. An error occured while executing an SQL statement".

Below is what I found in the logs. Any ideas if this error could be because my BES system account does not have SYS admin rights to the BES config database? My SQL databse admins are a bit security concious!

Below is a copy of the log.

[30000] (10/14 21:28:09.259):{0xE44} Progress update 500. Current position is 8088 of 8088 = 100%

[30000] (10/14 21:28:09.259):{0xE44} Executing file [c:\Program Files\Research In Motion\BlackBerry Enterprise Server\Logs\Installer\BES_SQL_Generated\SchedulePu rgeJobsV091014212809.sql]

[30000] (10/14 21:28:09.259):{0xE44} 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] (10/14 21:28:09.259):{0xE44} SQL executed successfully

[30000] (10/14 21:28:09.259):{0xE44} SQL being executed:

/*+---------------------------------------------------------------------------

* RIMPurgeHistory - delete rows from ServerConfigHistory table

*+--------------------------------------------------------------------------*/

exec sp_add_job 'RIMPurgeHistoryBesMgmt',

@description = 'Remove old data from history table'

[20000] (10/14 21:28:09.259):{0xE44} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E09 - IDispatch error #3081 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "The EXECUTE permission was denied on the object 'sp_add_job', database 'msdb', schema 'dbo'." Native error = 229

[20000] (10/14 21:28:09.259):{0xE44} [CBESDBInstaller::ExecuteDDL] SQL Error for /*+---------------------------------------------------------------------------

* RIMPurgeHistory - delete rows from ServerConfigHistory table

*+--------------------------------------------------------------------------*/

exec sp_add_job 'RIMPurgeHistoryBesMgmt',

@description = 'Remove old data from history table'

[30000] (10/14 21:29:50.137):{0xE44} [PIPTOOL]: Exiting PIPTool from DBInfoDlg.

====== END OF LOG ======

[GlenB]

I think you have already answered your own question rqi253. The error being
"The EXECUTE permission was denied on the object 'sp_add_job', database 'msdb', schema 'dbo'."

To me this says the the bes admin account doesnt have the require privileges on the msdb database. Have you sent this error to your SQL admin for his opinion?

[amrishpatel54]

Check SQL Login credentials and permissions for BESAdmin over the SQL. Make sure that BESAdmin is in the Local Admin Group.

[rqi253]

Thanks all. It was do do with the privileges of my BES account. Once the account was given the SYS ADMIN privileges I had no further issues. It was good to bounce this off a couple of people!

Cheers
RQI253

[GlenB]

No problem rqi253, glad we could help.