DSXchange

One of the things that will cause this message is if you get a network timeout..

This can occur if you leave a DataStage client connected and go out for lunch

81002 can also occur if the dsrpcd daemon is stopped.

81002 decodes as "dsrpc: No connection."

Does this only happen after your session has been idle for a while?

Does it happen only to DataStage clients or do Telnet sessions also get timed out?

Have you checked the process start times of the dsrpcd daemon to eliminate the possibility Ray mentioned?

Thanks for the reply.
How to check whether the dsrpc is running or not?
ps -ef |grep dsrpc ---i'm getting

root 2518 1 0 01:23:58 ? 0:00 /dstage/Ascential/DataStage/DSEngine/bin/dsrpcd
dsadm 20948 20729 0 17:35:50 pts/1 0:00 grep dsrpc

Also,
SELECT * FROM SYS.MESSAGE WHERE @ID = 080012 - if i run the query from administrator, in the output window, it is showing only SQL+.

What am i missing here???

Please help.

add a semi-colon to the query.

[quote="jzparad"]add a semi-colon to the query.[/quote]

I have added the semicolon. I'm getting datastage/sql: character and number types are incompatible in this operation

Help me

You also need to wrap the 080012 in quotes

i.e.

'080012'

[quote="jzparad"]You also need to wrap the 080012 in quotes

i.e.

'080012'[/quote]

Thanks JZparad
I'm getting MESSAGE...Unable to set remote uid or gid.

What does the above indicates?

You never answered my previous questions.

Also check this out.

http://www.dsxchange.com/viewtopic.php ... uid+or+gid

I have got the following message only after executing the query (forgot to mention that previously).

MESSAGE...Unable to set remote uid or gid.

If there are more than 5 developers trying to access the DS at the same time....i'm getting the error.

Have you checked out your user limit in DataStage Administrator?

Was the number 81002 as originally reported or 80012 as subsequently reported? They are radically different, though both related to the RPC mechanism.

The user limit says 5. I have been using this server for the past 2 months and only from the last 2 days i'm getting this error. Also the server has been shared by multiple projects and the other projects are not facing any 81002 error. Do you feel user limit is the issue???
Answering to ray's qn, the error number is 81002.
Is this due to network traffic by any chance?? B'cause sometimes it's working fine and if more than 5 developers trying to access it, it is throwing the 8102 error. If this is b'cause of the user limit, it should have thrown the error long back correct?

Thanks

My guess is this is a licensing error. I know you get an error when you hit the limit but I can't remember the error number. Easy way to check - next time you hit the error, ask someone to log out and try logging in.

It's not a licensing error. Exceeding your licensed user count does not throw an error but pops up a rather obvious message box stating that you are licensed for X users and all X are in use.