Schedule Event Trigger in Data Model Errors immediately when Scheduled

Summary:

I have created an event trigger in a data model, which I have done before without issue, but for this one as soon as I schedule the report that uses this data model and I use the schedule trigger, the report fails immediately with the following error.

::JOB_WAIT_TIME_SECONDS{1.4}::JOB_EXECUTION_TIME_SECONDS{0}::JOB_PRIORITY_COLON_NORMAL::::FAILED_TO_EXECUTE_TRIGGER::[INSTANCE_ID=bip.bi_serverHA] [JOB_ID=809649]::

Failed to execute event trigger::

Content (required):

I have added the SQL used in the Event Trigger below, which runs fine if you use it as the SQL for a Data Model. I am not sure why and there is no real detail to the error and running with diagnostic returns no diagnostic information on the error.