Workflow Schedules stop with no reason

Products

• VMware Aria Suite

Issue/Introduction

When you create a schedule to run some workflows in VRealize Orchestrator, workflows would stop running and the schedule would have to be recreated again to resume workflows. 

Environment

Aria Automation 8.12

Aria Automation 8.17

Cause

• VRealize Orchestrator often uses a token from the authentication provider on behalf of the user whenever a scheduled task is created. Authentication providers often limit the amount of tokens you can get, and when the limit is hit, these tokens still get stored but eventually expire. 
• Token renewal periodic task cannot run due to a database deadlock

Resolution

1. When tokens expire
   1. Use user credentials rather than tokens (less secure). 
   2. Create a day 2 action that would delete and recreate these schedules so that the momentum keeps flowing. 
2. When there is a database deadlock
   1. Upload attached .jar file to environment
   2. run command to make it executable chmod a+x "filename.jar"
   3. run the file ./filename.jar