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.