Zyncs fine but no changes are made!

Help, Tips, and Tricks for deploying GoZync: our "sync" engine for FileMaker Go.
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Mon Nov 05, 2012 5:22 pm
Hi,
I'm hoping there's someone still working in the SeedCode office, as its after 1am here and I'm stuck.

GoZync integration is done and all files are on my desktop. The Zync seems to work fine but no changes are being made on either the Hosted or Mobile files. Urgent help needed, as I need to get these files back on our remote host before the morning.

11/6/2012 1:18:15 AM - Started
-------------------------
Split Total
0:00:00 - 0:00:00 - Public API Started: Group
0:00:00 - 0:00:00 - Connecting to server...
0:00:00 - 0:00:00 - Getting settings from Host...
0:00:00 - 0:00:00 - Running default action for Group : Round Trip
0:00:00 - 0:00:00 - Assembling the package: Group
0:00:00 - 0:00:00 - No changed records found: Group
0:00:00 - 0:00:00 - Processing this device's Inbox on the Host
0:00:01 - 0:00:01 - Asking the host for changed records: pulling down.
0:00:00 - 0:00:01 - Retrieving the Outbox from Host
0:00:00 - 0:00:01 - Processing 1 of 1 packages recd. (0 records)
0:00:00 - 0:00:01 - Looking for records to delete
0:00:00 - 0:00:01 - Record deletion completed
0:00:00 - 0:00:01 - Processing completed
0:00:00 - 0:00:01 - Closing GoZyncMobile

Thanks
Brian.
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Mon Nov 05, 2012 5:41 pm
Hi Brian,

Sorry, but we're done for the day and won't be able to resolve this tonight. This log from the host and is saying it's not finding any changes on the hosted file.

0:00:00 - 0:00:00 - No changed records found: Group

The log in the Mobile GoZync will tell us what's happening there if you could send that as well, and we can take a look. Setting the initial values of the timestamps in both files might resolve this and I'd also try pressing the Reset button on the lower left of the GoZyncMobile which says you haven't synced yet.

If you'd like to send me a copy of your files, I should have a chance to give them a quick review tomorrow to see if I can quickly tell what's going on. Contact me at [email protected] and we can make arrangements. If it's not something simple and you need help with the integration, then we do offer that as a service as well.

Thanks!
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Mon Nov 05, 2012 5:43 pm
Hi Brian,

Providing your file references are correct (that GoZync is talking to the correct copy of your files) it looks like GoZync didn't see any changes. This could be because a) no records have been modified since last sync, or b) that you need to hit "reset" in the lower left of the main screen in GoZyncMobile.

It could also be that no Group records belong to the logged in user (if you're filtering your found set)

Thanks for the log, btw.

- John
John Sindelar
SeedCode
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Mon Nov 05, 2012 5:47 pm
Hi,
This is from GoZyncMobile:

11/6/2012 1:46:30 AM - Started
-------------------------
Split Total
0:00:00 - 0:00:00 - Public API Started: Group
0:00:00 - 0:00:00 - Connecting to server...
0:00:01 - 0:00:01 - Getting settings from Host...
0:00:00 - 0:00:01 - Running default action for Group : Round Trip
0:00:00 - 0:00:01 - Assembling the package: Group
0:00:00 - 0:00:01 - No changed records found: Group
0:00:00 - 0:00:01 - Processing this device's Inbox on the Host
0:00:00 - 0:00:01 - Asking the host for changed records: pulling down.
0:00:00 - 0:00:01 - Retrieving the Outbox from Host
0:00:00 - 0:00:01 - Processing 1 of 1 packages recd. (0 records)
0:00:00 - 0:00:01 - Looking for records to delete
0:00:00 - 0:00:01 - Record deletion completed
0:00:00 - 0:00:01 - Processing completed
0:00:01 - 0:00:02 - Closing GoZyncMobile

I'll check the reset button out now, many thanks...
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Mon Nov 05, 2012 6:24 pm
11/6/2012 2:19:36 AM - Started
-------------------------
Split Total
0:00:00 - 0:00:00 - Public API Started: Group
0:00:00 - 0:00:00 - Connecting to server...
0:00:00 - 0:00:00 - Getting settings from Host...
0:00:00 - 0:00:00 - Running default action for Group : Pull
0:00:00 - 0:00:00 - Asking the host for changed records: pulling down.
0:00:01 - 0:00:01 - Retrieving the Outbox from Host
0:00:00 - 0:00:01 - Processing 1 of 1 packages recd. (4 records)
0:00:00 - 0:00:01 - Looking for records to delete
0:00:00 - 0:00:01 - Record deletion completed
0:00:00 - 0:00:01 - ERROR:102 - We couldn't set this field "GroupAddress::_kfGroupID"
0:00:00 - 0:00:01 - ERROR:102 - We couldn't set this field "GroupAddress::Address1"
0:00:00 - 0:00:01 - ERROR:102 - We couldn't set this field "GroupAddress::Town"
0:00:00 - 0:00:01 - ERROR:102 - We couldn't set this field "GroupAddress::Address2"
0:00:00 - 0:00:01 - ERROR:102 - We couldn't set this field "GroupAddress::County"
0:00:00 - 0:00:01 - ERROR:102 - We couldn't set this field "GroupAddress::Postcode"
0:00:00 - 0:00:01 - ERROR:102 - We couldn't set this field "GroupAddress::CoRegNo"
0:00:01 - 0:00:02 - ERROR:102 - We couldn't set this field "GroupAddress::_kfGroupID"
0:00:00 - 0:00:02 - ERROR:102 - We couldn't set this field "GroupAddress::Address1"
0:00:00 - 0:00:02 - ERROR:102 - We couldn't set this field "GroupAddress::Town"
0:00:00 - 0:00:02 - ERROR:102 - We couldn't set this field "GroupAddress::County"
0:00:00 - 0:00:02 - ERROR:102 - We couldn't set this field "GroupAddress::Postcode"
0:00:00 - 0:00:02 - ERROR:102 - We couldn't set this field "GroupAddress::_kfGroupID"
0:00:00 - 0:00:02 - ERROR:102 - We couldn't set this field "GroupAddress::Address1"
0:00:00 - 0:00:02 - ERROR:102 - We couldn't set this field "GroupAddress::Town"
0:00:00 - 0:00:02 - ERROR:102 - We couldn't set this field "GroupAddress::Address2"
0:00:00 - 0:00:02 - ERROR:102 - We couldn't set this field "GroupAddress::County"
0:00:00 - 0:00:02 - ERROR:102 - We couldn't set this field "GroupAddress::Postcode"
0:00:00 - 0:00:02 - Processing completed
0:00:00 - 0:00:02 - Closing GoZyncMobile

Hmm, not sure where to start with these errors as something must not be matching up...
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Mon Nov 05, 2012 7:07 pm
Hmm, the hosted file is now updating the mobile file but only if I press the 'Reset' button first. GoZync options are set to 'round trip' but the mobile won't update the hoste file...
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Tue Nov 06, 2012 5:37 am
Please ignore the above log files, as I've made a little progress in that hosted now updates mobile but not the other way around. Email sent, hope you can help soon...

thanks
Brian.
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Tue Nov 06, 2012 9:11 am
Hi Brian,

I got the e-mail and the logs. The log is showing no changed records found on the Mobile Device. We use the GoZync fields that you added into your mobile file table: gz_ModTimeStamp, gz_Send and gz_Sent to determine what's been changed or created, so make sure those fields are there and that there calculations are correct.

Let us know if that helps.
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Tue Nov 06, 2012 9:31 am
Hi Jason,
I copied the 3 fields again and placed them on my layout to try and see what was going on.

Adding a new record generates the following:
gz_ModTimeStamp = 06/11/2012 17:24:39
gz_Send = 1
gz_Sent = 0
gz_TimeStampSent =

Ran the Zync again and the above fields remained the same?

Thanks
Brian
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Tue Nov 06, 2012 10:20 am
Copied the scripts across again just in case the implementation order made any difference but it still doesn't work.

Very disappointed with the number of hours I'm having to spend on this, not what I was expecting at all...
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Tue Nov 06, 2012 10:28 am
Brian,

I'm sorry you're having difficulty with the integration. I offered to take a look at your files to see if I could give you some quick guidance, but you haven't sent them.

We do offer integration services if you'd like us to take care of it for you. If you'd like a quote on this, I would need a copy of the files as well.

-Jason
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Tue Nov 06, 2012 10:35 am
Hi Jason,
Did you offer to look at the files by email? I've just checked but can't find anything new unless I've already deleted it by mistake.

I'll send the files across to you now, I'm tired and grumpy after wrestling with this for so long and I appreciate your time and assistance.

Thanks
Brian.
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Wed Nov 07, 2012 4:21 am
I really needed to get our company data back online without any further delay so I restarted the GoZync set up from scratch last night.

As of now, I have my Hosted, GoZyncHosted and GoZyncLicense database files back up and running on the remote FM server. So, the initial emergency is over as we are at least able to carry on using FM on office computers while we figure out the iPad sync issue.

My Mobile and GoZyncMobile databases files are now on the iPad (local). Launching the Mobile file from within GoZyncMobile works fine so I tap the 'Zync Now' button. A login box appears on the iPad while on my computer, the GoZyncHosted 'Zync Log' screen shows that the Mobile file is connected. So far so good...

I log in to the remote Hosted file using the iPad and the new record is transferred from the iPad up to the Hosted file, result! GoZyncMobile then exits.

However, adding a new record to the Hosted file and repeating the above doesn't result in that record being downloaded to the iPad. GoZyncMobile exits as above.

So frustrating to only have this working in one direction...
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Wed Nov 07, 2012 10:10 am
Hi Brian,

Thanks for sending the file! The issue turned out to be that our SQL statement that was searching for changes on the Mobile side was not working since your TO name (Group) is a reserved SQL word. We've corrected this by making sure the TO names are quoted properly in our SQL. I'll be sending you back an updated GoZyncMobile file in a minute with the fix in place, and we'll correct this bug in the stock copy asap.

You will want to remove the GZ fields that you have in your Mobile file the Group Layout as they will generate 102 errors during the sync. You have them at the top and the bottom of the layout so make sure they're all removed.

Very sorry about the trouble here and that we didn't catch this reserved word issue in our testing.

Thanks!
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Wed Nov 07, 2012 11:30 am
Thanks Jason, that's great news :)

Return to GoZync

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: