BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 02-01-2008, 04:40 PM   #1 (permalink)
New Member
 
Join Date: Sep 2005
Model: 8830
Carrier: Verizon
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Question Merge Database Error

Please Login to Remove!

I've been working with RIM over a corrupt database for some time now. The final solution, which they tested and verified that works, was to merge the existing database into a new db. After they tested it, they verified that all the corruption was repaired. The tech I've been working with is out, so I'm left somewhat helpless.

So I set off today testing this theory on my own and roughly half an hour into the merge, it is terminating with an error...

Code:
[0057] (02/01 13:38:48) TableMerger::MergeTables - Merging record: UserConfigId='199', DatabaseName='AutoText', UID='1760480179'
[0063] (02/01 13:38:48) SyncBackupRestoreTable::ReplaceFKeys - Replacing foreign key value: UserConfigId=27
[0064] (02/01 13:38:48) SyncBackupRestoreTable::ReplaceFKeys - Using new foreign key value: UserConfigId=199
[0057] (02/01 13:38:48) TableMerger::MergeTables - Merging record: UserConfigId='199', DatabaseName='AutoText', UID='1760480180'
[0000] (02/01 13:38:48) TableMerger::MergeTable - SyncBackupRestore - Finished merging tables.
[0000] (02/01 13:38:48) TableMerger::MergeTable - SyncUserState - Error! Unable to retrieve record set from source database.
[0000] (02/01 13:38:48) TableMerger::LogSQLError - [Microsoft][ODBC SQL Server Driver]Communication link failure Error Code: 0
[0000] (02/01 13:38:48) TableMerger::LogSQLError - SELECT UserConfigId,SyncUserStateTypeId,State FROM SyncUserState 
[0049] (02/01 13:38:48) DBMerger::MergeDatabases - Error merging BES databases.
[0034] (02/01 13:38:48) DBMerger::~DBMerger - Disconnecting from source database.
[0035] (02/01 13:38:48) DBMerger::~DBMerger - Disconnecting from destination database.
[0003] (02/01 13:38:48) main - Program terminating with error code -8
[0009] (02/01 13:38:48) main - DBMerge.exe finished.
The new db was created with the correct revision and patch level.

the original error that they found was a misordering of several tables. The symptom on my end was activation hanging, and when trying to remove a user, an error of "Unable to remove user ""..." (empty quotes instead of the users name.

Any ideas what I can do at this point?
Offline  
Old 02-01-2008, 06:37 PM   #2 (permalink)
BlackBerry Extraordinaire
 
gibson_hg's Avatar
 
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You could try using DBCC CHECKDB against the corrupt database to check for inconsistences and then run DBCC DBREINDEX against the tables listed in the log from CHECKDB to reindex the tables.

I have used this a few times when there were issues with certain tables, like the SyncBAckupRestore table listed in your log.

Give that a try, it might help you get the databases merged.
Offline  
Old 02-02-2008, 12:11 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

try logging into the source sql server remotely
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

SOUTHBEND CNTRL B DIGITAL POTENTIOMETER 1181998 NEW OEM With New Temp Sensor
$200.0
SOUTHBEND CNTRL B DIGITAL POTENTIOMETER 1181998 NEW OEM With New Temp Sensor picture10 Pcs WH148 Type B5K Ohm Linear Taper Rotary Potentiometer Panel Pot 3 Pin DJNS
$2.49
10 Pcs WH148 Type B5K Ohm Linear Taper Rotary Potentiometer Panel Pot 3 Pin DJNS picture3590S-2-502L 5K Ohm Rotary Wirewound Precision Potentiometer Pot 10 Turn
$0.01
3590S-2-502L 5K Ohm Rotary Wirewound Precision Potentiometer  Pot 10 Turn picture46mm B2 Dial Multi-Turn Potentiometer knob Cap Switch U
$7.77
46mm B2 Dial Multi-Turn Potentiometer knob Cap Switch U picture46mm B2 Dial Multi-Turn Potentiometer knob Cap Switch D
$7.89
46mm B2 Dial Multi-Turn Potentiometer knob Cap Switch D picture






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