SAP Knowledge Base Article - Preview

2342223 - Error 8203 while creating temp table - CREATE temp table spid was "sleeping" in obj_id

Symptom

  • In rare circumstances an ASE task that is in the process of creating a temporary table in a user defined temporary database may sleep for ever while ASE generates the object ID value for this table. The call stack for the sleeping task will report the modules 'crt_main' and 'objd_id'.

  • ASE errorlog contains and 8203 error.

Example:
Error: 8203, Severity: 26, State: 20
Expected to find the descriptor for object 302420533 in database 2 in CREATE state.

des_create_inxact
crt_main


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.0.3

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.