My Oracle Support Banner

'A value is not compatible with the data type' Signaled When Attempting To Interrupt an ODI Session From ODI Operator (Doc ID 977915.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version to
Information in this document applies to any platform.


When attempting to kill an ODI Session from ODI Operator with a right kill > Stop on the Session record, the following message is signaled : DB2 SQL error: SQLCODE: -408, SQLSTATE: A value is not compatible with the data type of its assignment target. Targetname is "<name>"

However, the concurrent ODI Agent trace file indicates no particular problem and once the message is accepted by the engineer and the pop-up window closes, the ODI Session comes back to the stop status with all correct message 'Session stopped' at all Session levels.


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

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