Automated Email Notifications Continue After User Email Change Due to Orphaned Automation Workflow
Original Question or Issue:
We are experiencing an issue where automated email notifications are still being sent every 5 minutes to a user who was moved to a subsidiary and whose email address was changed in FileCloud. The old email address no longer exists, but it is still receiving the following notification:
Environment:
- Product - FileCloud Server
- Version - 23.251
- Platform - Windows
Steps to Reproduce:
-
Automation Workflow exists in the DB.
-
Automation Workflow doesn't appear in the User Interface
Error or Log Message:
HTTP response code 500 - Internal Server Error
Defect or Enhancement Number:
Cause:
Resolution or Workaround:
-
Connect via RDP to the FileCloud server and open a command line prompt.
-
Take a MongoDB backup using the following command: c:\xampp\mongodb\bin\mongodump.exe --host localhost --gzip --out C:\xampp\htdocs\scratch\autobackups
-
Connect to MongoDB shell and delete that workflow entry using the commands below:
use tonidoclouddb
db.automation_workflow.deleteOne( { "_id": ObjectId("62a036575064151566813125") } );
Notes:
_id": ObjectId("62a036575064151566813125" is the identifier in DB of that workflow, it can be retrieved using the MongoDB command: db.automation_workflow.find();