Project getting locked

mchivuku · Post by **mchivuku** » Sat Feb 04, 2006 8:01 am

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

ray.wurlod · Post by **ray.wurlod** » Sat Feb 04, 2006 2:51 pm

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.

kumar_s · Post by **kumar_s** » Sun Feb 05, 2006 12:01 am

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

mchivuku · Post by **mchivuku** » Sun Feb 05, 2006 12:57 am

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

Hi,

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

kumar_s · Post by **kumar_s** » Sun Feb 05, 2006 1:14 am

HI,
Its fine that the issue didnt sustained.
Accessing multiple client with single fully qualified user id shouldnt be an issue. Restriction liscience would lead to different log message.
BTW what is the maximum number of user accessed the server concurrently?

-Kumar

Sreenivasulu · Post by **Sreenivasulu** » Mon Feb 06, 2006 11:52 pm

HI,

I remember getting this error. We opened the lock configuration file and tried to change the parameter but it did not work.

We restarted the server. This solved the issue

Regards
Sreeni

Vishvas · Post by **Vishvas** » Tue Feb 07, 2006 1:45 am

We had the same problem. We could not login into the director or start any jobs. We stoped some of the jobs that were running and everything became normal.

Regards,
Vishvas

MTA · Post by **MTA** » Tue Feb 07, 2006 9:32 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.

MTA · Post by **MTA** » Tue Feb 07, 2006 9:46 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 07, 2006 2:22 pm

I would expect to see "license count exceeded" error message in this case.

chulett · Post by **chulett** » Thu Feb 09, 2006 3:34 pm

Must be something going around - I'm seeing this issue for the first time today. Existing connections are fine, but any attempt to create a new connection is greeted with the 'Project is locked' message.

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.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 09, 2006 9:26 pm

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.

chulett · Post by **chulett** » Thu Feb 09, 2006 9:58 pm

Unfortunately, there isn't. You get an error dialogue that basically says:

Code: Select all

ACCESS DENIED: Project has been locked by the Administrator. Try again later or check with your Administrator

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.

dsusr · Post by **dsusr** » Thu Feb 09, 2006 10:13 pm

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

Hi 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

ray.wurlod · Post by **ray.wurlod** » Thu Feb 09, 2006 11:07 pm

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?)

DSXchange

Project getting locked

Project getting locked

Re: Project getting locked