Symptom
- Error 9840 reported both in application log and ASE log when importing data during system copy.
- From application <package>.log import file:
(DB) ERROR: DDL statement failed
(CREATE INDEX "<index_name>" ON "<table_name>" ( "<col1>" , "<col2>", .. "<col3>") with consumers = 3 , statistics hashing )
DbSlExecute: rc = 99
(SQL error 21)
error message returned by DbSl:
[ASE Error SQL21][SAP][ASE ODBC Driver][Adaptive Server Enterprise]WARNING - Fatal Error 9840 occurred at Aug 17 2020 2:08PM. Please note the error and time, and contact a user with System Administrator (SA) authorization.
- From ASE error log:
server WARNING - Fatal Error 9840 occurred at Aug 17 2020 11:24AM. Please note the error and time, and contact a user with System Administrator (SA) authorization.
server Error: 9840, Severity: 20, State: 10
server Internal hash based statistics collection error on column (<column>). Contact SAP Technical Support for help.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
CR 822594, 822594, Fatal Error 9840, 9840, statistics hashing, create index, R3load, import, TSK, ign , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed
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.
SAP Knowledge Base Article - Preview