EAM-55195 CLONE - Positions | Change Equipment Number - Failed to change equipment number if the equipment has record in table "R5EQUIPMENTRANKINGHISTORY" - HxGN EAM - Version 12.0 - Hexagon

HxGN EAM Resolved Issues for 2022

Language
English
Product
HxGN EAM
Search by Category
HxGN EAM Version
12

EAM-55195 CLONE - Positions | Change Equipment Number - Failed to change equipment number if the equipment has record in table "R5EQUIPMENTRANKINGHISTORY"

 Description 

customer reported that they cannot do Change Equipment Number on particular positions but hit error "The system failed to carry out this function because of the environment or configuration problems."

I had traced the action in database background and found that the stored procedure "dbo.o7upobj1" was called and hit error 'The DELETE statement conflicted with the REFERENCE constraint "R5FOK1_ERH". The conflict occurred in database "EAMTEST", table "dbo.R5EQUIPMENTRANKINGHISTORY".'

after I manually deleted the position from table "dbo.R5EQUIPMENTRANKINGHISTORY", I can do Change Equipment Number on this position successfully and no more above error.

EAM-55196 CLONE - PM Schedules - Error change revision control status after 11.6 upgrade