SAP Knowledge Base Article - Preview

3575369 - SAP HANA database schema export error: (dberror) [2048]: column store error: export failed: [30182] Export aborted due to failed delta-merge

Symptom

A schema export fails with this error:

"The requested backend service did not succeed (dberror) [2048]: column store error: export failed: [30182] Export aborted due to failed delta-merge. table;/XXXSHARE/XXX_EXPORT/20250203/index/XXX_FC_01/TD/TDVWXXX0TJKRL,object=XXX::XXX_FC_01:TDVWXXX0TJKRLen,location=XXXXXXXXX: XXXXX 

In the SAP HANA indexserver trace file you can see this errors:

1735337]\{325745\}[-1/-1] 2025-02-03 07:54:42.516336 e PersistenceLayer StorageLocationManager.cpp(00375) : copy of IXXX_FC_01T8XXXX0FVVZJTD$container$ to /XXXSHARE/XXX_EXPORT/20250203/index/XXX_FC_01/T8/T8OXXXXFVVZJT/$container$ failed with rc = 30182
[1735337]\{325745\}[-1/-1] 2025-02-03 07:54:42.516382 e ImportExport     ImportExport.cpp(13896) : Could not export data, indexId: XXX::XXX_FC_01:T8XXXXXFVVZJT (t 10333460)
[1735337]\{325745\}[-1/-1] 2025-02-03 07:54:42.516410 e ImportExport     ImportExport.cpp(07390) : Export binary raw failed for column table: XXX::XXX_FC_01:T8OTXXXXVVZJT (t 10333460), at: IT8OXXXXFVVZJT
[1735337]\{325745\}[-1/-1] 2025-02-03 07:54:42.516459 e ImportExport     ImportExport.cpp(15492) : export of XXX::XXX_FC_01:T8OXXXXFVVZJT (t -1) failed: Export aborted due to failed delta-merge. Please re-load table and then try to export the table;/XXXSHARE/XXX_EXPORT/20250203/index/XXX_FC_01/T8/T8OXXXXFVVZJT

The diagnostic SQL statement HANA_Tables_DataCollector_2.00.0XX+ of the SQLStatements.zip of SAP Note 1969700 - SQL Statement Collection for SAP HANA shows a 2489 delta merge error

6;***********************                                                                                                                                                                                 
47;* TABLE OPTIMIZATIONS *                                                                                                                                                                                 
48;***********************                                                                                                                                                                                 
49;                                                                                                                                                                                                        
50;OPTIMIZATION_TIME   SCHEMA_NAME TABLE_NAME           HOST         TYPE           MOTIVATION MERGED_ROWS RUNTIME_S  RW_S P1_HLW_S P1_BLW_S P1_L_S P2_HLW_S P2_BLW_S P2_L_S LAST_ERROR                    
51;=================== =========== ==================== ============ ============== ========== =========== ========= ===== ======== ======== ====== ======== ======== ====== ==============================
52;2025/01/23 20:22:10 XXX_FC_01   TDVXXXXXTJKRL        XXXXXXXdb01 MERGE          AUTO                 0      0.50     0        0        0      0        0        0      0 2048 column store error: [2489


Read more...

Environment

SAP HANA 2.0

Keywords

The requested backend service did not succeed (dberror) [2048]: column store error: export failed: [30182] Export aborted due to failed delta-merge,  Export aborted due to failed delta-merge. Please re-load table and then try to export the table , KBA , HAN-DB , SAP HANA Database , HAN-DB-ENG , SAP HANA DB Engines , 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.