SAP Knowledge Base Article - Preview

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


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



SAP Adaptive Server Enterprise 16.0


SAP Adaptive Server Enterprise 16.0


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.