2342223 - Error 8203 while creating temp table - CREATE temp table spid was "sleeping" in obj_id | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.