Page 1 of 1

Several Different Errors...

PostPosted: Sat Jun 15, 2013 1:54 am
by brian.curran
Hi,
I started syncing a new table 2-3 weeks ago and all appeared to be fine initially. However, I've now noticed some errors in the gzMobile sync log. The following errors appeared after creating a clone of my Mobile file and also hitting the Reset button.

00:00:00 - 00:00:17 - Asking the host for changed records: Incidents - pulling down.
00:21:21 - 00:21:38 - Retrieving the Outbox from Host
00:00:07 - 00:21:45 - ERROR:111 - We were not able to retrieve the attachments
00:00:01 - 00:21:46 - Processing 1 of 1 packages recd. (4116 records)
00:00:00 - 00:21:46 - Looking for records to delete
00:00:00 - 00:21:46 - No records present in "Incidents" - no deletion required.
00:03:42 - 00:25:28 - Processing completed

00:00:00 - 00:25:43 - Asking the host for changed records: Site - pulling down.
00:10:06 - 00:35:49 - Retrieving the Outbox from Host
00:00:25 - 00:36:14 - Processing 1 of 1 packages recd. (203 records)
00:00:00 - 00:36:14 - Looking for records to delete
00:00:00 - 00:36:14 - No records present in "Site" - no deletion required.
00:00:00 - 00:36:14 - ERROR:102 - We couldn't set this field ""
00:00:00 - 00:36:14 - ERROR:102 - We couldn't set this field ""
00:00:00 - 00:36:14 - ERROR:102 - We couldn't set this field ""
(This goes on for ever...)

We also have:
00:00:00 - 00:36:15 - ERROR:102 - We couldn't set this field "KeySeals"
00:00:00 - 00:36:15 - ERROR:102 - We couldn't set this field ""
00:00:00 - 00:36:15 - ERROR:102 - We couldn't set this field "<"

And also:
00:00:00 - 00:37:01 - ERROR:504 - We couldn't save a record

I've double checked the Integration steps and they seem fine but I can't find the 'extra' fields on the Host that are causing the 102 errors. Is it possible to search for "KeySeals" "<" and " " ?

I tried hovering over the 504 error for the tooltip as suggested at http://www.seedcode.com/pmwiki/pmwiki.p ... singErrors but that doesn't show anything at all.

Any suggestions on how to track these errors down would be really appreciated, many thanks...
Brian.

Re: Several Different Errors...

PostPosted: Sat Jun 15, 2013 8:15 am
by JasonYoung
Hi Brian,

I can give you some details on these error code, but it looks like something in the set-up or field mapping is broken as all those 102 errors are showing "" (Null) for the field name.

111 is invalid field repetition. We use repeating fields for container management, but can't think of what would cause that off the top of my head. If it's not related to the below errors, then we'd need to take a look.

102 is field missing, which makes sense since it thinks the field names in "", seems like thats got to be a custom field mapping issue, so I would double check your set up for that table.

504 is a validation failure because a value that's required to be Unique isn't. Typically UUIDs prevent this from happening. Do you have Unique validation set on any fields that aren't UUIDs?

Other than that we'll probably need to take a peek at you files to see what's happening, so hit Jeff up at [email protected].

Thanks,
-Jason

Re: Several Different Errors...

PostPosted: Sun Jun 16, 2013 10:05 am
by brian.curran
Hi Jason,
Thanks for your input, I discovered that I had two "SyncKeySeals" layouts in the Hosted and Mobile files which were not needed, as I also had the KeySeals fields in a separate layout.

Once I had deleted those extra layouts and the relevant Integration step, the Sync log looked much healthier and the records were intact again.

One thing that does look odd:

00:00:01 - 00:00:46 - Asking the host for changed records: Police - pulling down.
00:00:00 - 00:00:46 - Retrieving the Outbox from Host
00:00:00 - 00:00:46 - Processing 1 of 1 packages recd. (0 records)
00:00:01 - 00:00:47 - Looking for records to delete
00:00:00 - 00:00:47 - Record deletion completed
00:00:00 - 00:00:47 - Processing completed

00:00:00 - 00:00:47 - Asking the host for changed records: Site - pulling down.
00:00:48 - 00:01:35 - Retrieving the Outbox from Host
00:00:00 - 00:01:35 - Processing 1 of 1 packages recd. (0 records)
00:00:00 - 00:01:35 - Looking for records to delete
00:00:00 - 00:01:35 - No records present in "Site" - no deletion required.
00:00:00 - 00:01:35 - Processing completed

Any idea why the bit in red appears?

Thanks
Brian.

Re: Several Different Errors...

PostPosted: Mon Jun 17, 2013 7:15 am
by jeffalmquist
Hi Brian,

That delete step is when GoZync looks for records on the mobile device that either don't "belong" to that mobile user (according to any filters you've set up), or records that don't exist in the hosted solution because they have been deleted in the hosted solution. Looks like neither of those conditions applied in your example.

HTH

Jeff

Re: Several Different Errors...

PostPosted: Mon Jun 17, 2013 10:31 am
by brian.curran
Hi Jeff,
I understand how the delete step should work but the bit in red text is new to me. If you look at the block of text directly above it says "Record deletion completed"

Just wondered why it was different between these two TO's...

Thanks
Brian.

Re: Several Different Errors...

PostPosted: Mon Jun 17, 2013 12:56 pm
by jeffalmquist
Looks like the "Site" table was empty (TotalRecordCount = 0). That's what the "No records present" red text means.

Re: Several Different Errors...

PostPosted: Mon Jun 17, 2013 1:20 pm
by brian.curran
Hmm, just ran it again and got the same result even though there were 3 updated records pulled down:

00:00:00 - 00:01:44 - Asking the host for changed records: Site - pulling down.
00:00:58 - 00:02:42 - Retrieving the Outbox from Host
00:00:02 - 00:02:44 - Processing 1 of 1 packages recd. (3 records)
00:00:00 - 00:02:44 - Looking for records to delete
00:00:00 - 00:02:44 - No records present in "Site" - no deletion required.
00:00:03 - 00:02:47 - Processing completed

Re: Several Different Errors...

PostPosted: Wed Jun 26, 2013 9:02 am
by jeffalmquist
Hi Brian,

I'd be happy to help you troubleshoot a problem you're having with GoZync but I'll have to get copies of your files. You're welcome to send them to me along with a description of the problem you're seeing and how to reproduce it, and what the expected results should be.

Jeff

Re: Several Different Errors...

PostPosted: Wed Jun 26, 2013 12:02 pm
by brian.curran
Hi Jeff,
Thanks for the offer but it seems to have worked itself out somehow...