Workflow newbie here. Attached is my first workflow 'MigrateToDifferentVolume'. When I started this workflow (after promoting to a business process), it seemed like that it had worked. It changed all documents' volume to what I wanted. But after a few weeks, our sysadmin notified me the backup file of SQL database for Workflow is abnormally big (>2GB). There was no workflow defined or ran except the one mentioned above. When I ran workflow statistics report, there were 95,891 workflow instances 'completed' but not 'terminated'.
These are my questions:
- Is there any easier way to change all files under a folder recursively to all subfolders to a specific volume except the way I tried, using workflow?
- What's the difference between 'completed' and 'terminated' state of a workflow?
- Why it's not 'terminating' when it was 'completed'?
- How do I clean up this mess? When I tried to 'End Workflow', the menu 'Terminate' was greyed out (see attachment for screen shot)
Thanks a lot.