Skip to Content
0
Jan 24, 2018 at 03:21 PM

Delta Merge Error in Hana 1.0 SP12

1093 Views

Hi All,

I am very new to hana from DB2 background and i have an issue please help

This query:

SELECT * FROM CTR_PARM WHERE CTR_PARM.PARM_SBJ IN ('BDV_AD_BH_PD_AC_TRSR','BDV_AD_BHS_PYMT_AC_RISK_CLASS') AND VAL_TP = 'S'

Delivers 2 rows while this query:

SELECT * FROM CTR_PARM WHERE CTR_PARM.PARM_SBJ IN ('BDV_AD_BH_PD_AC_TRSR','BDV_AD_BHS_PYMT_AC_RISK_CLASS') AND VAL_TP = 'S' AND PARM_CODE = 'FULL_LOAD'

Delivers 4 rows!!!!

We tried MERGE DELTA OF MD.CTR_PARM to make sure it was not a problem with the delta cache but this wasn’t successful:

MERGE DELTA OF MD.CTR_PARM

Could not execute 'MERGE DELTA OF MD.CTR_PARM' in 13 ms 467 µs . SAP DBTech JDBC: [2048]: column store error: merge delta index error: [2487] table optimization was not possible due to open metadata changes;delta merge