My Oracle Support Banner

Replicat To SAP HANA Abending With Database Error 301 () (Doc ID 2472329.1)

Last updated on DECEMBER 03, 2018

Applies to:

Oracle GoldenGate Application Adapters - Version 12.3 and later
Information 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://bnlphanasa.labcorp.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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.