Error: Transaction rolled back because it has been marked as rollback only
Issue:
While executing a new request we see that, the request stays in a NEW state, even though the agent is running & no other request is executing.
This happens when we use the same credential/Credential pool for multiple configuration parameters & we get the below error:
Automation Logs:
http-nio-8081-exec-5 INFO : - Putting the message with instance id <> in JMS Queue
2022-03-09 03:04:25 CST (-06:00) http-nio-8081-exec-5 ERROR AEBaseRestController:145 - Exception:
org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback
Agent Logs:
com.automationedge.aeagent.exceptions.AEAgentException: Unknown error at server side
at com.automationedge.aeagent.util.AEServerUtil.pollForWorkflows(AEServerUtil.java:1485
How to reproduce:
To reproduce this issue you can use single credentials in multiple configuration parameters.
Resolution:
To resolve this issue we need to use a unique or one credential/credential pool per parameter.