Why does Hybris initialize seem to stop/pause while creating indexes on tables?

[former_member632070]

I am currently trying to reinitialize my Hybris platform. Have done this many times in past but today I am facing some issues now. The process seems to hang OR just stop all together.

There is an error being logged:

 CREATE INDEX orderRelIDX_2100 ON paymenttransactions (p_order)]; SQL state [null]; error code [17081]; error occurred during batching: ORA-00955: name is already used by an existing object
 [java] ; nested exception is java.sql.BatchUpdateException: error occurred during batching: ORA-00955: name is already used by an existing object

It seems hybris is having issue creating index that already exists. I do not see an index with such name existing. Also, I thought hybris would drop all existing objects in the database and recreate from scratch on an initialize so did not think an error like this could even occur.

[Former Member · Accepted solution]

Did you change the storage from hsql to Oracle ? or did you change the version of hybris ? to fix this there are couple of options :

1. write a procedure and manually drop the indexes.

2. drop the orale user (schema) and recreate it.

Please let me know if it helps.

[former_member632070 · Accepted solution]

Issue was resolved after I dropped schema and recreated.