There is a need to clear locks so that projects can be edited.
Are there specific rights required to view the hidden page for clearing locks without contacting the DBA team?
All
There is a hidden page to clear locks can be accessed by the following steps:
1. Provide user the global right(Administration - Studio)
2. Have the user access the page via URL: http://<hostname>.ca.com/nu#action:security.locks
3. Review the lock types and remove the locks as needed.
The PRLOCK table is used to prevent concurrent editing.
The most frequent lock types are as follows:
a. Import Export Lock
Created when a project is opened with a scheduler (OWB or MSP). It should be cleared when the project is saved and closed.
b. Job Scheduler Lock
Created when a job is scheduled, to prevent concurrent job runs and race conditions, among other possible problematic situations.
c. Process Engine:
Created when there is a process instance attached to an object
d. Project Insert Lock
Created when there is a project creation or or convert an idea to project.