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
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.