Hi,
I am using ODI 12.2.1.3 and am trying to load the contents of a JSON file into a table in my Oracle DB.
An XSD for my JSON file has been generated by the native format builder, and I have successfully tested and reverse engineered the model.
When I run my mapping ( complex file within a data set to oracle able ), I get the following response
Caused by: oracle.odi.jdbc.driver.xml.io.exception.PipelineStageException: ORABPEL-15235
Translation Failure.
Failed to translate JSON to XML. cannot normalize!
The incoming data does not conform to the NXSD schema. Please correct the problem.
I have googled this error and the general response is to patch with patch p27256663, however this patch has already been applied.
Another solution is regarding the default varchar lengths so within the dataserver configuration I have changed the default values from 255 to 4000 and even 32000. After changing this I dropped the existing XSD and rebuilt with the native format builder, reverse engineered the model again, validated the mapping, and ran it again only to retrieve the same value.
Anyone else have any thoughts?
Christy