Error occurred during batching: ORA-00955: name is already used by an existing object

[Former Member]

Hello Experts ,

I am working on hybris up gradation from 6.5 to 6.6. Successfully done build and Server start up. But while doing system update i am getting Below Exception .

I ran below query in SQL Dev also to remove indexes .

SET HEAD OFF; spool drop_index.sql select 'DROP INDEX ' ||OWNER|| '.' ||INDEX_NAME|| ';' from dba_indexes where owner='B2BPROD000' and index_type != 'LOB' AND index_name NOT IN (SELECT unique index_name FROM dba_constraints where owner='B2BPROD000' and index_name IS NOT NULL); spool off;

Need Some help from you all . Thanks in Advance.

; CREATE INDEX IdxITEMPK_2201Sn ON facsearchconfca2201sn (ITEMPK); CREATE INDEX IdxsourcePK_2201Sn ON facsearchconfca2201sn (sourcePK); CREATE INDEX IdxtargetPK_2201Sn ON facsearchconfca2201sn (targetPK); CREATE INDEX IdxlanguagePK_2201Sn ON facsearchconfca2201sn (languagePK); CREATE OR REPLACE TRIGGER trg_facsearchconfca2201sn_ID BEFORE INSERT ON facsearchconfca2201sn FOR EACH ROW WHEN (new.ID IS NULL) BEGIN SELECT seq_facsearchconfca2201sn_ID.nextval INTO :new.ID FROM dual; END;; CREATE SEQUENCE seq_facsearchconfcu2202sn_ID; CREATE TABLE facsearchconfcu2202sn ( ID NUMBER(20,0) , ITEMPK NUMBER(20,0), ITEMTYPEPK NUMBER(20,0), timestamp TIMESTAMP(3), currenttimestamp TIMESTAMP(3), changinguser VARCHAR2(255 CHAR), context CLOB, payloadbefore CLOB, payloadafter CLOB, operationtype NUMBER(20,0), sourcePK NUMBER(20,0), targetPK NUMBER(20,0), languagePK NUMBER(20,0), PRIMARY KEY (ID) ); CREATE INDEX IdxITEMPK_2202Sn ON facsearchconfcu2202sn (ITEMPK); CREATE INDEX IdxsourcePK_2202Sn ON facsearchconfcu2202sn (sourcePK); CREATE INDEX IdxtargetPK_2202Sn ON facsearchconfcu2202sn (targetPK); CREATE INDEX IdxlanguagePK_2202Sn ON facsearchconfcu2202sn (languagePK); CREATE OR REPLACE TRIGGER trg_facsearchconfcu2202sn_ID BEFORE INSERT ON facsearchconfcu2202sn FOR EACH ROW WHEN (new.ID IS NULL) BEGIN SELECT seq_facsearchconfcu2202sn_ID.nextval INTO :new.ID FROM dual; END;; CREATE SEQUENCE seq_facsearchconfla2203sn_ID; CREATE TABLE facsearchconfla2203sn ( ID NUMBER(20,0) , ITEMPK NUMBER(20,0), ITEMTYPEPK NUMBER(20,0), timestamp TIMESTAMP(3), currenttimestamp TIMESTAMP(3), changinguser VARCHAR2(255 CHAR), context CLOB, payloadbefore CLOB, payloadafter CLOB, operationtype NUMBER(20,0), sourcePK NUMBER(20,0), targetPK NUMBER(20,0), languagePK NUMBER(20,0), PRIMARY KEY (ID) ); CREATE INDEX IdxITEMPK_2203Sn ON facsearchconfla2203sn (ITEMPK); CREATE INDEX IdxsourcePK_2203Sn ON facsearchconfla2203sn (sourcePK); CREATE INDEX IdxtargetPK_2203Sn ON facsearchconfla2203sn (targetPK); CREATE INDEX IdxlanguagePK_2203Sn ON facsearchconfla2203sn (languagePK); CREATE OR REPLACE TRIGGER trg_facsearchconfla2203sn_ID BEFORE INSERT ON facsearchconfla2203sn FOR EACH ROW WHEN (new.ID IS NULL) BEGIN SELECT seq_facsearchconfla2203sn_ID.nextval INTO :new.ID FROM dual; END;; CREATE SEQUENCE seq_format13113sn_ID]; 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

     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:90) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
     at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:606) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
     at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeBatch(DefaultDbScriptsExecutor.java:142) ~[ybootstrap.jar:?]
     ... 150 more

Caused by: java.sql.BatchUpdateException: error occurred during batching: ORA-00955: name is already used by an existing object

     at oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:4615) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0]
     at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0]
     at de.hybris.platform.jdbcwrapper.StatementImpl.executeBatch(StatementImpl.java:481) ~[coreserver.jar:?]
     at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:567) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
     at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:554) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
     at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:606) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
     at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeBatch(DefaultDbScriptsExecutor.java:142) ~[ybootstrap.jar:?]
     ... 150 more

[geffchang]

There are so many questions on ORA-00555. Have you tried checking them? https://experts.hybris.com/search.html?f=&type=question+OR+idea&redirect=search%2Fsearch&sort=releva...

This one has a lot of answers: https://answers.sap.com/questions/12761441/ora-00955-name-is-already-used-by-an-existing-obje-1.html

Also, if you found the solution, you can post it as Answer. :)

[Former Member]

Hi,

I found like dropping index tables it may fix the issues. But it did not help after deleting the index . Please let me know if you have any fix :) Thanks

[geffchang]

Can you specify the exact 6.6 version you are using - 6.6.x.y?

[Former Member]

Its version=6.6.0.8 version.api=6.6.0