Reference Incident 1083912

Duplicate FW Entry on File#IC 202000027 - Grinchenko

Good morning,

Please update the FW to remove the duplicate FW entry for the following:

V40 – Non-accountable Incidentals

Thanks very much,

Cindy

Cindy Comeau
Senior Manager, Operations/Gestionnaire principale, Opérations
BGRS
T: +1.613.236.8727 | F: +1.613.236.1209

Troubleshooting

Login to 10.139.88.101\IRP

-- search transferee file using projectID as well as stCode provided in ticket
select * from plbudget where projectid='IC 202000027' and stcode='V40'

Per the output there is a duplicate claim.  The next step is to delete the oldest record.  You can tell the oldest records by referencing the update_dt

Resolution

use irp
begin tran
DELETE from plbudget
--select * from plbudget
where projectid = 'IC 202000027' and record_id in (16762740)
if @@ERROR > 0 or @@ROWCOUNT <> 1
BEGIN
ROLLBACK TRAN
RETURN
END
COMMIT TRAN