CA PPM: TMA-0111 timesheet error when adding tasks or saving timesheet

Document ID : KB000025510
Last Modified Date : 29/06/2018
Show Technical Document Details
Issue:

TMA-0111 error when attempting to perform an operation that saves a timesheet, e.g populate, submit, add task, return, etc)
A time entry lock was not deleted from the PRLock table after being locked.

Cause:
Such an event may happen if a deadlock occurs or services are stopped during a timesheet save.
Resolution:

Use the following details to resolve the issue.


1.Run the following query:

--Oracle
select * from prlock, cmn_sec_users
where cmn_sec_users.id = prlock.pruserid
and prtablename = 'PRTIMESHEET'
and prname = '~prTimeEntry'
and prlockedsince < sysdate - 0.042
 

--MSSQL
select * from prlock
where prtablename = 'PRTIMESHEET'
and prname = '~prTimeEntry'
and prlockedsince < getdate() - 0.042

Please return the results in an XLS file with headers.

2. If the query returns any results, run this query:

--ORACLE
delete from prlock
where prtablename = 'PRTIMESHEET'
and prname = '~prTimeEntry'
and prlockedsince < sysdate - 0.042;
commit;

--MSSQL
delete from prlock
where prtablename = 'PRTIMESHEET'
and prname = '~prTimeEntry'
and prlockedsince < getdate() - 0.042