TransWikia.com

Problem creating subscriptions on Replication Server version 15.7.1

Database Administrators Asked by Tittus on February 15, 2021

if anyone knows what is the error? Can not use active or standby connection names for subscriptions
I got this error when I’m trying to create my subscriptions. I have already created a repdef WITH PRIMARY AT pb1.customer and when I tried to run my subscription, WITH REPLICATE AT pb2.customer. It is showing the error. I have also created a logical connection pb1.customer for dump/load db.

pb1 and pb2 are both ASE, ASE15.5 and ASE15.7 respectively.

Please advise.

One Answer

The error message indicates you're using a WarmStandby (WS) setup, in which case there are no subscriptions required (nor supported), period.

If you're trying to use the WS pair as a source for replicating into a 3rd db, then the repdef will need to reference the WS logical pair as the primary db.

If you're trying to replicate into the WS pair from a 3rd db, then the subscription will reference the WS logical pair as the replicate db.

Answered by markp-fuso on February 15, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP