Delete resend records from EEE Inqueue table

From EnablerWiki

Created: 17 January 2011. Last Reviewed: 17 January 2011

If you have the situation where EEE dataloader is not working for a period of time, or more commonly, there are problems with the network links preventing stores from transferring their HOS files to EEE, and the stores are configured to export records on a regular basis and resend after a small number of exports (such as 10), you may have the situation where the EEE inqueue table can contain many thousands of resend records. It may take a considerable amount of time to process all the resend records.

If this occurs, you may wish to delete all the resend records from the inqueue table, so that dataloader can quickly process the backlog of data.

The script below allows you to delete all the resend records from the Inqueue table. You should stop the EEE Dataloader service before running this script, and when the script completes, restart the EEE Data Loader service.

Refer the comments in the script below for further information.

-- Determine how many records in the inqueue table

select count(*) from inqueue

-- Determine the number of records that are resends (Filename starts with R)

select count(*) from inqueue where filename like '%\R%'

-- Remove the comment from the row below to delete all resend records.

--delete from inqueue where filename like '%\R%'-