My Oracle Support Banner

Update Integration Flow Is Not Working When Using A WHERE Clause In The PureSQL. It Fails With ORABPEL-15236, Failed To Translate XML To JSON. Cannot Write End Element: pollingInterval, The Data Does Not Conform To The NXSD Schema (Doc ID 2388881.1)

Last updated on JUNE 13, 2019

Applies to:

Oracle Integration - Version 17.4.1 and later
Information in this document applies to any platform.

Symptoms

This knowledge article reflects updated product names. Oracle Integration Classic (OIC-C) was formerly known as Oracle Integration Cloud (OIC). Please see KM for the full list of recently renamed PaaS services.

OIC-C Connectivity Agent is being used to perform an update on a database table called Fusion_Data.

This is done using a PureSQL statement with a WHERE clause, but the update does not work and the below errors are seen in the logs:

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
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.