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 laterInformation in this document applies to any platform.
Symptoms
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
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |