Project and Portfolio Management Practitioners Forum
cancel

ERROR:: Request is being updated by another database session

SOLVED
Go to solution
Highlighted
Pachi
Super Contributor.

ERROR:: Request is being updated by another database session

Hi ,

 

 

I am getting the below error which i try to update and ITG, could you please advice.

 

one or more references
in this Request is being updated by another database session. Please try again
later. (KCRT-40186)

 

 

Regards,

Pachi

Regards,
Pachi
5 REPLIES
Celil
Acclaimed Contributor.

Re: ERROR:: Request is being updated by another database session

Did anybody logged in to PPM ?
Celil

IT Governance Professional
& PPM Solution Architect
Pachi
Super Contributor.

Re: ERROR:: Request is being updated by another database session

Many have logged in.

 

One user is not able to update one particular ITG.

 

Regards,

Pachi

Regards,
Pachi
Celil
Acclaimed Contributor.

Re: ERROR:: Request is being updated by another database session

Hi Pachi,

 

Here are some solutions and experienced practices:

 

  1. 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.
  2. Sometimes a rule or a script stuck and still run. Or user can click workflow button more than one.
  3. 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 a.session_id,a.oracle_username, a.os_user_name, b.owner "OBJECT OWNER", b.object_name,b.object_type,a.locked_mode from(select object_id, SESSION_ID, ORACLE_USERNAME, OS_USER_NAME, LOCKED_MODE from v$locked_object) a,(select object_id, owner, object_name,object_type from dba_objects) bwhere a.object_id=b.object_id


    OR

 

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.

 

Celil

IT Governance Professional
& PPM Solution Architect
Pachi
Super Contributor.

Re: ERROR:: Request is being updated by another database session

Hi,

 

Please find the result of what your query returned.All are pointing to 294 ID,

which should i be killing, and how can i kill tht?

 

 

Regards,
Pachi
Celil
Acclaimed Contributor.
Solution

Re: ERROR:: Request is being updated by another database session

Hi Pachi, 

 

We have to get one more information by using this query:

select sid, serial# from v$session where sid = session_id;

 

Now, you can unlock object using session id and serial# by this operater:

alter system kill session 'session_id, serial# '

 

 

PS: If the post resolves your issue, please click KUDOS star icon and mark it as Accepted Solution.

 

Celil

IT Governance Professional
& PPM Solution Architect