Sybase heterogeneous Replication MSSQL to Oracle - Data Mismatch

[former_member246062]

Hello ,

Using SRS - heterogeneous server having MSSQL as source & Oracle as target. Using Sybase replication 16.0 & custom function string for the replication. There are few transactions getting missed out to transact to target.

Please suggest if any similar issues reported other environments & probable cause. Since we have no clue why is it getting missed out.

[former_member89972]

You will need find a pattern (time of the day, tables, databases, source users, ...) to catch the missing TXNs.

If you have enough disk space for RS error log, enable the traces and rotate the errorlog by day to keep its size managebale.

With that SAP Support folks should be able to say if its bug or some set-up miss.

HTH

Avinash