3658306 - sql error "sql code: 129" occurs during dtp execution in sap hana

• ST22 dump indicates SQL error "SQL code: 129" occurred while accessing BW table. 
  • DBSQL_SQL_INTERNAL_DB_ERROR with exception CX_SY_OPEN_SQL_DB
  • Database error text: "SQL message: transaction rolled back by an internal error:
    An unexpected error occurred. For further information on this error
    search SAP notes for one of the following tags: loc=XXXXX,
    ctx=XXXXX.

• Indexserver trace contains messages like:

  • e partitioning     DynamicRange.cpp(00779) : SQL preparation or execution of

    'ALTER TABLE <BW_table> DROP EMPTY PARTITIONS'
    failed:
    column store error: drop empty ranges: [2999] Internal error: Number of partitions and partition specification do not match.;object=XXXXX at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_metadata.cc:1645
    ERROR [SQL-2048] column store error: drop empty ranges: [2999] Internal error: Number of partitions and partition specification do not match.;object=XXXXX at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_metadata.cc:1645
    exception  1: no.71002048  (ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_metadata.cc:1645) TID: 32998
        drop empty ranges: [2999] Internal error: Number of partitions and partition specification do not match.;object=XXXXX

  • E SQLUpdate        PartitionMap.h(00067) : The following assertion failed: partId != TRexConfig::Partitioning::invalidPart && partId < partitionInfos.size()
    unexpected condition

  • e EmbeddedAPI      EAPICommon.cc(00153) : [SQL-129] unexpected exception at handlelttException_: exception=exception  1: no.2120042  (PartitionMap.h:67) TID: 10542
        An unexpected error occurred. For further information on this error search SAP notes for one of the following tags: loc=XXXXX, ctx=XXXXX. If you don't find an according note, open a support ticket and include the trace files containing correlation id XXXXX.

• Report RSDU_TABLE_CONSISTENCY reported "Table Placement expected but not maintained"

SAP HANA, platform edition

sql error, sql code 129, dtp execution, dbsql_sql_internal_db_error, cx_sy_open_sql_db, table inconsistency, partition mismatch, rsdu_table_consistency, table_placement, sap hana, adso activation, sap bw. , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , HAN-DB , SAP HANA Database , HAN-DB-ENG , SAP HANA DB Engines , Problem