When we try to run a process it's either Waiting or Failing. In logs we see:
SQL error code: 1461
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01461: can bind a LONG value only for insert into a LONG column
INSERT INTO NMS_MESSAGES (
ID, TOPIC, MESSAGE_CODE, OBJECT_ID, OBJECT_CODE, USER_ID,
MESSAGE_TYPE_CODE, MESSAGE, SEND_DATE, EXPIRATION_DATE,
CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY)
VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
NMS_MESSAGES has a corrupted value. Please ask the DBA to run:
truncate table NMS_MESSAGES
Then restart your BG service and try again.
If this does not help, that means the message gets recreated by a process.
1. Abort all processes with status Error
2. Run Delete Process Instance job for Aborted instances
Restart is not required.