2130834 - monMemoryUsage queries fail in kbfusage, mda__MemUsg_one_FragmentPool - SAP ASE

You are running applications on SAP ASE database.

• On non-SAP systems, you execute a query against monMemoryUsage monitoring table.  For example: select * from master..monMemoryUsage 
• On SAP systems, you have enabled Memory  Usage data collector  in DBACockpit->Data Collector Framework
  
  
• In both scenarios, the process terminates with a timeslice or signal 11 errors in the ASE errorlog at address kbfusage:

Current process (0x3b2f0086) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001d85c7d (kbfusage+0x36d)

• The errors are accompanied by a stacktrace referencing the functions:

kbfusage
ubfprop
mda__MemUsg_one_FragmentPool
mda__MemUsg_FragmentPool
mda__MemUsg_PoolList
mda_populate_monMemoryUsage
mda_exec

• And SQL Text and/or SQL causing error section showing query on MDA table monMemoryUsage
• Below an example snippet that is commonly seen for a DBACockpit query:

....
AS UsedSize_Delta_KB, ((UsedSize/1024)) AS UsedSize_KB FROM  master..monMemoryUsage AS SRC_MONMEMORYUSAGE

• Subsequently, further messages including error 1601 may be seen:

ksepollnetctlrWaitForCompletion:polled events 0x18 for vsn 127 psn 120 flags 0x80000000 kpid 994115631

Error: 1601, Severity: 17, State: 3
There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure ASE with more user connections.

See attached file Stack_Error_Example.txt for a full example from ASE log.

• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 16.0
• SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

kbfusage+0x15a() , ubfprop+0xfa() , mda__MemUsg_one_FragmentPool+0x4c() , mda__MemUsg_FragmentPool+0xd8() , mda_populate_monMemoryUsage+0x1c2() , mda_exec+0xb2() ,
kbfusage.fdpr.chunk.3 , ubfprop.fdpr.chunk.3, mda__MemUsg_PoolList+0x2af(), monMemoryUsage , KBA , monitoring table , mda , memory corruption , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Bug Filed