My Oracle Support Banner

Delta processing errors with SQLException:java.sql.SQLException: INVALID_DELTA_QUERY (Doc ID 2921747.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate Veridata - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

The following errors are captured at the source agent when running a delta job that compares mysql table to another mysql table.
[2022-11-03T17:23:47.545-04:00] [veridata] [ERROR] [] [oracle.veridata.agent] [tid: 93] [ecid: c5aff70a-45fd-4fd3-be64-f4f90950cc30-000007b6,0:1:1:3:1] SQLException:java.sql.SQLException: INVALID_DELTA_QUERY

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.