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 - DAMAR EL259 - 120/277V INSTANT START BALLAST P/N 4983C
$14.0
NEW - DAMAR EL259 - 120/277V INSTANT START BALLAST P/N 4983C pictureGE Electronic Ballast GE-332-MAX-H/Ultra Product Code 49776 (Case of 9 )
$75.0
GE Electronic Ballast GE-332-MAX-H/Ultra Product Code 49776 (Case of 9 ) pictureBallast NEW Philips Advance Electronic Driver LEDINTA0024V20FLO Xitanium RoHS
$38.5
Ballast NEW Philips Advance Electronic Driver LEDINTA0024V20FLO Xitanium RoHS pictureUniversal WPR-480-X-LHR Weatherproof Ballast 120 VAC HO T12 RS Lamp NEW
$99.99
Universal WPR-480-X-LHR Weatherproof Ballast 120 VAC HO T12 RS Lamp NEW  picturePhilips Advance 10637 - ICN-3P32-SC T8 IntelliVolt Fluorescent Ballast New
$12.5
Philips Advance 10637 - ICN-3P32-SC T8 IntelliVolt Fluorescent Ballast New picture






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