Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Can't create subscription

Dear colleagues, hi

Could you please help us with one case.

We faced with a problem working on Sybase  RS 12.6 and ASE 12.5.4

I have WarmStabdBy replication but now I want create replication definition and subscription on one table.

In all manual I read what I can do it.

(SyBooks Online)

In manual write

"If the primary database is part of a warm standby application, data_server.database is the name of the logical data server and database."

For replication definition and subscription.


I have logical connection test.DB


My Scripts


create replication definition RD_pSwiftLine12

with primary at test.DB

with all tables named "pSwiftLine11"

(

SPID int,

Number int

)

primary key (  "SPID", "Number")

go

And replication definition created.

But when I create subscription  with the same logical connection test.DB

define subscription SR_pSwiftLine12

for RD_pSwiftLine12

with replicate at test.DB

with suspension

go

I had error

The replicate database 'test.DB' for subscription 'SR_pSwiftLine12' is the

same as the primary database for the replication definition 'RD_pSwiftLine12'.

This is not allowed.

May be somebody know how I make create subscription for WarmStandBy.

Because when I use another name in "with replicate at...." a had error,because all server use in WarmStandBy.

Interesting string with

"with replicate at...."

What write?

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question