"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 to [Release 12c]
Information in this document applies to any platform.


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




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 hundreds of Community platforms