Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

BlackBerry® Enterprise Service 10

Reply
JPK
Contributor
JPK
Posts: 39
Registered: ‎02-28-2012
My Device: Z10
My Carrier: Telus
Accepted Solution

BES 5.0.3 to 5.0.4 Upgrade failing

Hello,

Trying to upgrade from 5.0.3.84 to 5.0.4. During the BESMgmt database upgrade it fails with the following error in the log; Installed on Windows Server 2003, SQL 2005 Express with SP4 installed and I've checked the database compatability level from sys.databases and it is set to 90? Not sure what else I can do here?

[20000] (11/22 20:29:23.896):{0x1270} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Incorrect syntax near 'PIVOT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel." Native error = 325

 

Thanks

Please use plain text.
JPK
Contributor
JPK
Posts: 39
Registered: ‎02-28-2012
My Device: Z10
My Carrier: Telus

Re: BES 5.0.3 to 5.0.4 Upgrade failing

Nevermind, I ran EXEC sp_dbcmptlevel AdventureWorks, 90 on the SQL server and restarted the install and it worked this time.

I swear it was arleady set to 90?

Please use plain text.
Guru III
knottyrope
Posts: 29,759
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BES 5.0.3 to 5.0.4 Upgrade failing

thanks for sharing solution

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 5.0.4 and BES 10.2.2 with Exchange 2010 and SQL 2008


Please use plain text.