IDM server filling up disk with logs due to looping task? cancelling task/events in DB didn't help

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

Identity Manager Weblogic server .out file fills rapidly up With these
WARN  [ims.tmt.eventlistener] Evt IMTaskEvent:xy123456-a1bbdibzz-53963cc0-k34646h is invalid.>
ERROR [ims.tmt.persistence] PersistenceProvider: JMS:ID:<654267.1537041497105.0>: fetchObjectsByIds: tried '3' times, exception getting objects by ids: [cdb6fcd8-53e93296-398168d1-a0a4bf0e, cdb6fcd8-53e93296-01b19d56-823b4553, cdb6fcd8-53e93296-1e1daf8b-6f5200fa, cdb6fcd8-53e93296-35847768-2e3e9f71, cdb6fcd8-53e93296-077146e9-8debbbc9, ..........
...........cdb6fccc-53e93296-3bc841ad-3557d521]: ORA-01795: maximum number of expressions in a list is 1000>
ERROR [ims.tmt.IMSMessageListener] processToEndState: Exception occured during event processing
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

Despite running a query on the DB to reset the state of this task and cancel it, the error is still seen
We have tried to run the following query
update imdb.tasksession12_5 set state=256 where tasksessionid='xy123456-a1bbdibzz-53963cc0-k34646h';
update imdb.event12_5 set state=256 where tasksessionid='xy123456-a1bbdibzz-53963cc0-k34646h' and state not in (128);

Environment

Identity Manager 14.x - Weblogic Application Server 12.1.3

Resolution

We had to remove the specific message from the JMS queue by accessing the Weblogic Management console

1. Pause the consumer: Services->Messaging->JMS Servers->JMSServer-select the IDM server specific JMS Server,
Go under control and then click on Consumption and then pause.
2. Delete the pending messages Services->Messaging->JMS Modules->iam_im imJMSModule->Monitoring->iam_im imJMSModule!JMSServer-x@iam_im IMS Events Click on Show Messages and delete the particular JMS ID.
3. Resume the consumer: Services->Messaging->JMS Servers->JMSServer-select the IDM server specific JMS Server.
Go under control and then click on Consumption and then resume

Additional Information

https://docs.oracle.com/cd/E80149_01/wls/WLACH/taskhelp/jms_modules/queues/ManageQueues.html