SAP Knowledge Base Article - Preview

1867120 - How to solve warning message "Increase the config parameter 'number of open XXX' to avoid descriptor reuse." - SAP ASE

Symptom

Warning messages similar to the following appear in the database error log:

Increase the config parameter 'number of open partitions' to avoid descriptor reuse. Reuse may result in performance degradation.
Increase the config parameter 'number of open objects' to avoid descriptor reuse. Reuse may result in performance degradation.
Increase the config parameter 'number of open indexes' to avoid descriptor reuse. Reuse may result in performance degradation.

Or you had a dump with errro:

[ASE Error SQL8424][SAP][ASE ODBC Driver][Adaptive Server                       
     Enterprise]Cannot find an available index descriptor for an index. Increase                  
     the value of 'number of open indexes'. If sp_configure fails due to lack of                  
     index descriptors


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite (BS)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0 ; SAP Solution Manager 7.1

Keywords

KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

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.