SAP Knowledge Base Article - Preview

2961675 - Fatal Error 9840 occurred when importing data during system copy - SAP ASE on Business Suite

Symptom

Error 9840 reported both in application log and ASE log when importing data during system copy:

  • (DB) ERROR: DDL statement failed
    (CREATE  INDEX "SOOS~SRQ" ON "SOOS" ( "MANDT" , "SNDREQ"  ) 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.
  • 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 (SNDREQ). 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

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

   CR 822594, 822594, Fatal Error 9840, 9840, statistics hashing, create index , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.