My Oracle Support Banner

"Failed to generate a schema from the sample JSON. cannot normalize!" Error when Generating the XSD Schema for a JSON File in ODI (Doc ID 2349659.1)

Last updated on JANUARY 24, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

The following error occurs in Oracle Data Integrator (ODI) when trying to generate the XML Schema Definition (XSD) schema for a JavaScript Object Notation (JSON) file using the Native Format Builder wizard included in the Complex File technology (accessible from tab "JDBC", button "Edit nXSD..."):

[ERROR] [] [oracle.tip.tools.ide.nxsd.FlatFileSampleJSONDescriptionPanel] [tid: 17] [ecid: 0000LwjX_JzFS8__LPT4ie1Ptop_000001,0] ORABPEL-15214[[
Schema generation failed.
Failed to generate a schema from the sample JSON. cannot normalize!
Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.
at oracle.tip.pc.services.translation.tools.datasampler.JsonDataSampler.generateSchemaFromSample(JsonDataSampler.java:198)
at oracle.tip.pc.services.translation.tools.datasampler.JsonDataSampler.generateSchemaFromSample(JsonDataSampler.java:81)
at oracle.tip.tools.ide.nxsd.FlatFileSampleJSONDescriptionPanel.generateNXSD(FlatFileSampleJSONDescriptionPanel.java:839)
at oracle.tip.tools.ide.nxsd.FlatFileSampleJSONDescriptionPanel.validate(FlatFileSampleJSONDescriptionPanel.java:558) ..............................

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!


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