ORA-01461 while performing INSERT INTO WORK_ITEM
(Doc ID 2596723.1)
Last updated on JANUARY 08, 2024
Applies to:
Oracle Business Process Management Suite - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.1.3.0 version, Orchestration Engine
When attempting to create an instance with a very long comment, the following error occurs.
ERROR
-----------------------
<[ACTIVE] ExecuteThread: '<tid>' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <[severity-value: 32] [rid: 1:<number>] [partition-id: 0] [partition-name: DOMAIN] > < Internal Exception: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
Error Code: 1461
Call: INSERT INTO WORK_ITEM (CIKEY, COUNT_ID, SCOPE_ID, NODE_ID, CLUSTER_NODE_ID, CLUSTER_NODE_KEY, COMMENTS, CREATION_DATE, CREATOR, CUSTOM_ID, DELAY, EXECUTION_TYPE, EXP_DATE, EXP_FLAG, EXT_INT1, EXT_STRING1, EXT_STRING2, FIRST_DELAY, IDEMPOTENT_FLAG, LABEL, MODIFIER, MODIFY_DATE, CI_PARTITION_DATE, PRIORITY, REFERENCE_ID, STATE, TRANSITION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
-----------------------
<[ACTIVE] ExecuteThread: '<tid>' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <[severity-value: 32] [rid: 1:<number>] [partition-id: 0] [partition-name: DOMAIN] > < Internal Exception: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
Error Code: 1461
Call: INSERT INTO WORK_ITEM (CIKEY, COUNT_ID, SCOPE_ID, NODE_ID, CLUSTER_NODE_ID, CLUSTER_NODE_KEY, COMMENTS, CREATION_DATE, CREATOR, CUSTOM_ID, DELAY, EXECUTION_TYPE, EXP_DATE, EXP_FLAG, EXT_INT1, EXT_STRING1, EXT_STRING2, FIRST_DELAY, IDEMPOTENT_FLAG, LABEL, MODIFIER, MODIFY_DATE, CI_PARTITION_DATE, PRIORITY, REFERENCE_ID, STATE, TRANSITION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
...
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 |