Shared Database has Stopped Syncing

Discussion of the version of HanDBase that runs on the iPhone and iPod touch devices. This includes the synchronization conduits as well.

Shared Database has Stopped Syncing

Postby MidCoast Jim » Sat Aug 23, 2014 10:20 am

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
MidCoast Jim
 
Posts: 39
Joined: Wed Jan 09, 2013 3:57 pm

Re: Shared Database has Stopped Syncing

Postby Brian_Houghton » Tue Aug 26, 2014 5:29 am

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.
Kind Regards,
Brian Houghton, DDH Software
Brian_Houghton
 
Posts: 2246
Joined: Wed May 20, 2009 8:30 am

Re: Shared Database has Stopped Syncing

Postby MidCoast Jim » Tue Aug 26, 2014 8:12 am

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
MidCoast Jim
 
Posts: 39
Joined: Wed Jan 09, 2013 3:57 pm


Return to HanDBase for iPhone and iPod touch

Who is online

Users browsing this forum: No registered users and 0 guests