Worksheet 401 Runs Repeatedly

(0) Share

Report

Posted on by Community Member Microsoft Employee

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?

1016.Connection-Schedule.jpg

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

All responses (10)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Worksheet 401 Runs Repeatedly

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).
Jeff @ Check Point ... 13,380 on at

Like (0)

Report

RE: Worksheet 401 Runs Repeatedly

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Worksheet 401 Runs Repeatedly

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!
Community Member Microsoft Employee on at

Like (0)

Report

RE: Worksheet 401 Runs Repeatedly

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
Stef Rose 240 on at

Like (0)

Report

RE: Worksheet 401 Runs Repeatedly

N.B. : set a 1 hour process at least, depending on the volume of datas you have to treat.
Stef Rose 240 on at

Like (0)

Report

RE: Worksheet 401 Runs Repeatedly

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Worksheet 401 Runs Repeatedly

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!
Jeff @ Check Point ... 13,380 on at

Like (0)

Report

RE: Worksheet 401 Runs Repeatedly

Whichever store is having the problem.
Kris2013 5 on at

Like (0)

Report

RE: Worksheet 401 Runs Repeatedly

Jeff, Do you mean delete all 401 from all stores, or just that particular store?

Thanks,

Kris
Jeff @ Check Point ... 13,380 on at

Like (0)

Report

RE: Worksheet 401 Runs Repeatedly

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