Home Discussions Questions & Answers Unique Constraint Violation during Package Recompile

Unique Constraint Violation during Package Recompile

Avatar photoCustomer August 17, 2024 at 5:14 pm

Our installation log shows ORA-00604: error occurred at recursive SQL level 1 and ORA-00001: unique constraint (SYS.I_OBJAUTH1) violated when re-compiling a package. What is the cause and the manual workaround?

Viewing 2 reply threads
  • Author
    Replies
    • Support August 18, 2024 at 8:03 pm  

      This violation occurs during recursive SQL execution while granting privileges in the compilation process. The solution is to manually drop and recreate the failing package.

    • Avatar photoCustomer August 20, 2024 at 5:34 am  

      If the package is `XXEN_UTIL`, what are the steps?

    • Support August 22, 2024 at 2:52 am  

      You must connect as APPS and execute `drop package XXEN_UTIL;`, followed by running the package specification and body scripts (`@XXEN_UTIL.pks` and `@XXEN_UTIL.pkb`) from the installer’s SQL directory.

Viewing 2 reply threads
  • You must be logged in to reply to this post.

Login with: