nested exception is java.sql.BatchUpdateException: object name already exists: IDXITEMPK_14027SN in statement [ CREATE INDEX IdxITEMPK_14027Sn ON geolocationchan14027sn (ITEMPK)]

[Former Member]

getting this exception while initialization, What to do?

[satishchalla9090]

Hi,

This error is occurring because of typecode value. i also got the same error. i fixed it by changing the value of typecode. i see typecode value for your item is 14027. Please change this value to some other unique value and try build and update. this error will not be shown again.

[onat_guvenir]

I have solved this problem:

Caused by: java.sql.BatchUpdateException: object name already exists: QUALIFIER_10420 in statement [ CREATE INDEX qualifier_10420 ON order2consent (Qualifier)]

by drop table from db and change deployment table typecode. (10420 to 10421)

OR

You can disable audit tables for prevent creation tables like geolocationchan14027sn. It might be useful for case at above.

auditing.enabled=false

[Former Member]

Hi did you find a solution for this ?