Comments on: GOLDENGATE https://dbaclass.com/goldengate/ database administration Tue, 16 May 2023 08:43:37 +0000 hourly 1 https://wordpress.org/?v=6.5.5 By: Reza https://dbaclass.com/goldengate/#comment-200607 Tue, 16 May 2023 08:43:37 +0000 http://dbaclass.com/?page_id=1576#comment-200607 Hello, Could you please guide me with a problem?
I got this error in SQL Server to Oracle replication:

WARNING OGG-30080 Oracle GoldenGate Capture for SQL Server, EXTEJR.prm: Error in KEYCOLS clause, key does not exist or key cannot be determined.
ERROR OGG-00919 Oracle GoldenGate Capture for SQL Server, EXTEJR.prm: Error in KEYCOLS clause.

The warning indicates a column name, after I remove the column from the extract file, the process run successfully, but with the presence of that column, the process abended.
The column name is exactly identical to the SQL Server table. GoldenGate version is 19c.

]]>