'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 10.1.3.2.0 to 10.1.3.5.4Information in this document applies to any platform.
Symptoms
When attempting to kill an ODI Session from ODI Operator with a right kill > Stop on the Session record, the following message is signaled :
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -408, SQLSTATE: A value is not compatible with the data type of its assignment target. Targetname is "<name>"
42821, SQLERRMC: I_TXT_STEP_MESS
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.
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 |