we try to add some new columns to two existing tables, which are involved in a sql remote replication. For this we usually use the passthrough command.
That used to work fine just a few weeks ago. Now the command fails with this error:
"Command could not be executed. Table OurTable is part of a sychronization definition" SQLCode = -819, ODBC state = "42502"
it has to do with some mobilink definitions. But in that database we just don't have any mobilink definitions.
If we however make a
We receive this row:
sync_id;type;publication_id;progress;site_name;option;server_connect;server_conn_type;last_download_time;last_upload_time;created;log_sent;generation_number;extended_state 1;'D';1;;;;;'TCPIP';;'1900-01-01 00:00:00.000';;;0;''
And looking at sys.publication we see:
creator;publication_name;remarks;type;sync_type 'owner';'Replica1';'Full replica for server in Site 1';'R';'logscan'
In sybase central I don't see any mobilink users/defintions/publications.... So how can I get past this error. (I'm a bit scared by the "drop publication" command, especially since I don't know what name I should put in there...
This has been identified as a bug in the server, and has been fixed for versions 12.x. The bug number is 652759. The bug description is as follows:
If a table was included in a publication and one or more MobiLink options were defined for that publication but there were no synchronization subscriptions defined, the table could not be ALTERed to, for example, add a new column. This has been fixed.
Rich Jones iAnywhere Engineering
Did what I intended.
It looks like there is a "bug" in sybase central:
When you now do a "Apply" it creates you a mobilink tcpip definition in the database. In the gui you don't see if it's "undefined" or if a tcpip defintion exists.
answered 15 Dec '10, 16:55