Page 1 of 1

Shared Database has Stopped Syncing

PostPosted: Sat Aug 23, 2014 10:20 am
by MidCoast Jim
Why does this happen? And, what can I do in the future to avoid it?

I just noticed that a record on my iPhone I had JUST edited in my pdb CCard_Pays.PDB did not sync to the HDB Desktop. As a matter of fact: the changes I had made on the phone had obviously been overwritten by the desktop version of the pdb.

Here are two excerpts from this morning's Sync Log:

Log lines 8 - 11
08-23-2014 09:11: Installing File: C:\Users\ShepJim\Documents\HanDBase\EC3IPhone5C\Install\CCard_Pays.PDB...
08-23-2014 09:11: Sending CCard_Pays.PDB to iPhone/iPad..
08-23-2014 09:11: Error: Code 200: HTTP/1.1 200 OK
08-23-2014 09:11: Installing File: C:\Users\ShepJim\Documents\HanDBase\EC3IPhone5C\Install\CCard_Pays.PDB...Error: <ÈvžY


and

Log lines 125 - 136
08-23-2014 09:11: Reading Shared Database Settings for: CCard_Pays
08-23-2014 09:11: Database: CCard_Pays Sync Mode: Synchronize
08-23-2014 09:11: Synchronizing Database: CCard_Pays...
08-23-2014 09:11: Getting iPhone/iPad Database To Sync with Desktop: CCard_Pays...
08-23-2014 09:11: Getting iPhone/iPad Database To Sync with Desktop: CCard_Pays...OK
08-23-2014 09:11: Syncing with Desktop Database: CCard_Pays...
08-23-2014 09:11: Syncing with Desktop Database: CCard_Pays...OK
08-23-2014 09:11: Saving Changes to iPhone: CCard_Pays...
08-23-2014 09:11: Sending CCard_Pays.PDB to iPhone/iPad..
08-23-2014 09:11: Error: Code 200: HTTP/1.1 200 OK
08-23-2014 09:11: Saving Changes to iPhone: CCard_Pays...Error:


From looking at the records in the database it would appear that pdb has not correctly sync'ed since early last month (July).

How do I fix the current situation? And, even more importantly, how do I insure that this cannot happen in the future? To guarantee the integrity of my data should I stop "sharing" and just sync from one device to the desktop back and forth? Something in the sharing environment seems very tender/unstable.

Jim

Re: Shared Database has Stopped Syncing

PostPosted: Tue Aug 26, 2014 5:29 am
by Brian_Houghton
Hi Jim,

Thanks for writing.

In this scenario, if you queue a database for installation on the desktop, the conduit will process that first and overwrite the database on the handheld with that desktop copy. In this case, since there was unsynced data in the handheld copy, it was lost as a result of this. To avoid this problem, if you have data on the handheld that needs syncing, avoid reinstalling the copy from the desktop, at least until the sync is done.

Regarding the error shown in the log, please try the following:

- Make a change to the database on the handheld
- Do not make a change on the desktop
- Sync
- Verify whether or not the change synced
- Post the most recent section of the log and let us know whether the changed did or did not sync properly

Thanks in advance for this.

Re: Shared Database has Stopped Syncing

PostPosted: Tue Aug 26, 2014 8:12 am
by MidCoast Jim
Hi Brian —

Okay, followed your directions — actually went through the process twice just in case I had made a change to the desktop version of ccard.pdb and hadn't synced since.

On the iPhone I both modified an existing entry and added a new entry. NEITHER of those changes synced to HDB on the Desktop and they disappeared from ccard.pdb back on the phone.

Here are the relevant lines from the most recent Log.

Log Lines: 11 - 17
08-26-2014 08:45: Installing File: C:\Users\ShepJim\Documents\HanDBase\EC3IPhone5C\Install\CCard_Pays.PDB...
08-26-2014 08:45: Sending CCard_Pays.PDB to iPhone/iPad..
08-26-2014 08:45: Error: Code 200: HTTP/1.1 200 OK
08-26-2014 08:45: Installing File: C:\Users\ShepJim\Documents\HanDBase\EC3IPhone5C\Install\CCard_Pays.PDB...Error: <BvžY
08-26-2014 08:45: Installing File:


Log Lines 137 - 147
08-26-2014 08:45: Reading Shared Database Settings for: CCard_Pays
08-26-2014 08:45: Database: CCard_Pays Sync Mode: Synchronize
08-26-2014 08:45: Synchronizing Database: CCard_Pays...
08-26-2014 08:45: Getting iPhone/iPad Database To Sync with Desktop: CCard_Pays...
08-26-2014 08:45: Getting iPhone/iPad Database To Sync with Desktop: CCard_Pays...OK
08-26-2014 08:45: Syncing with Desktop Database: CCard_Pays...
08-26-2014 08:45: Syncing with Desktop Database: CCard_Pays...OK
08-26-2014 08:45: Saving Changes to iPhone: CCard_Pays...
08-26-2014 08:45: Sending CCard_Pays.PDB to iPhone/iPad..
08-26-2014 08:45: Error: Code 200: HTTP/1.1 200 OK
08-26-2014 08:45: Saving Changes to iPhone: CCard_Pays...Error:


I haven't followed up yet, but looking at the "installing file" section at the top of the log I have six additional databases which are behaving the same as ccard.pdb. Thankfully, none of these are quite as critical in my day-to-day.

Please keep me moving toward a solution — thank you!

Jim