- 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.
SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0
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 pageThis 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.