Help needed.....connection is broken 81002??

gpatton · Post by **gpatton** » Thu Jan 19, 2006 2:28 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Jan 19, 2006 4:17 pm

81002 can also occur if the dsrpcd daemon is stopped.

81002 decodes as "dsrpc: No connection."

jzparad · Post by **jzparad** » Thu Jan 19, 2006 4:35 pm

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?

colorblue · Post by **colorblue** » Thu Jan 19, 2006 4:46 pm

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.

jzparad · Post by **jzparad** » Thu Jan 19, 2006 4:50 pm

add a semi-colon to the query.

colorblue · Post by **colorblue** » Thu Jan 19, 2006 4:56 pm

[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

jzparad · Post by **jzparad** » Thu Jan 19, 2006 5:09 pm

You also need to wrap the 080012 in quotes

i.e.

'080012'

colorblue · Post by **colorblue** » Thu Jan 19, 2006 5:13 pm

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

jzparad · Post by **jzparad** » Thu Jan 19, 2006 5:23 pm

You never answered my previous questions.

Also check this out.

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

colorblue · Post by **colorblue** » Thu Jan 19, 2006 5:45 pm

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.

jzparad · Post by **jzparad** » Thu Jan 19, 2006 6:07 pm

Have you checked out your user limit in DataStage Administrator?

ray.wurlod · Post by **ray.wurlod** » Thu Jan 19, 2006 6:26 pm

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

colorblue · Post by **colorblue** » Thu Jan 19, 2006 7:49 pm

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

jzparad · Post by **jzparad** » Thu Jan 19, 2006 9:19 pm

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.

chulett · Post by **chulett** » Thu Jan 19, 2006 9:33 pm

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.