Greetings!
On a Dynamics 365 for Finance & Operations LBD Deployment, can occur that the Deployment fails on a certain step like the SSRS App Deployment, Synch, etc.
In order to check the Deployment status and the running task, you can run the below query against the «OrchestratorData» Database.
use OrchestratorData
select * from RunBookTask order by StartDateTime desc
In such case, just fixed the issue we can restart the Deployment in two ways:
About the second option, once checked the failed step with the previous query, we have to update the two tables involved in the process and move the State field from 3 to 1 for the specific JobId.
update OrchestratorJob set State = 1 where JobId = 'AXUG-028b0c39-e713-4fb9-b375-52f507df1313'
update RunBookTask set State = 1, Retries = 1 where RunbookTaskId = 'AXUG-028b0c39-e713-4fb9-b375-52f507df1313-setupModules'
About this option, take care because in some cases like Certificates update, recreation of the Credentials.json file, etc. is mandatory handle the deployment through LCS.
About that, I handled a session to the last AXUG Conference in Dublin.
Till soon!
On a Dynamics 365 for Finance & Operations LBD Deployment, can occur that the Deployment fails on a certain step like the SSRS App Deployment, Synch, etc.
In order to check the Deployment status and the running task, you can run the below query against the «OrchestratorData» Database.
use OrchestratorData
select * from RunBookTask order by StartDateTime desc
In such case, just fixed the issue we can restart the Deployment in two ways:
- Through LCS, retry button (like cloud)
- this option clear all Fabric applications and recreate them again. Time consuming
- Through SQL Server, fast way
- this option avoid to recreate the Applications and rerun the last step only
About the second option, once checked the failed step with the previous query, we have to update the two tables involved in the process and move the State field from 3 to 1 for the specific JobId.
update OrchestratorJob set State = 1 where JobId = 'AXUG-028b0c39-e713-4fb9-b375-52f507df1313'
update RunBookTask set State = 1, Retries = 1 where RunbookTaskId = 'AXUG-028b0c39-e713-4fb9-b375-52f507df1313-setupModules'
About this option, take care because in some cases like Certificates update, recreation of the Credentials.json file, etc. is mandatory handle the deployment through LCS.
About that, I handled a session to the last AXUG Conference in Dublin.
Till soon!
1 comment:
Thanks for posting such useful information. You have done a great job.
D365 Finance and Operations Training
D365 Finance and Operations Online Training
Post a Comment