Replicat To SAP HANA Abending With Database Error 301 ()
(Doc ID 2472329.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate Application Adapters - Version 12.3 and laterInformation in this document applies to any platform.
Upon some googling on SAP HANA errors, it seems to be from Unique key violation where the key already exists when the replicat is trying to insert the same key. Not sure of how we got into this situation but all we are trying to do is to convert that duplicate record into an update and to be applied with out discarding it. How this can be achieved?
Goal
2018-11-01 14:27:02 WARNING OGG-00869 org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userExitDataSource' defined in class path resource [oracle/goldengate/datasource/DataSource-context.xml]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [oracle.goldengate.datasource.GGDataSource]: Factory method 'getDataSource' threw exception; nested exception is oracle.goldengate.util.ConfigException: Cannot initialize JDBC connection to target, connectionURL: jdbc:sap://<hostname>.com:30015userName: OGGUSER.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |