Symptom
- The ASE errorlog reports errors 3702 and 622:
Error: 3702, Severity: 16, State: 1
Cannot drop the table '' because it is currently in use.
Error: 622, Severity: 20, State: 1
Opentable was passed a varno of 0. Object '#mytemp01000600020590207' in database 'mytempdb1' already has that session descriptor in use. This occurred while opening object id 688002451 in database id 4. - Other messages seen in the error log may include:
Msg 1105, Level 17, State 4:
Server 'servername', Line 1:
Can't allocate space for object 'syslogs' in database 'tempdb' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
Warning: SERVERNAME tempdb logsegment is at 79.99 space available in the log segment has fallen critically low in database 'tempdb'.
Failed to allocate disk space for a work table in database 'tempdb'.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)- All versions
Product
SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions
Keywords
orphan, temp table, CR661452, 661452, CR#661452, orphantable orphan cr661452 , 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.
SAP Knowledge Base Article - Preview