Skip to main content

Posts

Error 1064: An exception occurred in the service when handling the control request

I was working on the Dynamics 365 Finance and Operations environment with Platform update 30, and I had removed a model from my Dev VM. After that, I noticed that batch jobs were not running, and the service 'Microsoft Dynamics 365 Unified Operations: Batch Management Service' was stopped. When I tried to start the service, I encountered the following error: Services Windows could not start the Microsoft Dynamics 365 Unified Operations: Batch Management Service service on Local Computer. Error 1064: An exception occurred in the service when handling the control request. There were also some error messages in the Event log: Faulting application name: Batch.exe, version: 7.0.6651.92, time stamp: 0xa0847b19 Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000 Exception code: 0x80131623 Fault offset: 0x00007ff9311594e3 Faulting process id: 0x1fd0 Faulting application start time: 0x01d9c6e9e907759b Faulting application path: K:\AosService\WebRoot\bin\Batch.exe Fa...

Disable Section Fields Javascript Model Drive App | Dynamics 365 CRM | Power App

This is JS to disable the section attributes function disableSec(executionContext) { disableAllControlsInSection("invoice information", executionContext); } function disableAllControlsInSection(sectionLabel, executionContext) { var formContext = executionContext.getFormContext(); var tabs = formContext.ui.tabs; for (var i = 0; i < tabs.getLength(); i++) { var tab = tabs.get(i); var sections = tab.sections; for (var j = 0; j < sections.getLength(); j++) { var section = sections.get(j); if (section.getLabel().toLowerCase() === sectionLabel.toLowerCase()) { //debugger; if (formContext.getAttribute("statuscode").getValue() == 4) { DisableForm(formContext); } } } } } function DisableForm(formContext) { formContext.ui.controls.forEach( function(control, index) { if (control.g...

Delete duplicate records from the table SQL

 WITH cte AS (        SELECT [ITEMID]       ,[PURCHPRICE]       ,[RETAILAMDISCOUNTTYPE]       ,[CURRENCYCODE]       ,[PURCHDISCPERCENT]       ,[SALESPRICE]       ,[VENDACCOUNT]       ,[FROMDATE]       ,[TODATE]       ,[RETAILPRICECHANGESTATUS]       ,[GROUPID] ,        row_number() OVER(PARTITION BY [ITEMID]       ,[PURCHPRICE]       ,[RETAILAMDISCOUNTTYPE]       ,[CURRENCYCODE]       ,[PURCHDISCPERCENT]       ,[SALESPRICE]       ,[VENDACCOUNT]       ,[FROMDATE]       ,[TODATE]       ,[RETAILPRICECHANGESTATUS]       ,[GROUPID]  order by [ITEMID] ) AS [rn]        FROM [ RETAILPRICECHANGETABLE ]   ...

Some use full Javascript Dynamics 365 CRM, Power Platform Model Driven App

Open Main View from the JavaScript  var pageInput = {     pageType: "entitylist",     entityName: "dag_wfacompositeentity" }; Xrm.Navigation.navigateTo(pageInput).then(     function success() {         // Run code on success     },     function error() {         // Handle errors     } ); Refresh the page after 10 second Dynamics 365 CRM JavaScript   setTimeout(function refreshPage() {     Xrm.Utility.openEntityForm(formContext.data.entity.getEntityName(), formContext.data.entity.getId()); }, 10000); Call Power Automate from the button click JavaScript Dynamics 365 CRM, Power App , Model Driven App var flowUrl = "https://prod-85.westeurope.logic.azure.com:443/workflows/7174dc80ca8745e9a52a459129642f7c/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%...

Dualwrite tips and tricks

Development Guide Dual Write   Prerequisites  Finance and Operations apps that have build version 10.0.9 (10.0.383.20013) (Quality update) and platform update 33 or later Model-driven apps in Microsoft Dynamics 365 that have platform version 9.1.0000.11732 or later Entity Creation I’m assuming that you have already setup and configured Dual-Write in your D365 FO and Dataverse (CDS) environments. Furthermore, required entities are already created in FO and Dataverse (CDS) applications and fields are also added as per the following data type mappings. MS D365 FO Field Type MS Dataverse Field Type String Text String (Memo) Text (Multiline) Base Enum Choices Boolean Yes/No Integer / Real Decimal Date Date Only Date Time Date and Time Create Integration Key It is very important to properly create and configure table key in MS Dataverse as per F&O entity key to avoid below error during mapping. Mapping is missing for integration key - Requisition Number Following are the ste...