VERIFIED SOLUTION i

How to resolve the STREET_REINSTATE_FK1_REINSTATE error when running the NSG Import in Confirm

Product Feature: Confirm
                            Asset Register

Issue

In Confirm the NSG Import is failing when creating a Reinstatement. Here is the error message:

22/09/2016 20:35:30 Create reinstatement
"SQLSTATE = 23000 [Oracle][ODBC][Ora]ORA-02291: integrity constraint (<custom_prefix>_HIGHWAYS.STREET_REINSTATE_FK1_REINSTATE) violated - parent key not found "

This error message is from an Oracle-based Confirm system, however a similar error may be reported by SQL Server.

Cause

Please analyse the data within the Import file. It’s likely to be missing a Reinstatement_Code.

Resolution

UPDATED: March 29, 2017
If possible create a new import file containing the missing Reinstatement_Code, else please raise a new Confirm Technical Support case, providing the NSG Import file if possible.