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:

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