Project and Portfolio Management Practitioners Forum
cancel

ERROR WHEN COPYING A WORKFLOW IN WORKBENCH

SOLVED
Go to solution
Highlighted
NTI-APPS
Valued Contributor.

ERROR WHEN COPYING A WORKFLOW IN WORKBENCH

Hi,

 

I am trying to copy an existing workflow but is encountering an error:

ORA-00001: unique contraint (PPMC.SYS_C0030757)
violated
ORA-06512: at "PPMC.KNTA_NOTIFICATIONS_TRIG",line
11
ORA-04088: error during execution of trigger
'PPMC.KNTA_NOTIFICATIONS_TRIG'
{KNTA_NOTIFICATIONS_CP-150}
GUID=79834BE5-214D-0A83-088E-35E06CB9E33C

I noticed that when i remove the notifications from the components that would be copied along with the workflow, i do not encounter this error. But the notifications is one of the most critical components in my workflow.

 

I am using PPM v9.14

 

Thanks.

Lester

 

3 REPLIES
Jason Nichols K
Acclaimed Contributor.

Re: ERROR WHEN COPYING A WORKFLOW IN WORKBENCH

The only Unique Constraint I can find on the KNTA_NOTIFICATIONS_NLS table is for the REFERENCE_CODE and the error obviously comes from the KNTA_NOTIFICATIONS_CP package at sql_num 150.  That part of the code is where it inserts the new notification data into the table.  However, there are no references to the REFERENCE_CODE column in either the insert or the cursor that gathers the data from the source notification.  I would suggest bringing this to the attention of HP Support to get a defect logged.

Kerim KILIC
Honored Contributor.
Solution

Re: ERROR WHEN COPYING A WORKFLOW IN WORKBENCH

i think you have same event notification in one step, because of that you get that error.

NTI-APPS
Valued Contributor.

Re: ERROR WHEN COPYING A WORKFLOW IN WORKBENCH

Hi Kerim,

 

This is confirmed,  I was able to isolate the cause yesterday.. I have a notification that was doubled and has the same recipient.

 

 

Thanks!

 

Lester