Hi Michele,

Thank you very much for all the suggestions including the SQL command which I find very helpful for the debugging process!

Linda

On 7/11/22 17:12, Morgan, Michele wrote:
Hi Linda,

We have had triggers running using both the au.created and au.expired hooks for some time without problems. We've had success with them configured at both the consortium and system levels.

Our configurations are similar to the stock ones you referenced. Of course, we have set Enabled to TRUE, whereas they are not enabled by default.

We also use a granularity and custom filter, but adding those elements will not make triggers succeed that are failing.

Here is our crontab entry for running the new user action trigger:

# New User Welcome Message - check every 2 minutes
*/2 * * * * . ~/.bashrc && $EG_BIN_DIR/action_trigger_runner.pl <http://action_trigger_runner.pl> --osrf-config $SRF_CORE --process-hooks --run-pending --granularity welcome --granularity-only --custom-filters $AT_FILTERS/a_t_filters.welcome_public.json

If you have access to the database, you can run this query as a basic check to see if triggers specified by the event definition id for the current day are processing:

SELECT state, count(*)
FROM action_trigger.event
WHERE date(add_time) = date(now())
AND event_def = <event definition id>
GROUP BY 1
ORDER BY 1

Hope this is helpful,
Michele

--
Michele M. Morgan, Technical Support Analyst
North of Boston Library Exchange, Danvers Massachusetts
mmor...@noblenet.org



On Mon, Jul 11, 2022 at 7:40 AM Linda Jansová via Evergreen-general <evergreen-general@list.evergreen-ils.org> wrote:

    Dear all,

    In our current 3.6 production system, we are trying to make the
    following triggers work:

      * New User Created Welcome Notice using the au.created hook
        (like this one:
        
https://demo.evergreencatalog.com/eg2/en-US/staff/admin/local/action_trigger/event_definition/109);
      * 30 Day Account Expiration Courtesy Notice using the au.expired
        hook (like this one:
        
https://demo.evergreencatalog.com/eg2/en-US/staff/admin/local/action_trigger/event_definition/108).

    In both cases we use the predefined triggers but not on the
    consortium level as in the examples above - instead, they are
    defined on a system level for a particular library system (which I
    suppose should be fine (?)).

    So far the emails are not sent out as expected.

    Does anyone else also use these triggers/hooks? Could you please
    share your working configuration (maybe including a particular
    cron setup which is in your case relevant for this hook)? Or is
    there a procedure to follow that may help in the debugging process?

    Or do you have any idea about what might do the trick for these
    two hooks in particular?

    Thank you very much!

    Linda

    _______________________________________________
    Evergreen-general mailing list
    Evergreen-general@list.evergreen-ils.org
    http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general

_______________________________________________
Evergreen-general mailing list
Evergreen-general@list.evergreen-ils.org
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general

Reply via email to