My Oracle Support Banner

"Native Format Builder: Error" with a Blank Error Is Displayed when Generating XSD for a JSON File (Doc ID 2706000.1)

Last updated on APRIL 11, 2023

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version 2.0.2 and later
Data Integration Platform Cloud - Version 18.4.3 and later
Data Integration Platform Cloud Classic - Version 18.4.3 and later
Information in this document applies to any platform.


Error is received when generating XSD schema for a JSON (complex file):



NOTE: In the images and/or examples, user details/company name/address/email/ telephone number all represent a fictitious sample from the Oracle Demo Vision Database. Any similarity to actual companies or actual persons, living or dead, is purely coincidental and is in no way intentional on the part of Oracle.


To reproduce:

  1. Login to ODI Studio
  2. Navigate to Topology > Complex File. Right click to create new Data Server.
  3. Navigate to the JDBC string and select Edit nXSD.
  4. Select JSON interchange format.
  5. Point the "File name" to a json file that has either null values or empty strings as seen above:
  6. Click Ok and observe the error.




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.