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 ONE Support launchpad (Login required).

Search for additional results

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