Error Trying to Change Work Order Status to Closed

Problem(Abstract)

BMXAA4590E - Could not change Work Order XXXX status to CLOSE. BMXAA4129E - Record already exists for Site=TEST, Work Order=XXXX, Asset=YYYY.

Symptom

Unable to change work orders to closed status.

Cause

This can be caused by closing work orders via the application and then re-opening them via the database.

Diagnosing the problem

Run the following select statements:

Select * from ASSETHIERARCHY where wonum = 'XXXX' and siteid = 'TEST';

Select * from ASSETHISTORY where wonum = 'XXXX' and siteid = 'TEST';

If the work order is still open/completed but not closed there should be no rows in the database for the ASSETHIEARCHY table.

Resolving the problem

You can either update the row by adding a value to the wonum so that the row is retained for historical purposes.....

update assethierarchy set wonum = 'XXXXA' where wonum = 'XXXX'
and siteid = 'TEST' and assetnum = 'YYYY';

......or simply delete the row.

Return to the application and attempt to close the work order.