SAP Knowledge Base Article - Preview

2675991 - DTP / load of Infocubes 0SMD_EA1H and 0SMD_EA2H fails with SQL9573 - Solution Manager on SAP ASE

Symptom

  • DTP / Data Loads  into Infocubes 0SMD_EA1H and 0SMD_EA2H on Solution Manager systems running on SAP ASE, fail with error SQL9573.

ST22 ABAP short dump
===============

Category Installation Errors
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 15.10.2018 06:00:07
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Short Text |
| SQL error "SQL code: 9573" occurred while accessing table "/BI0/F0SMD_EA1H". |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|What happened? |
| Database error text: "SQL message: [ASE Error SQL9573]" |
----------------------------------------------------------------------------------------------------

  • In dev_w<WPid> trace file:

==================

C  ERROR: -1 in function ExeNormalModify (execute) [line 26967]
C  (9573) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]The server failed to create or
C   update a row in table '/BI0/F<InfoCube>' because the values of the row's partiti
C  on-key columns do not fit into any of the table's partitions.

  • There are no corresponding errors in the SAP ASE errorlog. The cause and solution cited in SAP KBA 2452627  do not apply.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • Solution Manager 7.1 / 7.2

Product

SAP Solution Manager 7.2

Keywords

SQL9573, 0SMD_EA1H, 0SMD_EA2H, "Solution Manager", EFWK, fact tables,  compression, infocube, data load, DTP, compress , 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.