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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 2013 R2 Workflow &q...
Microsoft Dynamics GP (Archived)

GP 2013 R2 Workflow "SendWorkflowCompletionEmail" Error with System.IO.FileLoadException

(0) ShareShare
ReportReport
Posted on by Community Member

I had Workflow working in Purchase Order processing last week.  Started using it today and when I submit a PO for approval I get the following error below.  No changes had been made and this error appears now where last week everything worked:

"[Microsoft][SQL Server Native Client 10.0][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "SendWorkflowCompletionEmail". System.IO.FileLoadException": Could not load file or assembly 'System.DirectorSer[..." Error gets cut off at the end and I can't find any errors in the Event Viewer.

*This post is locked for comments

I have the same question (0)
  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: GP 2013 R2 Workflow "SendWorkflowCompletionEmail" Error with System.IO.FileLoadException

    Did you change the body of the notification at all? It could be that there is a missing stored proc, can you run a Dexsql.log and see if something comes up in there? Is this happening on all the machines?

  • Community Member Profile Picture
    Community Member on at
    RE: GP 2013 R2 Workflow "SendWorkflowCompletionEmail" Error with System.IO.FileLoadException

    Here are notable excerpts from the DexLog:

    SQLSTATE:(37000) Native Err:(6522) stmt(474944800):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "SendWorkflowCompletionEmail":

    System.IO.FileLoadException: Could not load file or assembly 'System.DirectorySer*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'DYNAMICS.dbo.zDP_SY30000F_1'.*/

    /*  Date: 08/19/2014  Time: 11:10:42

    SQLSTATE:(00000) Native Err:(2812) stmt(474949320):*/

  • Community Member Profile Picture
    Community Member on at
    RE: GP 2013 R2 Workflow "SendWorkflowCompletionEmail" Error with System.IO.FileLoadException

    I modified the "WF Assign PO Approval*" email template to include document lines since the On Order Amount never works (because On Order Amount doesn't populate until PO is released which happens after the PO is approved).  That worked last week.  I did not modify any other email templates.

  • Community Member Profile Picture
    Community Member on at
    RE: GP 2013 R2 Workflow "SendWorkflowCompletionEmail" Error with System.IO.FileLoadException

    I also create a new workflow and still get the error.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: GP 2013 R2 Workflow "SendWorkflowCompletionEmail" Error with System.IO.FileLoadException

    Something had to have changed Beratung. Did you bring in a new company or something? Is the framework in this company correct?

  • Community Member Profile Picture
    Community Member on at
    RE: GP 2013 R2 Workflow "SendWorkflowCompletionEmail" Error with System.IO.FileLoadException

    Literally nothing changed.  This is a test environment that no one else touched.  What do you mean "Is the framework in the company correct?"

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: GP 2013 R2 Workflow "SendWorkflowCompletionEmail" Error with System.IO.FileLoadException

    If you look in the SY00300 table is it correct compared to the tables?

  • Community Member Profile Picture
    Community Member on at
    RE: GP 2013 R2 Workflow "SendWorkflowCompletionEmail" Error with System.IO.FileLoadException

    Did you notice the stored procedure that DEXLOG says is missing.  It does not exist in Dynamics.  'DYNAMICS.dbo.zDP_SY30000F_1'.  Nor is there a table named SY_30000, which the name of the SPROC usually refers to the table it is affecting does it not?

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: GP 2013 R2 Workflow "SendWorkflowCompletionEmail" Error with System.IO.FileLoadException

    I just got the same error Beratung. Let me get back to you on this when I have more.

  • Community Member Profile Picture
    Community Member on at
    RE: GP 2013 R2 Workflow "SendWorkflowCompletionEmail" Error with System.IO.FileLoadException

    Actually SY30000 exists but there is nothing in it.  Why would you expect the Account Framework to be off?

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans