UUID ODBC comparison fail

[outwork]

Hi there,

i have a filemaker database that runs on a filemaker server 13 with a connection to a mysql db trough ODBC.

it always worked fine, but recently certain records won't synchronise ( read : import ) because there is a problem with the UUID.

in  the MYSQL db the UUID  exists and in the local file also. but when i try to update the records in the mysql db certain records return an error.

when i chance only the uuid of that record, with an other valid uuid, it works fine.

a new relation between the filemaker and Mysql db , based on the UUID returns the expected result

Any comments or experience ?

Regards Ivan

[Wim Decorte]

in  the MYSQL db the UUID  exists and in the local file also. but when i try to update the records in the mysql db certain records return an error.

 

What error do you get?  The error number is going to be the biggest clue.​

 

 

[outwork]

The only message i get is the general "729" filemaker error.  other log files on the odbc side won't bring further info