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

[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

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite (BS)
  • SAP Adaptive Server Enterprise (ASE) 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

Error 8424, Msg 8424, descriptors, avoid descriptor reuse, number of open , 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.