SAP Knowledge Base Article - Preview

3342976 - Error 622 when select from view that has query with "UNION" - SAP ASE

Symptom

  • Compatibility mode is turned on.
  • The view has query with 'UNION'.  It runs fine when running the queries separately.
  • Getting error 622 when running select from the view:
      
    1> select * from <view_name>
    2> go
    Msg 622, Level 20, State 1:
    Server 'XXXX', Line 1:
    Opentable was passed a varno of 253. Object 'temp worktable' in database 'tempdb' already has that session descriptor in use. This occurred while opening object id -5046273 in database id 4.


Read more...

Environment

SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Error 622, Msg 622, 622, compatibility mode, UNION, view, 748578, CR 748578, CR#748578

 
, 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.