Toad World® Forums

Team coding: ORA-00604 and ORA-00001

Hi,

Trying to install Team Coding to the database and have run into the below errors when I view output having run the installation script -

ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_DEFROLE1) violated

I have attached a screen shot of this.

Thanks,

Gavin

Hi Gavin,

Based on your screenshot, it looks like you're trying to install Team Coding using the SYS user and there are already a lot of default roles defined. It's possible there is a duplicate role in the list of default roles in that ALTER statement. There's an Oracle support document that talks about this kind of error:

https://support.oracle.com/knowledge/Oracle%20Database%20Products/2615078_1.html

I would take a look at the roles listed in that ALTER statement to see if there are any duplicate roles defined in the list. You can see this by selecting "Create Install Script for Database" in the Team Coding Configuration window. Alternatively, another way around this would be to install Team Coding to the TOAD schema using a different user who has DBA privileges or privileges to create objects in other schemas.

I hope this information helps in identifying the cause of the issue in your environment. Please feel free to let us know if you run into any other issues.

-John

Hey John,

Thank you for your reply and thorough explanation.

I used an alternative user with DBA privileges and TC was installed successfully!

Best wishes,

Gavin