October 2, 201411 yr I'm getting a sporadic error 504 (not unique value) for the primary key in my main connecting table. The record is therefore corrupted and unusable on sync. I cannot find any trigger for this behaviour to start, it will correctly sync a number of records then without warning fail. I have managed to recover from this on a Pro client, but on an iPad this seemed fatal, and refused to sync correctly ever again. I am using UUIDs and have checked for uniqueness . The rest of the tables and primary keys copy fine.
Create an account or sign in to comment