My Oracle Support Banner

Converting JSON File into XSD Using ODI Fails with "Schema Generation Failed" Error (Doc ID 2438173.1)

Last updated on FEBRUARY 21, 2019

Applies to:

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


Oracle Data Integrator (ODI) fails to convert a large JSON file to XSD using Complex File Technology:

Schema generation failed. Failed to generate schema from the sample JSON. The number of characters read: 3149824 exceeds the maximum threshold: 3145728.

1. The data is to be loaded into the Oracle Staging table.
2. Once the topology is configured, the JSON response is generated.
3. To read the JSON file, the Complex File Technology is used to convert into XSD using native XSD (nXSD)


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

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