JohnDanter2
VIP Member
Hi folks
I've had an issue for days which I've finally gotten to the bottom of but wanted to double check I am on the right track
I have a UBE under commitment control (Transaction Processing Enabled)
Am I right in thinking that if a set of DB transactions contains just ONE unique key violation, ALL other DB updates, deletes etc fail even when committed.
My UBE reads F41061 uploads from an excel file. I do various deletes and reinserts to F41061 (expire existing records by updating EXDJ to yesterday) using table IO (not B4100250)
At the end of my UBE I check an error flag and either commit or rollback the table IOs
I am experiencing an issue with updating existing F41061 records if there already is is a record there with yesterdays date.
So if we run my UBE today twice, then there will be a record already on the F41061 for MCU ITM AN8 UOM UORG EXDJ (EXDJ now = yesterday). If we then run it a second time for the same MCU ITM AN8 UOM UORG it tries to set EXDJ to yesterday again (already there) and so I get a unique key violation
So seen as EXDJ is part of the unique key, you have to copy, delete and reinsert F41061 wth an updated EXDJ
I think this ONE uniqiue key violation then totally ruins any other update, insert etc which may have been legit.
Am I right on this?
Thanks
John
I've had an issue for days which I've finally gotten to the bottom of but wanted to double check I am on the right track
I have a UBE under commitment control (Transaction Processing Enabled)
Am I right in thinking that if a set of DB transactions contains just ONE unique key violation, ALL other DB updates, deletes etc fail even when committed.
My UBE reads F41061 uploads from an excel file. I do various deletes and reinserts to F41061 (expire existing records by updating EXDJ to yesterday) using table IO (not B4100250)
At the end of my UBE I check an error flag and either commit or rollback the table IOs
I am experiencing an issue with updating existing F41061 records if there already is is a record there with yesterdays date.
So if we run my UBE today twice, then there will be a record already on the F41061 for MCU ITM AN8 UOM UORG EXDJ (EXDJ now = yesterday). If we then run it a second time for the same MCU ITM AN8 UOM UORG it tries to set EXDJ to yesterday again (already there) and so I get a unique key violation
So seen as EXDJ is part of the unique key, you have to copy, delete and reinsert F41061 wth an updated EXDJ
I think this ONE uniqiue key violation then totally ruins any other update, insert etc which may have been legit.
Am I right on this?
Thanks
John