Hi,
Worksheet 401 is scheduled to run twice a day, once a week for 4 of our stores. (these stores are open only once a week)
The first worksheet will run at it's scheduled time 12:40pm; the second worksheet will run at its scheduled time 4:40pm; but then a 12:40 worksheet will continue to run over and over and over again until it eventually fails.
Has anyone encountered this?
Below are the settings for the store's connection schedule
Additional info:
We are running RMS version 2.0.0162
This started happening after i modified the connection schedule.
I checked that the time for the store is in sync with the time at HQ.
Thanks!
*This post is locked for comments
Thanks all!
I tried your suggestions, unfortunately they did not did not work.
What ended up working was updating the connection schedules to connect every day (as opposed to one day a week).
Note the time and date of the last 401 that did not complete and then delete it.
Create a manual one on the same date and one minute before the time you noted and then approve it and run it.
Thank you all for your feedback!
Jeff, I'd like to clarify something on your instructions.
"Delete all existing 401 noting its time and date of the oldest."
"Recreate a 401 one minute before the oldest one was and run it"
By oldest, do you mean the first 401 worksheet that was ever run for example back on 2011 or do you mean the most recent 401 that ran successfully.
Thank you!
Hi Aichi,
If number of 401 worksheets more than 500 for single store, then you may use following
Please Backup the database first. If you don't have SQL knowledge, its better to delete it manually.
One worksheet can have multiple stores, but i am assuming in this case you have only one store per 401 worksheet since its auto generated.
To find the worksheets IDs to delete (replace the store id XX with the storeid you required to delete)
---------------------------------------
select WorkSheetStore.Id as WorkSheetStoreid, Worksheet.id as WorksheetId, Worksheet.Style,WorkSheetStore.StoreId,WorkSheetStore.Status
from Worksheet left outer join WorkSheetStore on WorkSheet.Id = WorkSheetStore.WorkSheetId
where WorkSheetStore.StoreId=XX and Style='401'
--------------------------------------
Now it will show you two IDs. Both IDs you need to delete.
WorksheetstoreID and WorksheetID.
Use Following script to delete the respective store from worksheet
Replace 'XXXXX' with WorksheetstoreID (Ex : ('268887','266888', Etc)
------------------------------------
Delete from worksheetstore where ID in ('XXXXX','XXXXXX')
----------------------------------
Use Following script to delete the respective worksheets
Replace 'YYYYY' with WorksheetID numbers (Ex : ('287','288', Etc)
------------------------------------------------------------------------------------------------------
Delete from worksheet where ID in ('YYYY','YYYYY')
------------------------------------------------------------------------------------------------------
Again : Back up first. IDs are two different for WorksheetStore and WorksheetID. Dont mix it up.!
Hope this will help.
Regards
N.B. : set a 1 hour process at least, depending on the volume of datas you have to treat.
In the Store Properties, be careful of what features you enable or not : look at Connection Minutes section under the display of checkboxes, and you have first, to remove the Method option selected and at least, leave it blank or select the appropriate option to set off this feature. And, in the case that you must do it for all internal servers of the four compagny, I suggest you business administrator to self deploy this type of function from his main_desktop.
Have a nice day.
Hello Jeff,
Is there a way to delete all the 401 worksheets for the affected store at once?
We are on RMS version 2.0.0162
In HQ Manager under Admin > Worksheets, I have the option to delete them one by one.
If I go to HQ Admin, I can delete worksheets by date range, but I can't specify store or worksheet type.
Thank you!
Whichever store is having the problem.
Jeff, Do you mean delete all 401 from all stores, or just that particular store?
Thanks,
Kris
Delete all existing 401 noting its time and date of the oldest.
Recreate a 401 one minute before the oldest one was and run it
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154