SAP Knowledge Base Article - Preview

2452627 - InfoCube loading fails with ASE Error SQL9573 and SQL1105 - Solution Manager on SAP ASE

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