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 FEBRUARY 03, 2019

Applies to:

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

Symptoms

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