"You can't specify target table 'SNP_SESSION' for update in FROM clause" Error Is Received when Attempting to Purge the Log and the ODI Work Repository Is on MySql Technology (Doc ID 2995509.1)

Last updated on DECEMBER 28, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.4.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

The following error is received when attempting to purge the Oracle Data Integrator (ODI) 12.2.1.4 Session Log, and the Work Repository is on MySql technology:

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!

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

"You can't specify target table 'SNP_SESSION' for update in FROM clause" Error Is Received when Attempting to Purge the Log and the ODI Work Repository Is on MySql Technology (Doc ID 2995509.1)

Applies to:

Symptoms

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!