On loading inventory stage 2 Constraint violated


	Applies To

	Product(s):	Exor UKPMS
	Version(s):	04.05.00.00
	Environment:	N/A
	Area:	Inventory Loading
	Subarea:
	Original Author:	Bentley Technical Support Group

Error or Warning Message

On loading stage 2 the error message is appearing:

Error: Occured In process_ukp_assets While Inserting LJ Assets From HHINV_LOAD_2

ORA-00001: unique constraint (HIGHWAYS.UKPMS_LJ_PK) violated

ORA-00001: unique constraint (HIGHWAYS.UKPMS_LJ_PK) violated in "...' on line 0 of

Solution

Exor metadata is misconfigured. Open MAI1400 form for the asset type whose constrain was violated.

In this case it is ‘LJ’. Check what are sequences of ‘LJ’ asset type (‘Check DCD’ button on MAI1400 form).

Make changes as is shown below:

Recommended