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

Hello,

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,

Lala

Outcomes