Symptom
- You are running Solution Manager 7.2 on SAP ASE database.
- The system has the latest version of both BW Correction Collection Note and SAP Note 2380231 applied.
- InfoCube loading fails with 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.
From ST22 short dump:
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/F<InfoCube>".
You may also see short dump as:
Call program...........CL_E2EEFWK_ME_LUW_DB_CORE=====CP
Function module..... SMD_DATA_LOADER255 - There are ASE errors which lead to the failure of partition creation such as:
Error: 1105, Severity: 17, State: 16
Can't allocate space for object '/BI0/F<InfoCube>' in database '<SID>' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log.
Otherwise, use ALTER DATABASE to increase the size of the segment.
Error: 1795, Severity: 20, State: 5
ALTER TABLE' failed because the dataserver was unable to allocate space for deferred table '<table_name>' in database '<SID>'.
Read more...
Environment
- SAP Solution Manager (SOLMAN) 7.2
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.2
Keywords
sql error 9573, partition, CX_SY_OPEN_SQL_DB, WRITE_ICFACT , 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.