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:

passthrough for subscription to owner.Replica1;

ALTER TABLE Catalogues
MODIFY ActiveInProposal DEFAULT (1)
;

ALTER TABLE Catalogues
ADD ThumbnailFilename CHAR (100 )  NULL
;

ALTER TABLE Catalogues
ADD ThumbnailMimeType CHAR (30 )  NULL
;

passthrough stop;

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

select * from sys.syssync

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é