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.