Clarity

  • Private Community

  • 1.  What is SRM_PROJECTS lock in PRLOCK table.

    Posted Nov 07, 2017 11:00 AM

    I have seen Lock on Projects "SRM_PROJECTS" record in PRLOCK table couple of time and wanted to know what is this and How would be the error.

     

    The table is giving following Information

    PRNAME:- prImportExport

    PRRECORDID and PRRESOURCEID.

     

    Does it mean the Resource cannot access the whole Project ? or will gets Lock button like how we get when Process locks it.



  • 2.  Re: What is SRM_PROJECTS lock in PRLOCK table.

    Posted Nov 07, 2017 11:20 AM

    prImportExport is when the project is open read/write in OpenWorkbench, MSP or the Gantt editor



  • 3.  Re: What is SRM_PROJECTS lock in PRLOCK table.

    Posted Nov 07, 2017 11:32 AM

    Can you please describe it briefly ?



  • 4.  Re: What is SRM_PROJECTS lock in PRLOCK table.

    Posted Nov 07, 2017 11:40 AM

    I'm not sure what else you expect me to "describe" - this is not an error, this is just the way the application works.

    (It is preventing a user updating project plans whilst another user is also updating project plans)



  • 5.  Re: What is SRM_PROJECTS lock in PRLOCK table.

    Posted Nov 07, 2017 11:47 AM

    Do you mean Project plan mean Fiscal plan? except Project plan will this lock stops user accessing any other on project ?



  • 6.  Re: What is SRM_PROJECTS lock in PRLOCK table.

    Posted Nov 07, 2017 12:02 PM

    I mean project tasks. Only one user can update at the same time.



  • 7.  Re: What is SRM_PROJECTS lock in PRLOCK table.
    Best Answer

    Posted Nov 07, 2017 02:38 PM

    When a project is locked, it means that that that user is working on that project. At a time, only one user can update a projects/plans. Suppose, if any operation is performing by a process on a project using xog gel script, that project is not available to edit for other users till it complete the process.