Unique Constraint issue while creating/duplicating the projects, auctions

[Former Member]

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

[former_member89217]

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

[Former Member]

Hi Gary,

Thanks for the information. I checked at the template and document security templates and i found there are no same collaborator appearing twice in the collaborator table. but the unique constraint issue is not occurring all the time when the user creates the project. but sometimes it occurs randomly when he tries to duplicate the project more than 5 times or 10 times or at the first time. Below screen shots will help you to understand the issue more clearly. Please assist us, as the issue is happening randomly for the last two months, earlier we didn't face like this type of problems in Projects and auctions.

Collaborator Table

Unique Constaint Issue

Thank You

Vimal

[former_member89217]

Have you identified the constraint yet?  Do you have an application log during a time period when the failure occurs? These screen shots aren't helpful in determining what the issue is. Once we know what constraint gets vilolated and what the application logs when the error occurs, we might be able to determine some next steps.

Regards,

Gary

[Former Member]

Hi Gary,

we are able to identify the constraint.Constraint name is ESOURCE.SYS_C0039064.

It is a unique constraint issue "ORA-00001:unique constraint (ESOURCE.SYS_C0039064) violated".  The constraint is used in FCI_DOC_COLLABORATOR table.

Also, we are not able to track this issue in the application logs as the error is due to database constraint issue. I am not sure whether if any other logs are available to track this

Thanks

Vimal

[Former Member]

Hi Gary,

i have attached the application logs. Please check the error.

eso.6.log.txt.zip

[former_member89217]

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