Skip to main content
Kofax

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

Summary

13652

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

  • Was this article helpful?