Error: “Missing index: annoToEventRefIdx in table: (table_name) in column: (Column_Name). This column already has an index with different name!”

Running the Upgrade Wizard on BSM 9.13 server the upgrade process stuck at Event schema upgrade and shows error (log upgrade):

"Missing index: annoToEventRefIdx in table: (table_name) in column: (Column_Name). This column already has an index with different name!"

More details:

2012-10-09 15:23:54,389 [pool-2-thread-1] (SimpleSqlStatement.java:40) ERROR – SQL Statement failed: Following sql statement failed:ALTER TABLE EVENT_FORWARDING_INFO ADD(ID VARCHAR2(255 CHAR)) — [mercury][Oracle
JDBC Driver][Oracle]ORA-01430: column being added already exists in table

2012-10-09 15:23:54,389 [pool-2-thread-1] (Step.java:96) ERROR – Task execution failed

com.mercury.infra.flowmngr.exceptions.TaskExecutionException: java.sql.SQLException: Following sql statement failed:ALTER TABLE EVENT_FORWARDING_INFO ADD(ID VARCHAR2(255 CHAR))

Caused by: java.sql.SQLException: Following sql statement failed:ALTER TABLE EVENT_FORWARDING_INFO ADD(ID VARCHAR2(255 CHAR))

Caused by: java.sql.SQLSyntaxErrorException: [mercury][Oracle JDBC Driver][Oracle]ORA-01430: column being added already exists in table

This issue happens, because before the upgrade be performed, the checkIndices.bat tool need be execute it, for check the changes in the Event DB.

The checkIndices.bat tool is located in, HPBSM\opr\support\checkIndices.bat

If this tool wasn’t execute in BSM 9.0x when the upgrade check the indices in the Event schema, this issue will show up because need the indices for continue working.

To fix this issue, please follow these steps:

1-) Run the CheckIndices.bat tool, in the command prompt with the parameter -v, like this:

HPBSM\opr\support>CheckIndices –v

This is for check what are the issues related to the indices in the Event schema.

After run this tool, you will see something like this, in case that the schema has issues.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s