Hello, 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. Like:
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" According to this posting http://groups.google.com/group/sybase.public.sqlanywhere.replication/browse_thread/thread/ddc0b7201c6f8aeb 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... André |
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 @Rich: Well, as André has stated to use SA 11, will this be fixed, too? Yep, I had this in SA 11. Would be nice to have it fixed there also |