OAC: Special Characters (Double Quote And Forward Slash) loading With NULL Values In Data Sync
(Doc ID 2519288.1)
Last updated on MARCH 10, 2021
Applies to:Oracle Analytics Cloud - Classic - Version N/A and later
Information in this document applies to any platform.
On Oracle Analytics Cloud - Classic: Data Sync 2.5
OAC Data Sync “special character” (Double quote and Forward slash) are loading with NULL values.
Due to this Null values the load fails with "ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found."
Source system have these characters '/'," ", then in target DB table these values are loaded as null in LOOKUPCODE columns (which is a primary key column).
ERROR from Data sync log
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
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