534
We have Problem with sending email in Purchase Requisition.
The emails do not reach the approvers of the purchase requests. I have to run the wfDeployCLRAssemblies process for it to work but after 1 day or sometimes a few hours the sending of emails fails again.
Do you have a solution to this problem?
GP v18
Carolina,
As you could see from the Log, this might indicate some user session that crashed... or some other type of conflicts.
When was the last time you rebooted your SQL server ?
Get all your users off GP and have your IT reboot the SQL server.. then log back on and check how the workflow e-mail works for requisitions.
In the DynamicsGP_WorkflowGP.WorkflowEngine.log we have these error message, How can we fix this error (There is already an object named '##69530885' in the database) :
WorkflowDocumentModel.Initialize : SELECT a. Workflow_Type_Name, a.FieldsListGuid, b.Workflow_Where_Clause FROM WF100001 a INNER JOIN WFI10002 b ON a.Workflow_Type_Name = b.Workflow_Type_Name WHERE WorkflowInstanceID = '1DA1B51D-ED7D-42BC-97D9-F122ABDF6CD2' - There is already an object named '##69530885' in the database.
I'd recommend looking at the blog I mentioned for intermittent emails in Workflow, as we shouldn't need to be executing that procedure to re-create the SQL objects all that frequently, unless something else in in play.
Also, when the email issue occurs, are either of these two workflow logs generated and showing anything for the same date/time of the issue?
1. DynamicsGP_WorkflowGP.log
This log is found on the local user's TEMP directory, for the user that is logged into Dynamics GP. (i.e. C:\Users\(userID)\AppData\Local\Temp\ )
2. DynamicsGP_WorkflowGP.WorkflowEngine.log
This log is found on the SQL Server machine's Temp directory of the user running the SQL Server service. (i.e. C:\Users\MSSQLSERVER\AppData\Local\Temp )
We runned the wfDeployClrAssemblies script after that, the emails working again.
What can we do to fix this problem ?
So, on GP 18.0, there is no option for using modern authentication, so that is ruled out.
When you see emails not sent to approvers for purchase requisitions, does the workflow itself route to the correct approver(s) based on any conditions on the workflow step(s)?
If so, at the same time the issue occurs, can you successfully send yourself a test email from the Workflow Setup window and receive it?
If you do and you receive it, then it wouldn't seem like an issue with the procedures, but more a matter of whether or not the SQL Server account can validate the approver(s) which is why I was curious if the workflows route as they should, and even if they do route, the SQL account still has to be able to get the email address to the approver(s) from their AD user card.
If you're truly running the execute wfDeployClrAssemblies script and it gets the emails working again, then it may be more a .NET issue on the server itself, which is why I was also curious if this script comes back as having run successfully, or there are errors?
Thanks
Hello,
Our version is GP : 18.00.0628 (R2) - Windows server 2012
Carolina,
What's your exact GP build ? you say GP v18, but that is vague and 4 years old.. GP has had minor upgrades through the last 4 years and the problems related to e-mail issues with the TLS protocol have been addressed in v 18.3 and up.
When you run the script to execute the wfDeployClrAssemblies procedure against your GP system database, does it run successfully?
It's not something we have really seen, where you'd need to run that after a day or a few hours.
If you haven't done so, maybe take a look at this blog as well:
community.dynamics.com/.../dynamics-gp-workflow-intermittent-emails-failing
This blog goes over recent TLS changes on SMTP endpoints that were done by the Exchange Online/O365 team as they prepare to completely disable basic authentication by Oct 2022.
While Workflow email works differently than regular Exchange emailing in Dynamics GP and doesn't specifically rely on basic authentication, instead using SMTP, this blog goes over a way to opt in to a client legacy endpoint for your O365 tenant, if applicable.
Let us know if you have any questions.
Thanks,
I would read through this support article:
docs.microsoft.com/.../email-troubleshooting-guide
It seems there is something not right with your GP workflow setup. Are you using any of the other workflows besides purchase requisitions?
Joe
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
