3787116 - Signal 11 in mda_fill_and_send_monProcessActivity - ASE

• ASE monitoring via MDA table sometimes failes with Signal 11 followed by a stack trace:
   kernel  Address 0x0x00000000012dd43d (mda_fill_and_send_monProcessActivity+0x217), siginfo (code, address) = (1, 0x(nil))
   kernel  Current process (0x5fc30307) infected with signal 11 (SIGSEGV)
  
  
  
• SQL causing error:
  

  INSERT INTO saptools..ASE_ALERT_METRICS(
          COLLECT_MODE,
          SNAPSHOT_TIMESTAMP,
          TIMESTAMP_UTC,
          METRIC_ID,
          INSTANCEID,
          SITE,
          ENTITY,
          RESOURCE,
          METRIC_VALUE_S,
          METRIC_VALUE,
          UNIT,
          SOURCE_HOSTNAME )
   SELECT @dbh_collect_mode AS COLLECT_MODE,
          @snap_tstmp AS SNAPSHOT_TIMESTAMP,
          TIMESTAMP_UTC AS TIMESTAMP_UTC,
          149 AS METRIC_ID,
          null AS INSTANCEID,
          null AS SITE,
          null AS ENTITY,
          null AS RESOURCE,
          CAST((locks_free) AS VARCHAR(35)) AS METRIC_VALUE_S,
          CAST((locks_free) AS DECIMAL(34,9)) AS METRIC_VALUE,
         'N/A' AS UNIT,
         (saptools.dbo.sap_realhostname(null)) AS SOURCE_HOSTNAME
   FROM   (select getutcdate() AS TIMESTAMP_UTC,locks_conf-locks_used locks_free
           from  (select convert(numeric(34,9),sum(LocksHeld)) as locks_used from master..monProcessActivity) corTab1, (select convert(numeric(34,9),value) as locks_conf  from master..sysconfigures where name = 'number of locks' )  corTab2) corTab

• Stack trace includes the following modules:
  mda_fill_and_send_monProcessActivity
  mda_std_populate_pid
  mda_populate_monProcessActivity

SAP Adaptive Server Enterprise 16.0 SP04 PL06.

signal 11, sigsegv, mda_fill_and_send_monProcessActivity, monProcessActivity, null pointer dereference, ase alert metrics, severity 99, shared memory dump, stack trace, master..monProcessActivity, sysconfigures, locksheld, monitoring query , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem