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 ...
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...