Azure, Logic Apps

Azure Logic Apps Template resources

Azure Logic Apps Template Creation for CI/CD

http://blog.ibiz-solutions.se/integration/logic-apps-deployment-template-extractor/
https://blog.mexia.com.au/preparing-azure-logic-apps-for-cicd
http://blog.ibiz-solutions.se/integration/logic-app-template-extractor-connections-update/
http://notetoself.tech/2017/08/20/rethinking-and-old-logic-app-deployment-package-part-ii/

http://www.integrationusergroup.com/continuous-integration-logic-apps-using-team-foundation-team-services/

 

Advertisements
SharePoint, SharePoint 2013, Workflow

Workflow suspended

Scenario

When testing workflow I created to test accounts and set up mail boxes for those accounts. Send email from outlook to these two test accounts works fine.

*Note Important : User Profile service not synched with AD after creating the mail boxes.

Created a simple SPD workflow that sends mail to these test accounts. The internal status of workflow changed to suspended. Error status looks like,

RequestorId”: 3d95f396-16f9-9e6d-0000-000000000000. Details: “RequestorId”: 3d95f396-16f9-9e6d-0000-000000000000. Details: An unhandled exception occurred during the execution of the workflow instance. Exception details: System.ApplicationException…

How to Fix this

Try this first.

Run this PowerShell script (from application server) to check if SharePoint is able to send mail. For me it worked and sent mail to Test accounts… but still workflow was not sending email to test accounts.

$site = New-Object Microsoft.SharePoint.SpSite(“http://my.SharePoint.Site “)

$web = $site.OpenWeb()

$mail = [Microsoft.Sharepoint.Utilities.SpUtility]::SendEmail($web,0,0,”support@company.com”,”Subject of the Mail”,”mail body”)

Try this next.

From central administrator run full user profile synchronization.

Now try again and voila!!! it worked. Workflow sends email to Test accounts…

Also grant ‘Contribute’ permission to the user¬†to workflow History list.

Useful links

https://social.technet.microsoft.com/Forums/sharepoint/en-US/0d9a7bac-7829-4464-a837-3c5169cf73b5/sharepoint-2013-workflow-goes-suspended-while-trying-to-send-an-email?forum=sharepointgeneral

https://social.msdn.microsoft.com/Forums/en-us/4f52fea6-64e5-42be-9647-49341d7d549c/workflow-cancels-on-sending-email-action-sharepoint-2013?forum=wflmgr

https://technet.microsoft.com/en-us/library/cc263462.aspx

Uncategorized

SP2013 – Permissions for Workflow Manager account

The workflow service account should have appropriate permission in database “WFInstanceManagementDB” and “WFResourceManagementDB” for the workflow to ¬†publish and run successfully.

Side effects if the account does not have appropriate permission.

  1. Workflow may not publish properly
  2. Workflow history status screen may not open i.e., the workflow link for list item may show unexpected error

How to troubleshoot this issue?

  1. Login to web front end server and open event viewer -> Applications and Services log -> Microsoft-Workflow and click “Operational”
  2. Look for error message as shown below

Failed SQL command after 1 tries with error ‘229’. Exception: System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object ‘InsertTrackingAndStatus’, database ‘WFInstanceManagementDB’, schema ‘dbo’.

giving appropriate permission to the service account as mentioned in the start of the article fixed this issue.

side note : I gave db_owner permission for the service account. Not sure about the actual permission at the time of writing this article.

Useful resources:

http://vietsharepoint.blogspot.com.au/2013/10/sharepoint-2013-workflow-cant-start.html

https://social.msdn.microsoft.com/Forums/office/en-US/2575c032-840a-440b-8c60-84457648f007/sp-designer-2013-workflow-internal-server-error-when-publishing?forum=sharepointcustomization