ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins. Read more for important details.
ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins.Read more for important details.
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class
993 views

PPM Organization Unit Interface report

Jump to solution

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.
0 Likes
1 Solution

Accepted Solutions
Lieutenant Commander
Lieutenant Commander

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.

 

View solution in original post

2 Replies
Lieutenant Commander
Lieutenant Commander

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.

 

View solution in original post

Absent Member.
Absent Member.

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
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.