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.