Skip to main content

Notifications

Microsoft Dynamics RMS forum

Worksheet 401 Runs Repeatedly

Posted on by 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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Stef Rose 240 on at
    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 Profile Picture
    Stef Rose 240 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    RE: Worksheet 401 Runs Repeatedly

    Whichever store is having the problem.

  • Kris2013 Profile Picture
    Kris2013 5 on at
    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 Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,133 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans