Skip to main content

Posts

Error while Restoring DB After Dynamics F&O Version Upgrade "An unexpected failure occurred: Data plan execution failed with message One or more errors occurred. (One or more errors occurred. (One or more errors occurred. (Violation of PRIMARY KEY constraint 'I_15464SETTINGKEYINDEX'. Cannot insert duplicate key in object 'dbo.FINANCIALREPORTINGSETTINGS'. The duplicate key value is (5637144576, DisableMaps). The statement has been terminated.)))."

Dear Dev Team, We usually encounter this type of error after upgrading Dynamics versions. The simplest and most reliable way to resolve it is to restore or import the database using a temporary name , and then rename it back to AxDB afterward. Failed Execution :  you will get the error message. "An unexpected failure occurred: Data plan execution failed with message One or more errors occurred. (One or more errors occurred. (One or more errors occurred. (Violation of PRIMARY KEY constraint 'I_15464SETTINGKEYINDEX'. Cannot insert duplicate key in object 'dbo.FINANCIALREPORTINGSETTINGS'. The duplicate key value is (5637144576, DisableMaps). The statement has been terminated.)))." Correct approach The key step is to temporarily rename AxDB to AxDBLocal during the import. C:\SqlPackageExe>SqlPackage.exe /a:import /sf:C:\DB\qfz-erp-stgbackup.bacpac /tsn:LOCALHOST /tdn:AxDBLocal /p:CommandTimeout=18000 /TargetEncryptConnection:False Later use below script to ...
Recent posts

Integrate Business Events with Applications using MS Power Automate Flow in D365 FO

Integrate OOTB or Customized Business Events with Applications using MS Power Automate Flow Dear Consultants, Based on requirements, we choose integration techniques. Today, we'll discuss the methods we use to trigger a call based on process in D365 FO. Blog for Pre Process before consuming Customized Business Event : Customized Business Event in D365 FO Requirements: New employee is getting on board. The outside system should know the on-boarding process has initiated. Dependent processed will trigger based on ERP event CRUD operation should be available using Data entity framework. Pre- requisites: Data Entity should be available Business Event should be available Permission to create and manage flow should be available on Power Portal.     Steps: 1) Navigate to Business Events Catalog 2) Search your OOTB / Customized Business Event & Download the schema 3) Login to https://make.powerautomat...

Custom Service Integration to sending response as a list in D365 F&O || Inbound integration

  Hello Devs, Custom service is very common when it comes to third party integration. Here I will explain using inbound integration to design a custom service and expose the service for integration. Requirement : Need to send list of employees who are on leave today This service will be used by third party Application We will start from creating Response class, 1) Response class 2) A Helper class to hold Response within a list 3) The main Service class to hold logic 4) Simply, Once populating all response values and adding them into list, Return List Response . That is in my case, return ResponseList; 5) Creating service for your service class 5) After service, create service group 6) Assign Service class to Service element 7) Now assign our Service to Service Group (You can drag & drop also) 8) Test your service (On any browser) Structure : Environment URL/API/Services/YourServiceGroupTitle/YourServiceTitle/YourMethod In my case it looks like this, Testing your ...

Calling D365 F&O Code from PowerApps | Finance and Operations | Dynamics

  Dear Devs! This blog will be very helpful for those who needs to call methods of D365 F&O from PowerApps. Specially methods which hold logic for calculations or display methods(Indirectly). Pre requisites: Must have connected account ( PA-D365) Already have Data entity created. Steps : 1) The first step after creating entity is to create method which will be called from Flow. 2) Create a flow to test the logic/ Use power App 3) Search for Dynamics F&O execute option 4) Select your environment details under instance and select action which will have entity and its method details. First part : Entity Name Second part : Attribute you set above method declaration 5) Once you run the flow successfully it will return you required output. Hope you find this code helpful. Shayan Arshi