AnsweredAssumed Answered

Multiple DB session :: Creating Deadlock issue

Question asked by lalatendu.bishoyi on Jun 17, 2015
Latest reply on Jun 17, 2015 by lalatendu.bishoyi


I faced an issue on CA PPM 14.2 .


While trying to delete an custom object instance,I am getting the below error.

"ErrorError 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator."


On log file I got the error as:

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00060: deadlock detected while waiting for resource


After I started looking into the issue from DB.

And got that there were two/three session running on Database for delete objectinstance as soon as  I click on the delete button.


But when I execute the same scenario on CA Clarity PPM 13.1 ,on the DB side I got only one session for delete object instance.

On 13.1 the object instnace got deleted successfully.



Has anyone faced the same issue before ?


Best Regards,