Processes are not running in the environment, NMS_MESSAGES error

Products

• Clarity PPM SaaS

Issue/Introduction

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

Executed:

 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 ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 

Environment

Release:

Component:

Resolution

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.