Posts

Showing posts from June, 2022

Confused and irritated with the error: "Exception: Cannot create a record in Alerts - event inbox data (EventInboxData)"? There is an easy hack.

I guess many of us have faced the issue of the below workflow error, while processing D365 FinOps Workflows: " Stopped (error): X++ Exception: Cannot create a record in Alerts - event inbox data (EventInboxData). Inbox ID: 5637144724 " For this you need to clear the dirty data, as outlined in the process below: select   *   from  EVENTINBOXDATA  where   not   exists   ( select   top  1  *   from  EVENTINBOX  where  EVENTINBOX . INBOXID  =  EVENTINBOXDATA . INBOXID ) Suggestion : backup EVENTINBOXDATA or backup database run below script to clean up the junk data : delete   from  EVENTINBOXDATA  where   not   exists   ( select   top  1  *   from  EVENTINBOX  where  EVENTINBOX . INBOXID  =  EVENTINBOXDATA . INBOXID )