Good morning,

I am running SQL Anywhere 16 with MobiLink 16.0.0.2014 and I run into the following problem:

One of my tables is breaking the sync, when I try to send an update from the client to the consolidated database:

E. 2014-11-23 15:26:00. <1> [-10233] Table 'ZODB_CUSTOMERS_PARTNERS' does not have a column named 'TIMESTAMP'
E. 2014-11-23 15:26:00. <1> [-10058] Unable to open upload_update

When I check Sybase Central/MobiLink and switch to the Events tab, I see the following for the upload_update:

​ZODB_CUSTOMERS_PARTNERS (DBA): upload_update​
/* Update the row in the consolidated database. */

UPDATE "DBA"."ZODB_CUSTOMERS_PARTNERS"
SET "UPDKZ" = {ml r."UPDKZ"},
    "LASTNAME" = {ml r."LASTNAME"},
    "FIRSTNAME" = {ml r."FIRSTNAME"},
    "FUNCTION" = {ml r."FUNCTION"},
    "EMAIL" = {ml r."EMAIL"},
    "PHONE" = {ml r."PHONE"},
    "MOBILE" = {ml r."MOBILE"}
WHERE "SMSUSER" = {ml r."SMSUSER"}
    AND "EKUNNR" = {ml r."EKUNNR"}
    AND "EKUNPNR" = {ml r."EKUNPNR"}

However, when I look at the mlsrv.log, I see the following statement (difference in bold):

I. 2014-11-23 15:26:00. <1> upload_update ZODB_CUSTOMERS_PARTNERS

                /* Update the row in the consolidated database. */

                UPDATE "DBA"."ZODB_CUSTOMERS_PARTNERS"
                SET "UPDKZ" = {ml r."UPDKZ"},
                    "LASTNAME" = {ml r."LASTNAME"},
                    "FIRSTNAME" = {ml r."FIRSTNAME"},
                    "FUNCTION" = {ml r."FUNCTION"},
                    "EMAIL" = {ml r."EMAIL"},
                    "PHONE" = {ml r."PHONE"},
                    "MOBILE" = {ml r."MOBILE"}
                WHERE "SMSUSER" = {ml r."SMSUSER"}
                    AND "EKUNNR" = {ml r."EKUNNR"}
                    AND "EKUNPNR" = {ml r."EKUNPNR"}
                    AND {ml r."TIMESTAMP"} > "TIMESTAMP"

I do not have the TIMESTAMP column on the remote, only on the consolidated. Therefore {ml r."TIMESTAMP"} is leading to an error.

Is this working as designed? Or did I do something wrong?

Thanks for your help, Alex