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 OCTOBER 04, 2022

Applies to:

Oracle Data Integrator - Version 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!

In this Document

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