My Oracle Support Banner

Error Testing JSON File with Field Larger than 4000 Characters in ODI "The incoming data does not conform to the NXSD schema" (Doc ID 2620254.1)

Last updated on APRIL 10, 2020

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

When testing a JSON complex file datastore in Oracle Data Integrator (ODI) 12.2.1.3.x that contains a field with over 4000 characters in it, the following error is thrown:

java.sql.SQLException: class java.sql.SQLException
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.

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
Cause
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.