SAP Knowledge Base Article - Preview

1974539 - Error 622, Level 20, State 1 when running a query with NOT IN nested subqueries -SAP ASE

Symptom

Received the following error while running a query with a 'NOT IN' clause and subquery:

Msg 622, Level 20, State 1:
Server 'xxxxx', Line 2:
Opentable was passed a varno of 1. Object '' in database 'tempdb' already has
that session descriptor in use. This occurred while opening object id -1310722 in
Database id 2.
ASE is terminating this process


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP51
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Not in, subquery   , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.