SAP Knowledge Base Article - Preview

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"
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:

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


SAP Adaptive Server Enterprise 16.0


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

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.