2284729 - sp_helpcache hits Error 515 & doesn't show lockless data cache - SAP ASE

• After a lockless data cache is successfully configured:

sp_cacheconfig "sys_cache", "10M", "lockless data cache", "relaxed"
go
The change is completed. The option is dynamic and ASE need not be rebooted for the change to take effect.
(return status = 0)

• sp_helpcache raises a 515 error and does not show the information about the lockless data cache:

sp_helpcache
go
Msg 515, Level 16, State 3:
Server 'ASE16', Procedure 'sp_helpcache', Line 227:
Attempt to insert NULL value into column 'cachetype', table '#cachesize_info'; column does not allow nulls. Update fails.
Command has been aborted.
 
 Cache Name         Config Size   Run Size   Overhead   Cache Type
 ------------------ ------------- ---------- ---------- ------------
 default data cache    8.00 Mb       8.00 Mb    1.25 Mb Default
 
Memory Available For      Memory Configured
Named Caches              To Named Caches
--------------------       ----------------
  18.01 Mb                    18.00 Mb
 ....

SAP Adaptive Server Enterprise (ASE) 16.0 SP02 and higher

master, syscacheinfo, CR796106, CR#796106, 796106 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed