12-03-2018 06:28 AM
Hi everyone,
I'm relatively new to OnBase, and am now supporting Workflow in an older environment (v 15). I've been trying to get emails to send using the Distribution Service, but it is sporadically successful. After doing some research and querying some tables, I've found that I see all the distribution requests in the hsi.emailqueue table. Then I see the successful distrequestnum's in the hsi.distributionhist table. But all the unsuccessful distrequestnum's are in the hsi.distributionqueue table (about 1/3 of the total have not been sent, and this only started happening at a certain point in time). Why are those not being sent?
I found the below community article about having a standalone Workflow Timer on a client using the -WFSRVR switch but also wanted to check whether there is another reason why this might happen?
Thank you,
Erica
12-03-2018 08:04 AM
Hi Erica,
I am sorry you are having difficulty routing email messages! I was hoping you could provide me with a little more information that should help me get to the bottom of the issue.
Thanks,
Cameron Roberts
12-03-2018 09:22 AM
Hi Cameron, Appreciate your help! Here are the answers to your questions:
I'm happy to send a dump of my query, which joins the 3 tables if that helps.
Thanks again,
Erica
12-04-2018 04:54 AM
Erica,
OK, it appears the messages have not been attempted and by the Distribution Service and with other messages routing around them this is puzzling. Would it possible for you to run Diagnostic Console on the Distribution Service machine with the Error and Timer/Distribution Service tabs enabled and provide the results. Or better yet can you contact support for assistance?
Thanks,
Cameron
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.