Skip to Content
author's profile photo Former Member
Former Member

Unique Constraint issue while creating/duplicating the projects, auctions

Hi,

When the user tried to create a new Project or duplicate the Project. the below error occurs in the collaborator table and screen shot attached.

ORA-00001:unique constraint (ESOURCE.SYS_C0039064) violated

The issue is not occurring for all projects but sometimes it is throwing the error and points at one collaborator group and sometimes to another group or to the project owner itself.

Can anyone please throw some light on this. Appreciate your support on this.

Thank You

Vimal

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 23, 2013 at 04:41 PM

    The Oracle error containing this id SYS_C0039064 is not descript enough to determine the actual constraint from here. However ypour DBA might be able to determine which table and what the constraint is. Based on your description of the problem, it sounds like a constraint on the collaborator table. We do have some constraints on this list where the same collaborator can't appear more than once. If this is the case you need to check all the places where collaborators and groups are added. (Templates, document security templates etc..) I would start with getting the constraint from the DB itself and go from there.

    Regards,

    Gary

    Add a comment
    10|10000 characters needed characters exceeded


    • This seems as expected there appears to be an issue with collaborators. In this log, there are 2 examples one is the owner that is assigned via the document security template and the second is a group assigned also by the document security template. We should review the contents of the document security template for projects. You can provide screenshots of all content. Next, if you are using templates, we would have to look at the contents of these. Next who are the users in the group IPS Travel & Facilities. Last, is username=gsssisub actually the user Sirisha Subbarayadu? If we don't make progress on this soon, I would suggest filing a message with support.

      Regards,

      Gary

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.