Archives of the TeradataForum

Message Posted: Thu, 17 Aug 2006 @ 10:30:21 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: No available session to use

From:		McCall, Glenn David

Is there any session limit in teradata. I getting error in bteq "No available session to use".

Have you looked at the messages manual?

There are a couple of matches, each of which basically says the same thing.

In a nutshell it sounds like there was a hiccup in the system and everything didn't quite get back in sync.

If it happens frequently, you should seek help from Teradata support.

08018 The session id is illegal.

Explanation: The session id specified in any request is not valid. Either the session had never been logged on, the session did not reconnect within the gateway timeout period after a DBS reset, or the session id is simply malformed.

Generated By: Gateway

For Whom: End User

Remedy: Correct the session number and resubmit the request.


	<Prev	Next>		<<First	<Prev	Next>	Last>>