Symptom
A SIGSEGV may occur or ELC_VALIDATION_ERROR message is frequently logged when updating rows in a base table if statement cache and literal autoparam are enabled.
This issue can be observed if a materialized view (precomputed result set) exists for the base table and the materialized view contains data.
ex:
terminate_process
kisignal
subparams
s_execsetvar
s_execute
sequencer
00:0004:00000:00028:2023/09/13 11:22:35.18 server ELC_VALIDATION_ERROR: Page address not aligned to memory page size. memptr = 0x151d47020, pelc = 0x147727970, chunksize = 2, engine id = 2, validate_flag = 1
00:0004:00000:00028:2023/09/13 11:22:35.18 server ELC_VALIDATION_CORRECTION: Backup page pointer 0x151d47000 was used. pelc = 0x147727970
, chunksize = 2 engine id = 2
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.x
Keywords
Sybase, ASEServer, SAPASE, dataserver, SIGSEGV, "signal 11", subp, "materialized view", materialized, stacktrace , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Known Error
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.