The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

PPM Organization Unit Interface report

SOLVED
Go to solution
Highlighted
ieroglif
Super Collector

PPM Organization Unit Interface report

Hello everyone.

 

 

We faced such a error while running PPM Organization Unit Interface report:

 

Message : ORA-00001: unique constraint (PPMADM.SYS_C008653) violated
ORA-06512: at "PPMADM.KRSC_ORG_UNITS_TRIG", line
11
ORA-04088: error during execution of trigger 'PPMADM.KRSC_ORG_UNITS_TRIG' {KRSC_ORG_UNITS
Exit Status : FAILURE

 

So, it's says about some unique value, what it may be, any ideas?

Recently everything was fine.

Best Regards,
Ieroglif.
2 REPLIES
Itay_Erhard
Acclaimed Contributor
Solution

Re: PPM Organization Unit Interface report

The org units table (krsc_org_units_nls) has a unique constraint on the org_unit_name column.

The  PPM Organization Unit Interface report tried setting this field's value to one that already exists, and as a result the constraint has been violated and the process failed. You need to incorporate logic to the script that populates the interface table to ensure uniquess of this field.

 

Alexander (Sua)
Regular Collector

Re: PPM Organization Unit Interface report

Hello

 

I get the following error message while executing this report

Unexpected error during request interface execution:
Message type: 20
Message name: ORACLE_ERROR
Message : ORA-06508: PL/SQL: impossible to call execution program block {KNTA_USER_INT-2089}
Exit Status : FAILURE
//Add this to "OnDomLoad" event