ORA-01427 error is appearing on running Automatic Pass


 Product(s):Exor UKPMS
 Version(s):04.05.00.00
 Environment:N/A
 Area:Automatic Pass
 Subarea:N/A

Problem Description

On running UKPMS Automatic Pass the error message appeared : “Unknown error in Init Rating Defects to Inv .Debug info : ORA-01427: single-row subquery returns more than one row at point 1”

Steps to resolve

One of reasons causing this error is the duplicated inventory have been created in the system.

It happens when the same data the same sections within the same chainages have been loaded into the system twice.

To delete the duplicated inventory from the system run UKPDUPINV module from Fastpath and run Automatic Pass again.

 Original Author:Renatas M