You’re offline. This is a read only version of the page.
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
Arun,
I know this is 5 years old... but that .NET error never gets old ;-)
I'm running into this issue after a GP 18.3 to 18.4 upgrade with WF 2.0 enabled and now when users try to submit batches that include "Send E-mail NOtification" in the WF setup, the dreaded error message pops up in GP.
No matter how many times the wfDeployClrAssemblies is run and trying all the tricks found so far, nothing helps. There is no messages in the Windows Event logs, so it's even harder to tackle this.
SQL logs contain several of those messages, but they are not errors, only informal:
Message
Unsafe assembly 'system.directoryservices, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=msil' loaded into appdomain 67 (DYNAMICS.dbo[runtime].72).
And apparently that's totally OK according to Microsoft's blog post.
Hi guys,
I'm facing the same error in GP2015 R2 workflow but message is bit different.
[Microsoft][SQL Server Native Client 11.0][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "SendWorkflowAssignmentEmail":
System.FormatException: String was not recognized as a valid DateTime.
I did everything i found in google. nothing worked. I've fighting with this since 4 days and still couldnt find a solution. Guys if you have any ideas regarding this kindly help me out..
Thanks,
Arun
OK, I came across this thread and ran that stored proc. It did the trick! Thanks everyone.
Beratung, did you ever get this issue resolved? We are implementing GP2015 with Workflow 2.0 and I am getting this exact error message when I go to test it. I can send a test email just fine. I've looked for a DexSql.log file, but cannot find it. I'm new to working with GP so please excuse any newbie-type questions.
Thanks in advance.
We had workflows in place and emailing properly in our system. During our MR upgrade, it was required to upgrade the .NET framework. After the upgrade to .NET frame, our users were receiving the original report error "A .NET Framework error occurred during execution of user-defined routine or aggregate 'SendWorkflowCompletionEmail'. The issue was cleared up by running the Stored Proc that Jonathan provided above. Thank you Jonathan!
FYI: We have successfully submitted a GL Batch workflow but it took installing .net 4.5.1 in order to get past this error.
I had this same issue with GP 2015 R2 and the running the exec wfDeployClrAssemblies is not solving my problem.
Do you have any other suggestions?
I am running this procedure on the DYNAMICS database then returning to the Batch and submitting and still receiving the following Error:
A .NET Framework error occurred during execution of user-defined routine or aggregate
"SendWorkflowCompletionEmail": Could not load type 'System.Runtime.CompilerServers.Ex
Did you ever figure this out? We have GP stalling frequently (like every couple minute) and we have a lot of these same messages.
Jonathan,
Thanks for the step. I was getting a different error related to .NET Framework error related to a system assembly error for the GetUserAccess. It was for GP 2015 and related to all workflows. Running the EXEC resolved my issue as well!
Thanks for the post!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,151
Super User 2024 Season 2
#2
Martin Dráb
229,963
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (