BlackBerry Forums Support Community               

Closed Thread
LinkBack Thread Tools
Old 04-09-2008, 02:36 PM   #1 (permalink)
New Member
Join Date: Apr 2008
Model: 8830
Carrier: Sprint
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default DB Migration

Please Login to Remove!

I am currently working on moving the BESMgmt database to a full version SQL Server. I successfully migrated and had the BES Management application working on our test SQL Server, but when I do the same procedures to the live SQL Server I get this error. Any ideas on why. I can change parameters back to test and it works. I have tried w/ a restore from the test DB as well as directly from the original BES Server.

[20000] (04/09 14:19:51.360):{0x1744} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 23000 Native error: 547 Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_RelationSCMDS_ServerConfig". The conflict occurred in database "BESMgmt", table "dbo.ServerConfig", column 'Id'.

Last edited by ssteckley : 04-09-2008 at 02:57 PM.
Old 04-12-2008, 07:28 AM   #2 (permalink)
CrackBerry Addict
ashworth's Avatar
Join Date: Jun 2006
Location: Ontario, Canada
Model: 9000
OS: 4.6
Carrier: Rogers
Posts: 625
Post Thanks: 0
Thanked 0 Times in 0 Posts

I would maybe try to get a new backup of the database, and then restore it. The error you posted looks like you are trying to do a hack to the database schema

My BlackBerry GPS Golf Application | Mileage Calculator
Old 04-17-2008, 07:48 AM   #3 (permalink)
BlackBerry Genius
hdawg's Avatar
Join Date: Aug 2006
Model: hdawg
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts

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
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.