Hi,
I'm encountering some problems with replicating values from Oracle to Sybase when the Sybase column is an identity. The map statement is simple:
MAP DB70.TBL_A, TARGET dbo.TBL_A, KEYCOLS (ID);
The replicat Abends with
OGG-00868 Failed to get results while IDENTITY_INSERT On for table dbo."TBL_A".
Has anyone seen this before? I didn't find much related information on MOS, and OGG-00868 is a generic error number.
To work around this, I just specified all columns except for the ID in the KEYCOLS clause. I realize this is not the optimal solution.
Other relevant background...
The ID field is used mainly for helping Sybase RSE replication. The identity field is the unique identifier, and this helps with replication performance. We are migrating this data (and applications) from Sybase to Oracle. We are replicating back to Sybase for 1) the fallback plan, and 2) for some consumers of the data, so we don't need all applications deployed at the same time. We will only need to support this for roughly 2 weeks, then it will be stopped.
I believe there will be more of these (replicating to identity columns) in my future, so I do want some solution.
Thank you,
Kevin