Issue:

Data records were being exported multiple times to an external system, resulting in duplicate entries. This caused operational issues such as the need to manually cancel or correct hundreds of duplicated transactions.

Cause:

The issue occurred because error messages related to missing vehicles during previous export attempts were not properly set. As a result, once the missing vehicle was created, the system reprocessed the same data sets, including those that had previously failed, leading to multiple duplicate exports.

Resolution:

To resolve the issue, the following steps were taken:

• Corrected the handling of error messages for missing vehicles so that failed records are not reprocessed unnecessarily.

• Marked the affected data records as exported and removed them from the processing view to prevent further duplication.

• Monitored the export process to confirm that no additional duplicate transmissions occurred.

• Escalated the case to the development team to investigate the root cause and implement measures to prevent recurrence.

Needed Queries:

Check one of the Bol's in IBOBDATA

select top 100 * from TBL_IBOBDATA 
where REFTYPE = 'SAPOUTBOUND_CMASAP'
and LOCALSTAMP > '20260506'
and CONTENTHOLDER like '%83871929%'
order by id desc

Check Data prepared for export

select * from VIEW_CMASAPMPKSEXPORT