IDM server filling up disk with logs due to looping task? cancelling task/events in DB didn't help
book
Article ID: 115547
calendar_today
Updated On:
Products
CA Identity ManagerCA Identity GovernanceCA 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