Training Expirations not sending notifications

I am not receiving the Weekly notifications of the trainings that are due to expire within the next 30 days. Could you please look into this and let me know? It is imperative I get these notifications.

Possible Reasons for the issue:
1. The table hsi.keyitem234 may not exist in the database Onbase Prod. It may have been renamed or deleted.
2. The database name 'Onbase Prod' or schema 'hsi' may be incorrect.
3. The SQL user running this query may not have permission to access the Onbase Prod.hsi.keyitem234 table.
4. The view 'vwSheriffTrainingExpiresIn60' may be incorrectly defined, referencing non-existing tables or views.

After reviewing this

I noticed that the view 'vwSheriffTrainingExpiresIn60' had the wrong OnBase Database. The query was pointing to Onbase Prod and needed to go to OnBase_Prod

I went into the SQL management Studio - Expanded WRITS_Prod Database - views - design

 

• Related Articles

• ERROR: "415 UnsupportedMediaType" when sending GET request containing a body from a Workflow Web Service step

  Behavior: When attempting to set up a Web Service step in a workflow that utilizes a GET request containing a body, the following error message is shown; "415 UnsupportedMediaType" Solution: By product design, the Web Service activity does not ...

• OnBase Reference Guide

  OnBase Reference Guide MRG

• FAQ: Webservice Activity in Workflow (DocuWare 7.5+)

  General questions Question: Where can I find all web service related information? Answer: Web services documentation Universal Modules documentation (list of web service types and more) General Developer page (in case the web service should access ...