HANA Realtime Replication using CDC

[Former Member]

Hi,

We’re trying to use replication tasks in HANA via a RDA to CDC-enabled SQL Server to update physical tables in HANA. We have successfully installed the Data Provisioning Agent and the changes to the data are visible in the virtual tables, but replication is not occurring into the physical tables. We’re fairly sure that we have the DPA set up correctly (as we can see the changes in the virtual tables) and that CDC is running correctly in SQL Server as the CDC tables are populating, but when executing the replication task with replication behaviour in realtime, not only do we not see replication into the physical tables, it seems to be stopping CDC and appears to delete the CDC tables in SQL Server! Upon checking the repagent.log file the following error occurs:

I. 2017/02/01 00:53:54.781 INFORMATION com.sybase.ra.ltm.LTM Replication Agent changed to <ADMIN> state.
I. 2017/02/01 00:53:54.781 INFORMATION com.sybase.ra.lr.mssql.RAMLogReader Transaction LogReader is starting the <T_LRINIT> Thread.
W. 2017/02/01 00:53:54.828 WARNING com.sybase.ra.lr.mssql.RAMLogReader The Replication Agent DDL user is not configured. Therefore, the dsi_replication_ddl configuration in Replication Server must be enabled for DDL replication to succeed.
I. 2017/02/01 00:53:54.828 INFORMATION com.sybase.ra.lr.mssql.RAMLogReader Transaction LogReader is starting the <T_LRSENDER> Thread.
I. 2017/02/01 00:53:54.844 INFORMATION com.sybase.ra.lr.mssql.RAMLogReader Transaction LogReader is starting the <T_TRANREADER> Thread.
I. 2017/02/01 00:53:54.860 INFORMATION com.sybase.ra.lr.mssql.RAMLogReader Transaction LogReader is Replicating logged Transactions.
I. 2017/02/01 00:53:54.860 INFORMATION com.sybase.ra.lr.mssql.RAMLogReader Transaction LogReader Internal Thread <T_LRINIT> Exited.
T. 2017/02/01 00:53:54.969 Device com.sybase.ds.mssql.device.Device Opening device at <D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SON_DB_REPL_log.ldf>.
E. 2017/02/01 00:53:54.985 ERROR com.sybase.ds.mssql.log.device.LogDevice The log file <D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SON_DB_REPL_log.ldf> is being locked by SQL Server process.
E. 2017/02/01 00:53:54.985 ERROR com.sybase.ds.mssql.log.device.LogDevice Use sybfilter driver to break the lock first.
E. 2017/02/01 00:53:54.985 ERROR com.sybase.ds.mssql.log.device.LogDeviceConta Failed to synchroniz log device with message com.sybase.ds.mssql.device.FileLockedException.
E. 2017/02/01 00:53:54.985 ERROR com.sybase.ds.mssql.log.device.LogDeviceConta Failed to synchroniz log device with message com.sybase.ds.mssql.log.device.SyncDeviceException.
E. 2017/02/01 00:53:54.985 ERROR com.sybase.ds.mssql.log.MSSqlLogReader com.sybase.ds.mssql.log.device.SyncDeviceException

Has anyone come across this problem before or know of a solution?