Markview - Outbound emails not going

There is a known issue in Markview 170 systems wherein users complain that they are not getting approval email notifications though the approval item is in the right queue and users can see if they manually login to Markview 170 in their web inbox.

If this is the issue, then do the following,

1. Check "170 process mail gateway" if that is running fine.

2. If it gives error, then stop the process and then check if the test connection works by opening hte "170 mail gateway configuration" window and click on Test button. If it does not (generally happens if the DB user password was changed) then correct the setting there and then restart the process.

This should start processing the outbound emails.
To check if the mail gateway is processing the email notifications or not, you may use the following query,

select count(*)
from xxmv.sf_workitem_instance a
,xxmv.sf_queue b
where a.queue_id=b.queue_id
and b.QUEUE_NAME='New Mail'
and enqueued_timestamp>trunc(sysdate-20)
and RETRIEVED_TIMESTAMP is null

As can be seen from the above query, the queue name for new email notifications is "New Mail". That's the queue where the mail gateway checks for new emails that need to be sent.
If the mail gateway processes the emails then the COUNT from the above query should be reducing and should eventually become zero after successfully processing all the outbound email notifications.

A concurrent program can be designed and scheduled to monitor this table and if the count exceeds certain limit / thershold then send an email to a particular email address for monitoring purpose.