Not realizing that Universal doesn't support Process Flows yet, I created a Process Flow that sent an email to our customer service. Later I understood this was not supported, then I removed the Process Flow and wanted to handle it by SQL Server database mailer using "msdb.dbo.sp_send_dbmail". All I had to do was adjust the task, create SQL Server mail profile and add it in the Stored Procedure via Functionality. The rest of the parameters were already present like body, subject, recipients. I modified 2 tasks which now both give an exception within Universal. Via the Windows GUI/Web it works fine.
One task gives the message [Unknown error], but mails. The other task gives the exception [Stage task commit failed. Error: validation_failed] and does not mail.
- Application Pool identity has SA rights within the SQL Server instance
Does anyone have any idea what might be the reason?
Thanks in advance.