2433397 - Invalid OAM page (OAMINVALID_1) with stacktrace when killing spid - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2433397 - Invalid OAM page (OAMINVALID_1) with stacktrace when killing spid - SAP ASE

Symptom

  • After a spid running 'update statistics' is killed
  • ASE errorlog show 'Invalid OAM page' message for killed spid with a stacktrace :

00:0001:00000:00123:...  Process id 291 killed by Hostname my_host , process id 12345.
....
00:0001:00000:00291:...  Invalid OAM page (OAMINVALID_1) stat 4: pageno=12345678, sdes_stat=16, pstat=0x181, dbid=2, pptnid=-987654321, pindid=0, expected ptnid=-987654321

pg__objdeall_validate_obj
pg_ptndeall
closetable
close_range
terminate_process
memalloc_zero
lmlink
startsort
sort
ups_build_stat_noindex
update_statistics
internal_sql


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) SP133 and higher
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP01 and higher

Product

SAP Adaptive Server Enterprise 15.7

Keywords

error 1142 , 1142 , 'Invalid OAM page' , OAMINVALID_1  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.