"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 NOVEMBER 01, 2023
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 attempting 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: <TID>] [ecid: <ECID>] 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) ..............................
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 |