SAP Knowledge Base Article - Preview

1963568 - Errors 3702 & 622 for temporary table - SAP ASE

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.