SAP Knowledge Base Article - Preview

2454026 - DTP fails with SQL9573 on a failed YELLOW request - SAP Solution Manager on SAP ASE

Symptom

You are running Solution Manager 7.2 on SAP ASE 160 SP02 PL04 and above.

DTPs against Extractor Framework Infocubes fail with error: SQL code 9573.

  • Per SM21 system log:

    C  ERROR: -1 in function ExeNormalModify (execute) [line 28161]
    C  (9573) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]The server failed to create or
    C   update a row in table '/BI0/F0HDB_C05H' because the values of the row's partiti
    C  on-key columns do not fit into any of the table's partitions.
    C
    C  sql statement is ==> INSERT INTO "/BI0/F0HDB_C05H" VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
    C  , ? , ? , ? , ? , ? , ? )  plan '(use ins_by_bulk on)'
    C  /* R3:GP57AA9FDH59EH3F818
    C  QGWNVPUY:5554 T:/BI0/F0HDB_C05H M:300 */
    C
    B  ***LOG BY4=> sql error 9573   performing INS on table /BI0/F0HDB_C05H [dbdbslst     4806]
    B  ***LOG BY0=> [ASE Error SQL9573] [dbdbslst     4806]
    B  dumping DbDbslStatement ...
    B  DBSL_SS(  amode=DBSL_ACC_SL  stmtid_ptr=0   stmt=10be8c900  nlcb_ptr=0 )
  • ST22 short dumps indicate:

Category               Installation Errors
Runtime Errors         DBSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB

Short Text
    SQL error "SQL code: 9573" occurred while accessing table "/BI0/F0HDB_C05H".

  • There are no corresponding errors in the ASE errorlog
  • ASE "reorg rebuild" on the F-fact table does not clear the condition
  • BW compression of the Infocube does not clear the condition
  • The system has the latest version of both the BW Correction Collection note and SAP Note 2380231 applied.

If the SQL9573 is accompanied by SQL1105 errors in the ASE errorlog, please refer to KBA 2452627


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL04 for Business Suite
  • SAP Solution Manager (SOLMAN) 7.2

Product

SAP Solution Manager 7.2

Keywords

SQL9573, partition, infocube , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

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.