Record inserted into table unknowningly
Posted: March 3rd, 2022, 5:50 pm
Hey, issue that has been monitored for about a week.
The issue was first noticed through BatchJob BatchOrderSubmit sending numerous emails of failure with records which existed that needed to go through the process of this BatchJob. The batchjob estimates the records present that have not gone through the process and then attempts to retrieve them, but doesn't retrieve the records because their origin is unintentional, coming from table EC_Order_Header.
The method CreateWebSalesOrder inserts into this table EC_Order_Header. The data that is associated with these records shows that it does not come from this method. There is some error which causes these to be inserted in the table. A potential hypothesis has been Item Import failing at the same time and related to connection issues. Some history has shown that these occur closely together but not always.
A screenshot of the data associated with the record inserted into the table. These errors should not be in the table because it does not go through the process of an order being created.
Unfortunately, I have been unable to capture the logs when this issue occurs. It has inconsistently happened over different periods of times and deleting the bad records from the table resolves the batch job emails temporarily until these records are reinserted into the table.
Any assistance into the issue would be appreciated.
The issue was first noticed through BatchJob BatchOrderSubmit sending numerous emails of failure with records which existed that needed to go through the process of this BatchJob. The batchjob estimates the records present that have not gone through the process and then attempts to retrieve them, but doesn't retrieve the records because their origin is unintentional, coming from table EC_Order_Header.
The method CreateWebSalesOrder inserts into this table EC_Order_Header. The data that is associated with these records shows that it does not come from this method. There is some error which causes these to be inserted in the table. A potential hypothesis has been Item Import failing at the same time and related to connection issues. Some history has shown that these occur closely together but not always.
A screenshot of the data associated with the record inserted into the table. These errors should not be in the table because it does not go through the process of an order being created.
- Record.png (31.49 KiB) Viewed 521 times
- Record.png (31.49 KiB) Viewed 521 times
Any assistance into the issue would be appreciated.