MSSQL to Oracle Replication using SAP Rep Server 16

[former_member246062]

Hello All,

When trying to resume the Rep Agent , receiving the following error . Sybfilter driver is running and the log files are readable.

E.2018/07/06 17:13:40.802  ERROR          com.sybase.ds.mssql.log.device.LogDeviceContaVirtual file can not be found according to the specified virtual file sequence number.
I.2018/07/06 17:13:41.278  INFORMATION    com.sybase.ra.ltm.LTM                        Replication Agent changed to <REPLICATING> state.
E.2018/07/06 17:13:41.340  ERROR          com.sybase.ra.lr.mssql.RAMTranReader         Error occurred scanning log at position [GENID=0000][VIRTUALFILESEQNO=00027dcc][PAGEID=000001bf][OPERATIONSEQNO=0008][UNIQUE=00000401][OATVIRTUALFILESEQNO=00027dcc][OATPAGEID=000001bf][OATOPERATIONSEQNO=0006][LCTPAGEID=00003724][LCTOPERATIONSEQNO=001c].
E.2018/07/06 17:13:41.340  ERROR          com.sybase.ra.lr.mssql.RAMTranReader         java.lang.RuntimeException: Error occurred scanning log at position [GENID=0000][VIRTUALFILESEQNO=00027dcc][PAGEID=000001bf][OPERATIONSEQNO=0008][UNIQUE=00000401][OATVIRTUALFILESEQNO=00027dcc][OATPAGEID=000001bf][OATOPERATIONSEQNO=0006][LCTPAGEID=00003724][LCTOPERATIONSEQNO=001c].

[former_member246062 · Accepted solution]

For few instances, we have to do deinit & initialize again.

[kenneth_brozovich]

Has the RepAgent been down for a period of time? It appears the log file it is trying to read is no longer available. You can reset replication to the current log:

Login to RepAgent:

suspend

go

ra_locator move_truncpt

go

ra_admin refresh

go

Login in to RSSD:

rs_zeroltm dataserver,database

go

Login to RepAgent:

resume

go

[former_member246062]

Thanks. Done that and started the replication.