SAP Knowledge Base Article - Preview

3804139 - Errors 622 - SAP ASE

Symptom

Procedure is reporting Error 622 with stack trace:

====

They started to hit on error 622 with a stack trace:

=====

Error: 622, Severity: 20, State: 1
Opentable was passed a varno of 3. Object 'Tb01' in database 'db01' already has that session descriptor in use. This occurred while opening object id NNNNNNNN in database id Y.
.....
.....
exc__raise
exc_reraise_lasterror
open_user_table
get_range_sdes
open_range
colnames_driver
s_normquery
s__call_normquery
s_normalize
s_renormalize
s_recompile
sequencer
execproc
....
....

=====

This error affects the same procedure and same table is mentioned in the error message.

Procedure was recreated but error persisted. ASE was restarted but error persisted too.


Read more...

Environment

SAP Adaptive Server Enterprise 16.0 SP04 PL04 

Keywords

error 622, 622, exc_reraise_lasterror, open_user_table, get_range_sdes, open_range, sdes_hookup, CR 832549, CR832549, CR#832549, 832549 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.