System update error for multi country addon in Oracle DB

[former_member621048]

Hi Team,

We recently added the multi country addon/extension to our 1811 version Hybris codebase on Oracle 18C. The addon works fine in HSQLDB.

However, on higher environment when the addon is deployed with the Oracle 18C, System update fails. We are getting the following error:

CREATE INDEX HYBRISproductRelIDX_20011 ON HYBRISproductavailassignment (p_product); CREATE INDEX HYBRISavailabilitygroupRelIDX_ ON HYBRISproductavailassignment (p_availabilitygroup)]; SQL state [null]; error code [17081]; error occurred during batching: ORA-00955: name is already used by an existing object nested exception is java.sql.BatchUpdateException: error occurred during batching: ORA-00955: name is already used by an existing object java.lang.IllegalStateException: problem executing sql [reason: StatementCallback; uncategorized SQLException for SQL [CREATE TABLE HYBRIScontextualattributevalue ( ITEMPK NUMBER(20,0), ITEMTYPEPK NUMBER(20,0), LANGPK NUMBER(20,0), p_name VARCHAR2(255 CHAR), p_description VARCHAR2(255 CHAR), PRIMARY KEY (ITEMPK, LANGPK)

There are multiple INDEX entries which throw the same error.

Any suggestions would be appreciated.