Page 1 of 1
child records missing in relational sync
Posted:
Wed Aug 21, 2013 2:19 pm
by darrenburgess
I am having an issue pulling down related child records when a new parent record is created.
This is what I am doing:
1. Create new parent record
2. Create child records (three different tables, all related by the parent table ID
3. Zync
4. Parent record makes it over but only one table of child records is pulled down.
Note:
1. these child records will pull if the record is not new
2. Child records will pull if I reset from GoZyncMobile
3. The parent records have a search filter. If I change the parent record so it is excluded, then sync will remove it. If I change the record back, so not filtered out anymore, then parent will sync, but child records do not.
Re: child records missing in relational sync
Posted:
Wed Aug 21, 2013 7:04 pm
by darrenburgess
More information. I did this:
1. deleted all records in mobile
2. Reset GZM
3. Synced (all child records made it through the pull)
4. Updated the parent event record on the hosted desktop file
5. Synced
6. Assignment records were DELETED.
Log is below. I started think this was an issue with fields, like perhaps a calc field, or maybe an autoenter. Or lack of field parity between gzh and gzm layouts. I can't find it tho.
---------------------------------------------------------
0:00:00 - 0:00:02 - STARTING EVENT ROUND TRIP
0:00:00 - 0:00:02 - Starting Push
0:00:00 - 0:00:02 - Starting to Push "gzm_Event"
0:00:00 - 0:00:02 - FLM is OFF
0:00:00 - 0:00:02 - Found 0 records to push
0:00:00 - 0:00:02 - Done Pushing "gzm_Event"
0:00:00 - 0:00:02 - Push Complete
0:00:00 - 0:00:02 - Starting Pull
0:00:00 - 0:00:02 - Starting to Pull "gzh_Event"
0:00:00 - 0:00:02 - Last Time Zync: "8/21/2013 10:35:19 PM"
0:00:00 - 0:00:02 - FLM is OFF
0:00:00 - 0:00:02 - Starting TO Filter - "gzh_Event"
0:00:00 - 0:00:02 - Found 22 Records in the filter
0:00:00 - 0:00:02 - Looking for record to Delete
0:00:00 - 0:00:02 - no records to delete in "gzm_Event"
0:00:01 - 0:00:03 - no records to delete in "gzm_EventCall"
0:00:00 - 0:00:03 - no records to delete in "gzm_CrewCall"
0:00:00 - 0:00:03 - Deleting 5 records from "gzm_Assignment"
0:00:00 - 0:00:03 - Deletion Complete
0:00:00 - 0:00:03 - Constraining filter records by last time zync
0:00:00 - 0:00:03 - Found 1 records that have changed since last zync
0:00:00 - 0:00:03 - Starting sync on 1 records.
0:00:00 - 0:00:03 - Sync complete!
0:00:00 - 0:00:03 - Done Pulling "gzh_Event"
0:00:00 - 0:00:03 - Pull Complete
0:00:00 - 0:00:03 - ENDING EVENT ROUND TRIP
---------------------------------------------------------
Re: child records missing in relational sync
Posted:
Wed Aug 28, 2013 5:51 pm
by jeffalmquist
Hi Darren. Thanks for letting us know about this; it's a bug. The problem will be fixed in GoZync version 4.052, which will be released this week, along with instructions for customers to apply the updates in their files.