Error 622

Severity

20

Message text

Versions earlier than 15.0:

Opentable was passed a varno of %d. Object  '%.*s' already has that session descriptor in use.

Version 15.0 and later

Opentable was passed a varno of %d. Object '%.*s' in database '%.*s' already has that session descriptor in use. This occured while opening object id %d in database id %d.

Explanation

A session descriptor is an internal data structure in Adaptive Server which contains information about a table. All open objects in Adaptive Server require a descriptor structure. Whenever a connection to Adaptive Server attempts to open a table, it gets a session descriptor. varno refers to a variable number that Adaptive Server uses to maintain an array of session descriptors for a query. A unique varno is assigned to each session descriptor tracking the usage of a given object for the query.

Error 622 is raised when Adaptive Server attempts to open a table, but the varno points to a session descriptor that is already in use.

Error 622 breaks the user’s connection to Adaptive Server.

Action

Error 622 is due to an Adaptive Server problem. Contact Sybase Technical Support for assistance when this error is raised.

Additional information

When calling Technical support have the information on hand listed in “Reporting errors”, including the text of the query that raised the error.

Versions in which this error is raised

All versions