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 for Me (Login required).

Search for additional results

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