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é

asked 15 Dec '10, 14:36

ASchild's gravatar image

ASchild
777222740
accept rate: 14%

edited 15 Dec '10, 16:56


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

permanent link

answered 22 Dec '10, 18:13

Rich%20Jones's gravatar image

Rich Jones
35146
accept rate: 66%

edited 25 Dec '10, 18:43

Volker%20Barth's gravatar image

Volker Barth
39.5k355539810

@Rich: Well, as André has stated to use SA 11, will this be fixed, too?

(23 Dec '10, 11:08) Volker Barth

Yep, I had this in SA 11. Would be nice to have it fixed there also

(23 Dec '10, 18:30) ASchild
drop SYNCHRONIZATION SUBSCRIPTION TO "owner"."Replica1" 

Did what I intended.

It looks like there is a "bug" in sybase central:

  • When you have a sql remote only publication
  • Then you go to the properties of that publication
  • Then on the "Connections" page ("Verbindungen" in german) by default the TCP/IP is choosen (when not mobilink exists)
  • You now change the radio button to https and then back to tcp/ip (Without any changes)

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.

Nasty ;)

permanent link

answered 15 Dec '10, 16:55

ASchild's gravatar image

ASchild
777222740
accept rate: 14%

Weird! I'm really glad I'm used to change all settings only with statements, not GUIs. - But it's good to hear that your PASSTHROUGH changes went through in the end - I guess the ML error message could have caused something like a heart-attack...

(16 Dec '10, 11:47) Volker Barth
1

I'm too long in business to let computers doing that to me, but it did raise my heart-beats ;)

(17 Dec '10, 06:52) ASchild
2

If there was an end-of-year Awards Banquet, this bug would get a prize of some kind.

(23 Dec '10, 08:25) Breck Carter

@Breck: The bug or its fix? :)

(23 Dec '10, 11:09) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×370
×143
×101
×4

question asked: 15 Dec '10, 14:36

question was seen: 7,280 times

last updated: 25 Dec '10, 18:43