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