Re: ERROR:: Request is being updated by another database session
Here are some solutions and experienced practices:
This bug is permanently fixed in 8.0 SP3. Either upgrade to 8.0 SP3 or contact HP to get the Hotfix patch and apply it.
Sometimes a rule or a script stuck and still run. Or user can click workflow button more than one.
Generally this issue comes when PPM put some LOCKS on the DB tables for updation... and if the execution is not sucessfull then these locks are not released. Mainly such issue occurs on workbench side.... but these are also observed some time on front-end/dashboard side. Here we are resolving such issue by checking the session locks on the DB tables from back-end and then disconnect that session. You can use any of these below queries to identify the locks.. and check if any lock is on time mgmt or task table... if you find those tabled then disconnect that session id... it will resolve your issue.
select c.owner, c.object_name, c.object_type, b.sid, b.serial#, b.status, b.osuser, b.machine from v$locked_object a, v$session b, dba_objects cwhere b.sid = a.session_id and a.object_id = c.object_id;
3. We faced the same issue we were not able to update the user data in workbench. Lock did not release after closing the workbench/application. By recycling the application jvms lock was released and we were able to update the user data in workbench.
PS: If the post resolves your issue, please click KUDOS star icon and mark it as Accepted Solution.
IT Governance Professional & PPM Solution Architect