BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 04-09-2008, 01:36 PM   #1 (permalink)
New Member
 
Join Date: Apr 2008
Model: 8830
PIN: N/A
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 01:57 PM.
Offline  
Old 04-12-2008, 06: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
Default

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
__________________
Cheers,
Ash


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

meh?
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

NEW MSA ALTAIR ALTAIR2X H2S-LC 2 Gas detector 10154076C Sealed
$89.0
NEW MSA ALTAIR ALTAIR2X H2S-LC 2 Gas detector 10154076C Sealed pictureMSA Altair Pro PH3 Phosphine Gas Detector, Steel Mill Version, Low / High Alarm
$369.0
MSA Altair Pro PH3 Phosphine Gas Detector, Steel Mill Version, Low / High Alarm pictureMSA 10092521 Hydrogen Sulfide Altair Single Gas Detector (H2S)
$80.0
MSA 10092521 Hydrogen Sulfide Altair Single Gas Detector (H2S) pictureMSA ALTAIR 4X CALIBRATED WORKS GREAT WITH CHARGER
$0.99
MSA ALTAIR 4X CALIBRATED WORKS GREAT WITH CHARGER pictureAltair CO Pro Gas-Detector Alternate Carbon Monoxide MSA 10076719C
$85.0
Altair CO Pro Gas-Detector Alternate Carbon Monoxide MSA 10076719C picture






Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.