SAP Knowledge Base Article - Preview

2270636 - Error 8211 on LWP with lwp_create and des__hashint in stack - SAP ASE

Symptom

  • ASE errorlog reports error 8211
  • For an LWP object name like "*ss123456000_987654000ss*", which is the name of an internal cached statement:

Error: 8211, Severity: 26, State: 1
Mismatch found between the name and id descriptor hash  table for table '*ss123456000_987654000ss*', objid = 123456789. Descriptor hashed by name = 0x0 and hashed by id = 0x2421d310.

  • Functions lwp_create and des__hashinst are in stack trace.

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0

Product

SAP Adaptive Server Enterprise 15.7

Keywords

lwp_create, des__hashinst, ssql_name,  ssql_id, lightweight, procedure, 794974, CR794974, proccreate, s_crtproc, s_cache_stmt, DES, allocate, stacktrace, system tempdb, temporary table, cached SQL statement If using statement cache which may use many positive object ids in tempdb, then try to drop user table in system tempdb after usage or not to create user tables in system tempdb. Using temporary table(which name starts with '#') may reduce the chance of problem since temporary table has scope and will not stay after the session finish, but temporary table is session private. Consider other user database for user tables which will be used by multiple sessions. , 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.