MSA : DDL 'The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'repcheck' database.

[Former Member]

to i just setup  MSA replication ..

1) Database  Replication definition

create database replication definition repdef_repcheck

with primary at DS_CTO.repcheck

2) subscription .

create subscription sub_repcheck

for database replication definition repdef_repcheck

with primary at DS_CTO.repcheck

with replicate at DS_STANDBY.repcheck

without materialization

subscribe to truncate table

>>>> Replication working fine  but it was not replication DDL ...

3) Alter replication definition

alter database replication definition repdef_repcheck

with primary at DS_CTO.repcheck

replicate DDL

Now getting error :

     Message from server: Message: 2762, State 3, Severity 16 -- 'The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'repcheck' database.

'.

Do i need to do something on connection level ..

Thanks for your help ...

Thanks

Ajay Pandey

[Former Member]

Looks it is working now ...

I did two thing not sure which one resolved ..

1) start and stop rep agent 

2) truncated rs_lastcommit from target ...

[Former Member]

send warm standby xacts = true  i did as part of MSA setup .

look like  truncate of rs_lastcommit  and stop /start rep agent  helped .. not sure which helped..

But now working ..

Mark : Do you have manual step to setup MSA (start to end) . I had those steps long back but lost .

Current steup : i used rs_init  for connections/repagent .  and manual sp_reptostandby/send warm standby xacts /repdef/subscription ..

One more Help as in Rep 15.6 onward  to Sync Replication database in warm standby :

A) Warm standby -- No need to drop and create connection etc for Sync

New option work very well ( 1 . stop repagent 2) suspend dsi connection 3)resume dsi with dsync marker 4)stop repegent with resync 5) dump/load 6) resume connection .

SyBooks Online

B) MSA -- database level --  Do we have anything like warmstandy as above or we need to drop subscription and create with dump marker ..

i was thing might be there is some thing new to avoid drop subscription etc  like in warmstandby no need to drop connection in 15.6 onward . ...

[Former Member]

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32518.1571/doc/html/jer12... Seems same work for warstandby and MSA both ...