My Oracle Support Banner

"No more data to read from socket" while Truncating / Refreshing a JSON Schema (Doc ID 2492260.1)

Last updated on MARCH 21, 2023

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Symptoms

A Complex File Data Server was configured in Oracle Data Integrator (ODI) for a JSON file using ODI 12c. For example:

 

In the properties tab of the Complex File Data Server, an external storage was defined:

Testing the connection for data server is successful, tables are created in the external DB schema:

But when running an ODI procedure to truncate or refresh the JSON schema using J2EE Agents located on the same machine as the JSON file, the below error occurs.

The error can be bypassed by creating a new JSON Schema in the ODI topology and then schema refresh job will run fine. But after a while it fails again with the same error.

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!

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