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