HCO_HBA_R_SB_CORE Installation Error

[Former Member]

Hi All,

Our system is running on S/4 HANA on premises 1503 and with HANA SPS10.

I tried to install HCO HBA R SB CORE but it seems it shows an error, as such:

--- Tue Nov 03 11:35:46 2015 ---
Process with ID: INSTALL_SOFTWARECOMPONENTS_2015-11-03T03:35:02.0860000Z started.

--- Tue Nov 03 11:37:47 2015 ---
Content error: Activation of at least one object failed

--- Tue Nov 03 11:37:47 2015 ---
Content error: Object: sap.hba.r.sb.core.db.INDICATOR_TEXTS_A826B657C3F147D4962296D2C974FD8C49B19EB8F02238FB696A7821E51ADD34.hdbti ==> Error Code: 40211

--- Tue Nov 03 11:37:47 2015 ---
Content error: Table import constraint checks failed. found overlapping key usage with {package: sap.hba.r.sfin700.db, name: INDICATOR_TEXTS_11E38BF24D48EA9A129A3ECBB0F9BCFE79FA4D414A03EA4819A0BCB720D5E67B, suffix: hdbti}: define distinct key areas.

--- Tue Nov 03 11:37:47 2015 ---
Content error: Object: sap.hba.r.sb.core.db.INDICATORS_A826B657C3F147D4962296D2C974FD8C49B19EB8F02238FB696A7821E51ADD34.hdbti ==> Error Code: 40211

--- Tue Nov 03 11:37:47 2015 ---
Content error: Table import constraint checks failed. found overlapping key usage with {package: sap.hba.r.sfin700.db, name: INDICATORS_11E38BF24D48EA9A129A3ECBB0F9BCFE79FA4D414A03EA4819A0BCB720D5E67B, suffix: hdbti}: define distinct key areas.

--- Tue Nov 03 11:37:47 2015 ---
Content error: Object: sap.hba.r.sb.core.db.EVALUATION_TEXTS_DA1FC4D9C41D163C131872713BEF5D66954F11DA6BBC922F433056E46380B06D.hdbti ==> Error Code: 40211

--- Tue Nov 03 11:37:47 2015 ---
Content error: Table import constraint checks failed. found overlapping key usage with {package: sap.hba.r.sfin700.db, name: EVALUATION_TEXTS_1C886A03C3321999C3C82D5EA169863E753F90C908E3618D7E44643C2A732E83, suffix: hdbti}: define distinct key areas.

--- Tue Nov 03 11:37:47 2015 ---
Content error: Object: sap.hba.r.sb.core.db.EVALUATIONS_DA1FC4D9C41D163C131872713BEF5D66954F11DA6BBC922F433056E46380B06D.hdbti ==> Error Code: 40211

--- Tue Nov 03 11:37:47 2015 ---
Content error: Table import constraint checks failed. found overlapping key usage with {package: sap.hba.r.sfin700.db, name: EVALUATIONS_1C886A03C3321999C3C82D5EA169863E753F90C908E3618D7E44643C2A732E83, suffix: hdbti}: define distinct key areas.

--- Tue Nov 03 11:37:47 2015 ---
Content error: Object: sap.hba.r.sb.core.db.CHIP_TEXTS_B8C89D203330A495E54B177B689EAD7765BC818ACC031209D8F7B7706FB11D5D.hdbti ==> Error Code: 40211

--- Tue Nov 03 11:37:47 2015 ---
Content error: Table import constraint checks failed. found overlapping key usage with {package: sap.hba.r.sfin700.db, name: CHIP_TEXTS_0D0401745F35372D588B3587DA770862BEA094745F9C870EE17BE7AAA3C6E148, suffix: hdbti}: define distinct key areas.

--- Tue Nov 03 11:37:47 2015 ---
Content error: Object: sap.hba.r.sb.core.db.CHIP_TEXTS_5AF94A62E9A4A0486D7C95625E896B045BB7C5EAC8C957069242E70D74A5DF8E.hdbti ==> Error Code: 40211

--- Tue Nov 03 11:37:47 2015 ---
Content error: Table import constraint checks failed. found overlapping key usage with {package: sap.hba.r.sfin700.db, name: CHIP_TEXTS_0D0401745F35372D588B3587DA770862BEA094745F9C870EE17BE7AAA3C6E148, suffix: hdbti}: define distinct key areas.

--- Tue Nov 03 11:37:47 2015 ---
Content error: Object: sap.hba.r.sb.core.db.CHIPS_B8C89D203330A495E54B177B689EAD7765BC818ACC031209D8F7B7706FB11D5D.hdbti ==> Error Code: 40211

--- Tue Nov 03 11:37:47 2015 ---
Content error: Table import constraint checks failed. found overlapping key usage with {package: sap.hba.r.sfin700.db, name: CHIPS_0D0401745F35372D588B3587DA770862BEA094745F9C870EE17BE7AAA3C6E148, suffix: hdbti}: define distinct key areas.

--- Tue Nov 03 11:37:47 2015 ---
Content error: Object: sap.hba.r.sb.core.db.CHIPS_5AF94A62E9A4A0486D7C95625E896B045BB7C5EAC8C957069242E70D74A5DF8E.hdbti ==> Error Code: 40211

--- Tue Nov 03 11:37:47 2015 ---
Content error: Table import constraint checks failed. found overlapping key usage with {package: sap.hba.r.sfin700.db, name: CHIPS_0D0401745F35372D588B3587DA770862BEA094745F9C870EE17BE7AAA3C6E148, suffix: hdbti}: define distinct key areas.

--- Tue Nov 03 11:37:47 2015 ---
Content error: Import of software component versions failed.

--- Tue Nov 03 11:37:47 2015 ---

Process INSTALL_SOFTWARECOMPONENTS_2015-11-03T03:35:02.0860000Z failed.

so, in the end I put install -o USE_ALWAYS_COMMIT_ACTIVATION and it did install but now it does not work well since I can't loan the KPI tiles (shown "cannot load tile"). I've assigned the required privilege for both front and back end and in HANA.

The error that I'm getting is

Error (404, Not found) in OData response for GET "/sap/hba/r/sb/core/odata/runtime/SMART_BUSINESS.xsodata;o=HANA/Catalogs('HANA_CATALOG')/Chips": HTTP request failed

I tried to reinstall back the HCO HBA R SB CORE but it says the package already exist, so should I delete the DU and re-install back but I'll have the same issue again as above?

btw is it save to delete the DU from /sap/hana/xs/lm and re-install back? or there is a better way to remove DU?

any intake on how to fix this?

thanks

[onno_bagijn · Accepted solution]

Hi,

Please apply the instructions of note 2158380 "Activation of .hdbti object Fails with Error "Found overlapping key usage with {tenant: , package: ..., name: ..., suffix: hdbti} define distinct key areas" is this error appears. Which means redeploy manually the hdbti files per target table. Once this is done all Smart Business reuse content and sFin content is activated and ready to use.

BR, Onno

[former_member188396 · Accepted solution]

This message was moderated.

[harshita_chaubey · Accepted solution]

This message was moderated.