Page 1 of 1

DataStage Administrator

Posted: Mon Apr 25, 2005 4:40 am
by ewartpm
Hi All

I'm trying to open the DataStage Administrator and get the following error:

CDSRUseraccess.TakeSharedLock: Internal error - Failed to open file: UV.ACCOUNT (81002)

I have stopped and restarted the services but still get the error. :cry:

Any help will be greatly appreciated.

Thanks

Posted: Mon Apr 25, 2005 4:58 am
by ArndW
Hello ewartpm,

if you "telnet localhost" on your Windows DS server, do you get a prompt and can you login to the account "UV" with your user-id and password?
If that works, do a "LOGTO <your ds project name>". If you get an error, tell us what it is; if not then the good news is that your account might not be corrupted.

Posted: Mon Apr 25, 2005 6:40 am
by Sainath.Srinivasan
Check whether any other person is working on the project in the same time.

Posted: Mon Apr 25, 2005 7:12 am
by ArndW
Does the Admin take a lock on the account? I need to check up on that...

Posted: Mon Apr 25, 2005 7:22 am
by ArndW
Sainath - just had 3 people go into the Admin at the same time; that doesn't seem to be it.

Posted: Mon Apr 25, 2005 10:08 am
by Sainath.Srinivasan
ArndW,

My assumption was in terms of someone bouncing the server or protecting the project etc.

Posted: Mon Apr 25, 2005 12:33 pm
by ewartpm
Thanks for the advice.
I have Telnetted into the project, gone into DS.Tools and rebuilt the indexes.

However, when I try to log onto a project (any project because we curently have 4 projects running concurrently) I get the following error:

Error calling subroutine: *DataStage*DSR_SELECT (Action=4); check DataStage is set up correctlyin project ForkliftDevIBR (The connection is broken (81002))

The services are running, project has been reindexed, I can log into the project using Telnet, so what's wrong now????

Posted: Mon Apr 25, 2005 2:00 pm
by ray.wurlod
What happens if, having connected via telnet and entered the DataStage environment, you execute the following commands:

Code: Select all

LOGTO UV
SELECT @ID, PATH FMT '40L' FROM UV.ACCOUNT;
(Trying to establish why a "can't open UV.ACCOUNT" error occurred.)