- A user query creates a large temporary worktable and hits Error 1105 State 4 on a temporary database.
- It is followed by Error 696 with a stack trace reported for a temporary worktable in the ASE errorlog:
Error: 696, Severity: 21, State: 2
An attempt was made to fetch logical page '858200' from cache 'tempdb_cache1'. Page belongs to database 'tempdb2' (102), object '<Unknown>' (0), index '<Unknown>' (0), partition '<Unknown>' (-1432092673) and not to database 'tempdb2' (102), object 'temp worktable' (-1432092673), index '<Unknown>' (0), partition '<Unknown>' (-1432092673). Restart of ASE will clear the error. Please contact your System Administrator for help.
Note: The message shows the same objid in multiple places.
- The stack trace shows the following functions:
Note: A complete stack trace is available under Attachments.
SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL08
CR821746, CR#821746, 821746, stacktrace, transient, temp, tempdb , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.