3503357 - Cursor I/O metrics are accumulating incorrectly - SAP ASE

The problem reported in KBA2276960 is not able to handle insensitive cursor, and the following error occasionally occurs.

'Set statistics io on' and MDA tables monProcessActivity, monState, monSysStatement for a cursor are reporting hugely inflated numbers.

2276960 - Statistics i/o and plancost outputs are cummulative for cursors - SAP ASE

As a result, a negative value will be set to the counter value.

ex: LeOperator::LeOpProcessIOStats(): process 114 has negative physical reads counters. les_cur_fetch_physreads = -1, les_cur_fetch_physapfreads = 1

SAP Adaptive Server Enterprise 16.0

775633, 828917 , ASE, SAPASE, dataserver, LeOperator, MDA, monitor , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

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