My Oracle Support Banner

JSON File to Oracle Database Using ODI 12c Fails with Native Format Builder Error (Doc ID 2429985.1)

Last updated on AUGUST 09, 2018

Applies to:

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

Symptoms

"Native Format Builder: Error" is received when performing the following JSON (complex file) to Oracle Database steps using Oracle Data integrator (ODI) 12c:

  1. Start ODI Studio, and connect to the Repositories.
       
  2. Navigate to Topology > Complex File. Right click to create new Data Server.
     
  3. Navigate to the JDBC string and select Edit nXSD.
       
  4. Choose JSON interchange format.
      
  5. Enter the following:

       File name: example.json
       Target Namespace: <http://TargetNameSpace.com/InboundService>
       Root_element: Root-Element
       Character set: US-ASCII
      
  6. 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: 16] [ecid: 0****************1,0] 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!


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