So, IT did an upgrade to 2010 on both SW and EPDM over the weekend and all the notifications set up in the workflow no longer work. The last one that anyone has is on Friday before the change.
Any thoughts or suggestions?
(From the document "Troubleshooting the PDMWorks Enterprise Database Server")
In the vault database check the table DocumentActionInfo and see if there are any rows not processed:
If the rows are not removed, the database server fails processing. Check for errors in the Application Event Log and incorrect settings. If the table is empty, the messages have either not been set up / triggered correctly, or they have been processed but not delivered to the correct user. Verify for instance the SMTP settings and that the correct group or user set has recipients.
Just try to restart the sql server service.
it will surely help you
Didn't work... now going to go through trouble shooting...
thanks for the tips, guys!
We ended up rebooting the server that contains the archive, database, and sql. Came in this morning and all the notifications were there, from the moment the upgrade to 2010 was done till now. Thank goodness it was backlogging the notifications.
Thanks for the help,
Retrieving data ...