Clarity

  • 1.  Timesheet Lock

    Posted Feb 26, 2016 12:21 AM

    Hello All,

     

    One of the users of CA Clarity PPM is facing an issue with his Timesheet. He is getting an error message - "TMA-0111: Error updating timesheet. Couldn't obtain lock. Click browser's back button and try again." I suppose this is linked to a Timesheet Lock that may have been generated when the Timesheet might have been saved. However, a few hours later when I try to look into this issue by using the SQL Query:

     

    select * from prlock;

     

    I notice that the DB Table prlock is returning 0 records. So, is it possible that the Timesheet Lock has now been cleared? Do Timesheet Locks clear automatically after a few hours? If yes, after how many hours on an average?

     

    Many Thanks,

     

    Suhail.



  • 2.  Re: Timesheet Lock
    Best Answer

    Broadcom Employee
    Posted Feb 26, 2016 02:45 AM

    The locks are generated on the business logic written via process on the timesheet submission, if the timesheet is waiting for approval and is locked by process you will see that warning message, and once its approved the lock will be removed.

     

    This can happen due to few other reason like process instance was deleted.

    We do have a technical document, see id this helps

    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec484045.aspx

     

     

     

    Suman Pramanik



  • 3.  Re: Timesheet Lock

    Posted Feb 26, 2016 03:43 AM

    There was also a Tuesday's tip on that

    CA Clarity Tuesday Tip: Time Sheet Locks