Converting JSON File into XSD Using ODI 12C Fails with " Native Format Builder Error" and "Schema Generation Failed"
(Doc ID 2429985.1)
Last updated on OCTOBER 25, 2021
Applies to:
Oracle Data Integrator - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
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.
The "Native Format Builder: Error" is received with steps like the following using Oracle Data integrator (ODI) 12c:
- Start ODI Studio, and connect to the Repositories.
- Navigate to Topology > Complex File. Right click to create new Data Server.
- Navigate to the JDBC string and select Edit nXSD.
- Choose JSON interchange format.
- Enter the following:
File name: example.json
Target Namespace: http://<TargetNameSpace_HOSTNAME>/InboundService
Root_element: Root-Element
Character set: US-ASCII
- Click Ok and the error is received.
Error Stack:
[2018-06-27T08:24:46.475-07:00] [tip] [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. The number of characters read: 3149824 exceeds the maximum threshold: 3145728
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:108)
at oracle.tip.tools.ide.nxsd.FlatFileSampleJSONDescriptionPanel.generateNXSD(FlatFileSampleJSONDescriptionPanel.java:839)
at oracle.tip.tools.ide.nxsd.FlatFileSampleJSONDescriptionPanel.validate(FlatFileSampleJSONDescriptionPanel.java:558)
at oracle.tip.tools.ide.nxsd.FlatFileWizard.wizardValidatePage(FlatFileWizard.java:774)
at oracle.bali.ewt.wizard.WizardPage.processWizardValidateEvent(WizardPage.java:710)
at oracle.bali.ewt.wizard.WizardPage.validatePage(WizardPage.java:680)
at oracle.bali.ewt.wizard.BaseWizard.validateSelectedPage(BaseWizard.java:2414)
at oracle.bali.ewt.wizard.BaseWizard._validatePage(BaseWizard.java:3162)
at oracle.bali.ewt.wizard.BaseWizard.doNext(BaseWizard.java:2187)
at oracle.bali.ewt.wizard.dWizard.DWizard.doNext(DWizard.java:405)
at oracle.bali.ewt.wizard.BaseWizard$Action$1.run(BaseWizard.java:4072)
Caused by: java.io.IOException: The number of characters read: 3149824 exceeds the maximum threshold: 3145728
at oracle.tip.pc.services.translation.util.IOUtils.readAllData(IOUtils.java:154)
at oracle.tip.pc.services.translation.util.IOUtils.validateInputSize(IOUtils.java:177)
at oracle.tip.pc.services.translation.tools.datasampler.JsonDataSampler.generateSchemaFromSample(JsonDataSampler.java:78)
... 77 more
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |