Automic Workload Automation

 View Only

Automic mssql DBs with replication - truncate table does not work

  • 1.  Automic mssql DBs with replication - truncate table does not work

    Posted Jan 28, 2022 10:44 AM

    Hello folks,
    we have set up 2 mssql DBs for automic in aws cloud and set up replication from primary to secondary db, so that if primary db goes down Automic works with second one, but when we run reorg jobs, the DB unload for reorg failed with error Status: '42000' Native error: '4711' Msg: 'Cannot truncate table 'DIVDB' because it is published for replication or enabled for Change Data Capture.
    Do you any experience with it? Can you please advise how to run reorg jobs if DB replication is used, if possible.
    Many thanks in advance.