web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Integration Monitoring

(0) ShareShare
ReportReport
Posted on by 8,223

Hi All,

I have requirement to monitor third party integration (Inbound) which uses ODATA + Azure Logic Apps with D365FO.
Idea is to identify failed records and take necessary actions . Since error /exception logged as technical format in Azure (dead letter queue) , it's hard to understand to the business users , who are handling and fixing functional errors .anyone has idea to simplify format of those errors ? or is there any way out , workaround to achieve this .

Thanks ,

Amith Prasanna

I have the same question (0)
  • vinitgoyal2005 Profile Picture
    6,332 on at

    Hi,

    I haven't worked with 'dead letter queue' but just throwing ideas here. Can you use Microsoft Power Automate to read this dead letter queue and convert errors in some user-readable format and perhaps even mail it?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Amith,

    What are failed records?

    Have you checked the available options on LCS especially in regards to the environment monitoring, logs, etc.?

    Best regards,

    Ludwig

  • Suggested answer
    Chris Haley Profile Picture
    on at

    The best solution is of course to understand the errors being caught and build more resilience into the end to end integration solution, wherever it's appropriate.. But I've had this before, for example where the source system that generated the message couldn't be customised to make certain fields mandatory, even though they would be required in F&O, so there were a lot of validation errors being caught.

    You can have a LogicApp triggered by messages arriving in the dead letter queue that handles the various exception types.

    My solution was to have a couple of tables in a SQL database. The LogicApp would parse the error and insert a record for the table & key fields of the message that caused the error (also had some fields to track the action taken and if the error was resolved - really useful for sys admin to track and report the errors being caught and identify any that didn't get resolved.) The other table provided a mapping between parts of the technical error that were captured and a 'friendly' message that could be sent to end users to guide them on resolving the issue e.g. an email sent from my email address by the LogicApp:

    "Hey <user>, I see you created a new product in the system. Unfortunately the description you entered was too long for it to fit in Dynamics, so the integration failed. Please can you go back and edit the description, keeping it under ?? characters. That should fix it! Thanks, Chris."

    There was more to the solution than I've described of course, for example when an exception was caught that didn't map to a friendly message it would email me directly instead so I could investigate and if appropriate create a new entry in the friendly message mapping, but hopefully that's helpful as a suggestion!

  • A.Prasanna Profile Picture
    8,223 on at

    Hi Vinit ,

    thank you for the input. I'll try.

    Thanks,

    Amith Prasanna

  • A.Prasanna Profile Picture
    8,223 on at

    Hi Ludwig,

    not the specific errors most of them are known issues like missing mandatory fields (like Dimension) , since now error logs are outside , we don't have visibility what happen with each failed records. and we need way to communicate functional people with meaning full error so they can fix functional issues from there end .

    Thanks ,

    Amith Prasanna.

  • Sergei Minozhenko Profile Picture
    23,093 on at

    Hi Amith,

    Have you checked built-in features when logic apps fails send a notification to users? You can send e-mail to users oData error returned from D365 (or you can parse it to a more readable format).

    docs.microsoft.com/.../logic-apps-exception-handling

  • A.Prasanna Profile Picture
    8,223 on at

    Hi Chris ,

    Thank you for your valuable input.

    Regards,

    Amith Prasanna.

  • A.Prasanna Profile Picture
    8,223 on at

    Hi Sergei,

    I found this  azureintegrations.com/.../ .

    As I understood , there will be additional Logic App to Handle Exception and Logged those in to Azure Log Analytics.  appreciate your feedback on this.

    Thanks ,

    Amith Prasnna.

  • Sergei Minozhenko Profile Picture
    23,093 on at

    Hi Amith,

    In the mentioned article author used "Run after" option docs.microsoft.com/.../logic-apps-exception-handling. There is additional generic LA which can handle errors from integration logic apps and send e-mail to users or\and forward message further to Azure Log Analytics. If you have a complex infrastructure with many Logic apps\ Azure functions and other Azure services - Log Analytics (and Azure monitor) is a good place to store all telemetry for easy access. But it will not solve your problem with user notifying after a functional error occurs and you still need to use "Run after" to send e-mail\put to error queue (in the same logic app or in the generic logic app to handle the same errors from different integration logic apps for better re-usability).

    Anyway, the topic is not about D365, but about Azure architecure and it's better to ask help on relevant forum :-)

    One more article about Logic apps monitoring docs.microsoft.com/.../monitor-logic-apps-log-analytics

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans