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
Highlighted
New Contributor
Posts: 7
Registered: ‎11-01-2011
My Device: Blackberry Torch
My Carrier: Vodafone

Help - Blackberry BES 5.0.0 to 5.0.3 Upgrade

I need to upgrade my BES database from 5.0.0 to upgrade 5.0.3 on Windows 2008 R2 Server,

 

This error displayed

 

[20000] (10/14 12:41:40.459):{0x23C8} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "There are no primary or candidate keys in the referenced table 'SyncDataSource' that match the referencing column list in the foreign key 'FK_SyncGlobalMappingVersion_SyncDataSource'." Native error = 1776
[20000] (10/14 12:41:40.461):{0x23C8} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Could not create constraint. See previous errors." Native error = 1750
[20000] (10/14 12:41:40.462):{0x23C8} [CBESDBInstaller::executeRetryDDL] SQL Error for:

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'SyncGlobalMappingVersion' AND type = 'U')
BEGIN
CREATE TABLE dbo.SyncGlobalMappingVersion
(
    Id                  INT IDENTITY (1,1) NOT FOR REPLICATION NOT NULL,
    SyncDataSourceId    SMALLINT NOT NULL,
    BESVersion          BIGINT NOT NULL,
    XMLMapping          NTEXT NOT NULL,
    Lurnum              TIMESTAMP,

    CONSTRAINT PK_SyncGlobalMappingVersion PRIMARY KEY (Id),
    CONSTRAINT FK_SyncGlobalMappingVersion_SyncDataSource FOREIGN KEY (SyncDataSourceId)
            REFERENCES SyncDataSource(Id) ON DELETE NO ACTION ON UPDATE CASCADE
)
END

Guru III
Posts: 32,189
Registered: ‎06-25-2008
My Device:

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

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

Re: Help - Blackberry BES 5.0.0 to 5.0.3 Upgrade

That is not a common error.

 

please contact support

 

let us know what they find

 

 


Sign up for free to the BlackBerry Expert Support Center.

https://www.blackberry.com/besc/dashboard/

All at absolutely no cost to you or your organization!

The BESC gives you a suite of valuable tools, and includes a Complimentary Support Incident should you need to contact BlackBerry Technical Support directly.




 




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 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


New Contributor
Posts: 7
Registered: ‎11-01-2011
My Device: Blackberry Torch
My Carrier: Vodafone

Re: Help - Blackberry BES 5.0.0 to 5.0.3 Upgrade

In the UK Dashboard isnt free,  my BES has already been register by another analyst