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

Dell DP/N 023NVR Display Port to DVI-D Cable Adapter NEW OEM -
$8.95
Dell DP/N 023NVR Display Port to DVI-D Cable Adapter NEW OEM -  pictureGenuine OEM Dell 3200MP Osram Replacement Lamp & Housing 310-2328
$79.99
Genuine OEM Dell 3200MP Osram Replacement Lamp & Housing  310-2328 pictureDELL 725-BBBQ Lamp manufactured by DELL
$165.54
DELL 725-BBBQ Lamp manufactured by DELL pictureOEM BULB with Housing for DELL 330-6581 Projector with 180 Day Warranty
$124.0
OEM BULB with Housing for DELL 330-6581 Projector with 180 Day Warranty pictureOEM BULB with Housing for DELL 1610X Projector with 180 Day Warranty
$124.0
OEM BULB with Housing for DELL 1610X Projector with 180 Day Warranty picture






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