Clearing 'stuck' data writes in DVUpload Status

Clearing 'stuck' data writes in DVUpload Status

Get a list of what is currently outstanding:

 

select *

from DVENTERPRISE.dbo.StagingRequests

where StatusId < 4

 

Fail those currently outstanding records

 

Update DVENTERPRISE.dbo.StagingRequests

Set StatusId = 5

where StatusId < 4