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 and later
Information in this document applies to any platform.


"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: <>
       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] [] [] [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.bali.ewt.wizard.WizardPage.processWizardValidateEvent(
  at oracle.bali.ewt.wizard.WizardPage.validatePage(
  at oracle.bali.ewt.wizard.BaseWizard.validateSelectedPage(
  at oracle.bali.ewt.wizard.BaseWizard._validatePage(
  at oracle.bali.ewt.wizard.BaseWizard.doNext(
  at oracle.bali.ewt.wizard.dWizard.DWizard.doNext(
  at oracle.bali.ewt.wizard.BaseWizard$Action$

Caused by: The number of characters read: 3149824 exceeds the maximum threshold: 3145728
  ... 77 more




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.