I am running SQL Anywhere and MobiLink 188.8.131.528 and I run into the following issue:
I created a Synchronisation Model with multiple tables. In one of these tables I need the column which contains the last_modified timestamp in the remote db.
When I do "Create New Table Mappings", I add the column to my table mapping, however when I am in the Mappings tab of the tool, I see it only on the consolidated side. It is not available on the right in the remote.
The column was named TIMESTAMP. When I changed it to "last_modified", it was not available either. But after changing it to "TEST", I was able to do the mapping.
Any idea what I am doing wrong?
Thanks for your help and best regards, Alex
asked 14 Oct '15, 11:04
The behavior you are fighting is actually by design.
This is because you are using timestamp based downloads and that column has a special purpose in this model. In this model, the column is not about datum but about tracking and control for MobiLink purposes (only) and is expected to only live at the consolidated.
You could consider modifying the download type for just this one table (only), from timestamp to custom, and design your download_cursor and download_delete_cursor scripts just for this one table. The plug-in will remove the generated ones but you could (first) copy those and base your design on those. All columns should be available now that you are not using timestamp based downloads for this object.
Part of the problem is you are attempting to provide a column that is required for the MobiLink server scripts to function and normally should not be part of the remote schema. The Synchronizaton Model wizard will preserve this special status and will never allow it to be put into the remote schema (for the timestamp based download model that is).
Even before we had this modelling feature in the MobiLink plug-in I have strongly advised against having that column serve multiple purposes (which is usually what happens when you design to include it this way). Maybe an extra timestamp-type column may be a better choice?