Markview 9.1 Upgrade with EBS R12.2 error - ORA-00955: name is already used by an existing object - mvaa_auto_act_rule_type_tab.sql

Applies To

• ERP System: R12.2.x
• MarkView Version: 9.1

Behavior

• When Markview Version 9.1 installer is run, the following similar error is encountered:

  2017-01-16 13:45:08,402 DEBUG com.markview.common.db.SqlPlusEmulator Executing the following sql script: [/projects/wl01/home/mvwl01/mvdist91/installer/modules/automated-actions-dist-9.1.0/automated-actions- db/schema/tables/mvaa_auto_act_rule_type_tab.sql].
  2017-01-16 13:45:08,414 ERROR com.markview.common.db.SqlPlusEmulator Unexpected error while executing sql script.

  java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
      at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
      at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

Known Causes

• The Pre-Upgrade Task: 'Deleting MarkView Synonyms for Advisor (Oracle EBS 12.2 Only)' was skipped.

Resolution

• Complete the Pre-Upgrade Task: 'Deleting MarkView Synonyms for Advisor (Oracle EBS 12.2 Only)' as per the Markview 9.1 Upgrade Guide.
• Run the Markview 9.1 Installer again and then verify it completes.

Keywords: mvaa_auto_act_rule_type_tab.sql