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 NOVEMBER 01, 2021

Applies to:

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

Symptoms

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.

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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