2699666 - ASE hangs for a few minutes then restarts again on its own

• ASE hangs for no apparent reason, stays unresponsive for a few minutes then restarts again and continues as normal.
  
  
• Sometimes normal processing can resume after a couple of minutes but often Sybase DBA has to reboot the ASE after the ASE appears to hang for 15 minutes or more.
  
  
• The ASE has a very large statement cache (at least hundreds of Mb).
  
  
• java application executing a query
  
  
• Sometimes following error will be raised: 
    701, Severity: 17, State: 12 There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache.

• statement cache memory leak

Read more...

SAP Adaptive Server Enterprise (ASE) 16.0

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.0 ; Sybase Adaptive Server Enterprise Cluster Edition 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.7

Sybase, ASEServer, SAPASE, dataserver, CR816848, CR#816848, 816848, statement cache, Error 701, memory leak , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Problem