Project getting locked
Moderators: chulett, rschirm, roy
Project getting locked
Hi
"
When I am running a job I get below error :
ACCESS DENIED: Project currently locked. The project is currently locked by Administrator. Try again or see your Administrator
"
Does anyone has an idea why this error comes.
regards
Murali
"
When I am running a job I get below error :
ACCESS DENIED: Project currently locked. The project is currently locked by Administrator. Try again or see your Administrator
"
Does anyone has an idea why this error comes.
regards
Murali
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
This can occur if someone is performing an administrative task that requires exclusive access to the Repository.
If that process was interrupted (killed) then the lock may continue to be held, though spuriously. Restarting DataStage may help.
This can occur if someone is performing an administrative task that requires exclusive access to the Repository.
If that process was interrupted (killed) then the lock may continue to be held, though spuriously. Restarting DataStage may help.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi,kumar_s wrote:Hi,
You mean to say, you are getting this at mid of job flow?
Is it for all the jobs you run or only of a specific job?
As per Ray, was there any admistrative task going on?
-Kumar
This is for all jobs. No administrative task was going on when I found this error. However, there was a single user id being used to access all the jobs from different places at the same time. Could this be a cause??
However the problem died down itself after sometime without having to restart the DS server.
Thanks
Murali
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Kumar,
Can you please provide the error message that you would get due to restricted licences.
Background:
In our case can we have 7 licenced users we can open up to only 7 sessions, when the 8th user tries to log in he gets an error message same error as murali mentions that the project is locked by the administrator.
Can you please provide the error message that you would get due to restricted licences.
Background:
In our case can we have 7 licenced users we can open up to only 7 sessions, when the 8th user tries to log in he gets an error message same error as murali mentions that the project is locked by the administrator.
M.T.Anwer
The day the child realizes that all adults are imperfect he becomes an adolescent;
the day he forgives them, he becomes an adult; the day he forgives himself, he becomes wise.
-Aiden Nowlan
The day the child realizes that all adults are imperfect he becomes an adolescent;
the day he forgives them, he becomes an adult; the day he forgives himself, he becomes wise.
-Aiden Nowlan
Kumar,
Let me rephrase the background again:
In our case we have 7 licences so we can open up to only 7 concurrent sessions, when the 8th user tries to log in he gets the same error as murali mentions that the project is locked by the administrator.
Let me rephrase the background again:
In our case we have 7 licences so we can open up to only 7 concurrent sessions, when the 8th user tries to log in he gets the same error as murali mentions that the project is locked by the administrator.
M.T.Anwer
The day the child realizes that all adults are imperfect he becomes an adolescent;
the day he forgives them, he becomes an adult; the day he forgives himself, he becomes wise.
-Aiden Nowlan
The day the child realizes that all adults are imperfect he becomes an adolescent;
the day he forgives them, he becomes an adult; the day he forgives himself, he becomes wise.
-Aiden Nowlan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
![Evil or Very Mad :evil:](./images/smilies/icon_evil.gif)
It's not a license issue, as noted there is a specific message from that we've seen before. I'm wondering if this is a resource issue, or a confusion in the engine or what? I'm hoping to find some other course of action other than kick everyone off and bounce DataStage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is there an error code with the message? If so you might get more information out of the SYS.MESSAGE table. Or out of the Errors and Remedies manual reported to be part of Hawk.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Unfortunately, there isn't. You get an error dialogue that basically says:
From memory, but that's basically that's what it says. Problem is - I is the Administrator and I sure as heck didn't lock it and wasn't performing any administration tasks of any kind.
Ended up having to kick everyone off and bouncing the server.![Confused :?](./images/smilies/icon_confused.gif)
Code: Select all
ACCESS DENIED: Project has been locked by the Administrator. Try again later or check with your Administrator
Ended up having to kick everyone off and bouncing the server.
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Project getting locked
Hi Murali,mchivuku wrote:Hi
"
When I am running a job I get below error :
ACCESS DENIED: Project currently locked. The project is currently locked by Administrator. Try again or see your Administrator
"
Does anyone has an idea why this error comes.
regards
Murali
There can be many reasons for getting this error. One of the main reason due to which we have faced this error in our project is the number of open connections were going beyond 50 so whenever a person even tried to open any client he will recieve this error.
To check how many connections are open type the following command
ps-ef|grep dscs|wc -l
You can kill the old connections using unix kill command. Also this setting of 50 is somewhat related to the some parameters for DataStage ( MFILES or NOFILES )
Regards
dsusr
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sounds like they've changed the message (I've been on a 7.0 site for a couple of weeks). Has anyone had a response from support provider about what might cause this?
If it occurs because of client licensing, you (the administrator) can check the DS_LICENSE table to see which client machines are actually connected. This will also give you the PID of their associated dsapi_slave process (or maybe dsapi_server). So you have a more accurate idea of whom to kill. (Anyone remember Serge the Seal?)
If it occurs because of client licensing, you (the administrator) can check the DS_LICENSE table to see which client machines are actually connected. This will also give you the PID of their associated dsapi_slave process (or maybe dsapi_server). So you have a more accurate idea of whom to kill. (Anyone remember Serge the Seal?)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.