2040888 - Error 12034: Collection of monitoring data for table 'monCachedObject' failed due to insufficient memory. - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2040888 - Error 12034: Collection of monitoring data for table 'monCachedObject' failed due to insufficient memory. - SAP ASE

Symptom

  • Error 12034 is printed in the errorlog file, when running transaction SM21 and in client application:

server  Error: 12034, Severity: 17, State: 1
server  Collection of monitoring data for table 'monCachedObject' failed due to insufficient memory.
Retry when there is less load, or fewer users, on the server. 27147 rows were not returned because 651528 bytes of memory could not be allocated.

  • Sample client output from isql shows also same error:
select * into CachedObject from master..monCachedObject
go

Msg 12034, Level 17, State 1:
Server '<Server name>', Line 1:
Collection of monitoring data for table 'monCachedObject' failed due to insufficient memory.
Retry when there is less load, or fewer users, on the server. 27147 rows were not returned because 651528 bytes of memory could not be allocated.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition

Keywords

CR779750, 779750, "max memory", global, fragment, pool, CR#779750, monCachedObjects, monStatementCache , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.