Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / work flows stuck in a ...
Sales forum
Suggested answer

work flows stuck in a step

Posted on by 10

Greetings!
wish you are having a best day.
As our government did not change the day light shifting times(supposed to shift 1hr forward but government didn't I mean for exp our local time is 9:00 AM and it was supposed to shift forward 1hr which becomes 10:00 AM but government did not accept this and we are keep going with old time which is 9:00 AM), our work flows stuck in "waiting for resources" or "in progress". almost no work flows get done and after couple of hours(sth around more than 12hrs), I can see in system jobs that some work flows are succeeded and not exist but when I go to that record, work flow did not actually finish its task supposed to create or do a stuff. So because of this, our CRM is almost become useless because no work flow is successfully getting done.
We have restardetd our CRM server, restared the Asynchronous service but still not working. after googling, we found this solution which said execute this querry in CRM data base:

insert into TimeZoneRuleBase
([StandardDay],[ModifiedOn],[StandardMinute],[StandardBias],[StandardYear],[DaylightMonth],[StandardDayOfWeek],[DaylightSecond],[Bias],[TimeZoneRuleVersionNumber],[DaylightBias],[StandardMonth],[EffectiveDateTime],[DaylightHour],[StandardHour] ,[CreatedOn] ,[DaylightYear] ,[StandardSecond] ,[DaylightMinute] ,[TimeZoneDefinitionId],[DaylightDayOfWeek] ,[TimeZoneRuleId] ,[DaylightDay])
values
(
3,GETUTCDATE(),59,0,0,3,1,59,-210
,3,0,9,'2023-03-20 23:59:59',23,23,GETUTCDATE(),0
,59,59,'ee3fab43-973b-4a0d-ae74-4082f03c22fc',6,NEWID(),3
)

after executing this querry, CRM time fixed correctly with CRM server but our invoices/contracts/orders or whatever related to dates shifted 1 day backward and become a mess!
still workflows are not working and we faced with couple of serious problems such as: work flows not working and they are all pending || our all invoice/contract/orders dates are manipulated by system (not operator) and not fixed.
All this problems are happening while Asynchronous service and other Dynamics 365 services are all running and CRM server IS NOT down, 'AsyncSdkRootDomain' column has value in CRM database from 'DeploymentProperties' table ( I have followed this guide and still no luck nishantrana.me/.../ ).
I guess it causes from CRM data base for some table related to time table or stuffs like that such as TimeZoneRuleBase table and AsyncOperationBase table(just guess).
Could anyone please help us!? All organizations in our country working with dynamics 365 CRM are faced with this time conflict problem.

We are using 0n-prem d365.

Regards

Categories:
  • Sayen Zhang Profile Picture
    Sayen Zhang on at
    RE: work flows stuck in a step

    Hi partner,

    Because of this issue is regarding the form data in the database within CRM is related to, I suggest you create a support ticket for professional assistance following the below procedure. 

    Get Help + Support - Dynamics | Microsoft Docs 

    Best Regards,

    Sayen Zhang

     

  • RE: work flows stuck in a step

    Hi Sayen,

    thank you for your response, I almost tried the mentioned link before you wrote and got no luck.

    I guess this conflict may causes from some sort of tables which run the workflows(AsyncOperationBase table) and CRM getting time zone table (TimeZoneRuleBase table). It's just a guess of course but some sort of conflict in our local time and global time may lead us to this step. FYI all time zones in CRM, CRM server and everyother places I have had checked was correct.

    Thank you

  • Suggested answer
    Sayen Zhang Profile Picture
    Sayen Zhang on at
    RE: work flows stuck in a step

    Hi partner,

    According to your first question: Workflows stuck in "waiting for resources" or "in progress", please check if you create background workflows.

    Background workflows allow the system to apply them when resources on the server are available.  Actions defined by background workflows are not immediate so you can’t predict when they will be applied.

    You can also refer to this link: Workflow hangs with Status Reason: Waiting for Resources - Microsoft Dynamics CRM Forum Community Forum

    According to your second question: invoices/contracts/orders or whatever related to dates shifted 1 day backward, is the issue happens after we insert query into “TimeZoneRuleBase”?

    If so, please refer to this link to change the datetime based on user timezone in code: Date Time field value showing 1 day behind in CRM 365 9.2 - Microsoft Dynamics CRM Forum Community Forum

    Best Regards,

    Sayen Zhang

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

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

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans