Store Polling

Has anyone had success with automating the process of recovering from a 401
worksheet failure. On the HQ side I have seen a post about automating the
acknowledgment of the failed worksheet. What about generating a new 401
worksheet HQ and triggering polling from the store database.
Reply to
Max
I do not recommend this. You want to see what caused teh 401 to fail and then post date the 401 to thae date or a day before the 401 failed to make sure you btring all activitoes back.
Afshin Alikhani - snipped-for-privacy@retailrealm.co.uk Retail Ralm
Reply to
Afshin
CREATE TRIGGER ResetFailedUpload ON dbo.Worksheet FOR UPDATE AS DECLARE @Rows INT SELECT @Rows = @@ROWCOUNT IF @Rows = 0 /* No rows UPDATED, exit trigger */ RETURN update s set s.status=0 from worksheet w join worksheetstore s on worksheetid=w.id where style@1 and w.status=5 update worksheet set status=2 where style@1 and status=5
Reply to
Matt Hurst
This script would it allow the 401 worksheet to process or is this just acknowledgment of the 401 error. Our current process for 401 failure is acknowledge the worksheet, create a new 401 worksheet, remote to store database and intiate polling from HQ Client.
> CREATE TRIGGER ResetFailedUpload ON dbo.Worksheet FOR UPDATE > AS > DECLARE @Rows INT > SELECT @Rows = @@ROWCOUNT > IF @Rows = 0 /* No rows UPDATED, exit trigger */ > RETURN > update s set s.status=0 from worksheet w join worksheetstore s on > worksheetid=w.id where style@1 and w.status=5 > update worksheet set status=2 where style@1 and status=5 > > > > Has anyone had success with automating the process of recovering from a 401 > > worksheet failure. On the HQ side I have seen a post about automating the > > acknowledgment of the failed worksheet. What about generating a new 401 > > worksheet HQ and triggering polling from the store database. > > > >
Reply to
Max
I had an increased number of uploads that would fail and I wanted an easier way to retry the same upload for the same time. The script will reset the original worksheet that failed to "active" status again so it can be retried right away.
> This script would it allow the 401 worksheet to process or is this just > acknowledgment of the 401 error. Our current process for 401 failure is > acknowledge the worksheet, create a new 401 worksheet, remote to store > database and intiate polling from HQ Client. > > > > CREATE TRIGGER ResetFailedUpload ON dbo.Worksheet FOR UPDATE > > AS > > DECLARE @Rows INT > > SELECT @Rows = @@ROWCOUNT > > IF @Rows = 0 /* No rows UPDATED, exit trigger */ > > RETURN > > update s set s.status=0 from worksheet w join worksheetstore s on > > worksheetid=w.id where style@1 and w.status=5 > > update worksheet set status=2 where style@1 and status=5 > > > > > > > Has anyone had success with automating the process of recovering from a 401 > > > worksheet failure. On the HQ side I have seen a post about automating the > > > acknowledgment of the failed worksheet. What about generating a new 401 > > > worksheet HQ and triggering polling from the store database. > > > > > >
Reply to
Matt Hurst
Thanks that is what we want to try..we poll eachs tore twice a night so if it fails the first time,,adn we can reset the worksheet..it could be succesful on the second polling.. Sounds good we will get it in the lab and see...
> I had an increased number of uploads that would fail and I wanted an easier > way to retry the same upload for the same time. The script will reset the > original worksheet that failed to "active" status again so it can be retried > right away. > > > > This script would it allow the 401 worksheet to process or is this just > > acknowledgment of the 401 error. Our current process for 401 failure is > > acknowledge the worksheet, create a new 401 worksheet, remote to store > > database and intiate polling from HQ Client. > > > > > > > CREATE TRIGGER ResetFailedUpload ON dbo.Worksheet FOR UPDATE > > > AS > > > DECLARE @Rows INT > > > SELECT @Rows = @@ROWCOUNT > > > IF @Rows = 0 /* No rows UPDATED, exit trigger */ > > > RETURN > > > update s set s.status=0 from worksheet w join worksheetstore s on > > > worksheetid=w.id where style@1 and w.status=5 > > > update worksheet set status=2 where style@1 and status=5 > > > > > > > > > > Has anyone had success with automating the process of recovering from a 401 > > > > worksheet failure. On the HQ side I have seen a post about automating the > > > > acknowledgment of the failed worksheet. What about generating a new 401 > > > > worksheet HQ and triggering polling from the store database. > > > > > > > >
Reply to
Max

Site Timeline Threads

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.