EUCARIS includes a scalable task scheduler (implemented in Core update SU-U31 and higher) which is capable to execute several functional, operational and housekeeping tasks. When EUCARIS is installed on multiple nodes, the tasks can be executed on all nodes or just one single random (available) node. The scheduled tasks are inserting status and process information into the table ScheduledTaskLog. For more information on this log refer to the troubleshooting paragraph on this page.

The following tasks are defined:

Scheduled tasks

  • DiagnosticsCollectIisVolume
    • Run time: every 10 minutes, starting at 00:00
    • Run mode: on every node
    • Task: collects and aggregates the IIS logs for the EUCARIS web sites. The resulting aggregate information is stored in the Health Centre table DiagnosticsIisVolume
  • DiagnosticsDaily
    • Run time: every 24 hours, starting at 00:05 UTC
    • Run mode: any available single node, one node only
    • Task: collects and aggregates diagnostics information for the Health Centre (further implementation pending)
  • LogCollectorDaily
    • Run time: every 24 hours, starting at 05:00 local time
    • Run mode: any available single node, one node only
    • Task: collects and aggregates statistical information regarding message exchange into a daily digest
  • LogCollectorMonthly
    • Run time: every month, starting at the first of the month, 06:00 local time
    • Run mode: any available single node, one node only
    • Task: collects and aggregates statistical information regarding message exchange into a monthly digest
  • MessageIdRepositoryPurge
    • Run time: every hour, starting at 00:20
    • Run mode: any available single node, one node only
    • Task: purges the message id repository table according to the maximum retention period configuration
  • QueuePurge
    • Run time: every hour, starting at 00:01
    • Run mode: any available single node, one node only
    • Task: purges the file transfer upload- and download queue according to the configured retention period
  • ServiceLogPurge
    • Run time: every hour, starting at 00:15
    • Run mode: any available single node, one node only
    • Task: purges the ServiceLog according to the maximum retention period configuration
  • ServiceMessageVersionRequest
    • Run time: every 24 hours, starting at 00:15 UTC
    • Run mode: any available single node, one node only
    • Task: Gather information about message versions supported by other Member States. Used in asynchronous exchange, to avoid sending messages of a too high version.
  • StatisticsPurge
    • Run time: every 24 hours, starting at 07:00 local time
    • Run mode: any available single node, one node only
    • Task: collects and aggregates statistical information regarding message exchange into a daily digest
  • TaskLogPurge
    • Run time: every 24 hours, starting at 00:00 UTC
    • Run mode: any available single node, one node only
    • Task: deletes old entries from the ScheduledTaskLog table.

The tasks and properties are defined in the database table ScheduledTasks, and although the schedule is customizable, we recommend to keep the default values and not change the schedules manually. If you have specific needs or requirements, please contact EUCARIS Operations.

Troubleshooting

The scheduled tasks are inserting status and process information into the table ScheduledTaskLog. This log contains the following columns:

  • TaskName; identifies the scheduled task
  • RunTime; denotes the run-time of the task in UTC
  • RunOnNode; denotes the node (server name) where the task has been executed on
  • RunDuration; denotes the duration of the task in milliseconds
  • RunStatus; denotes if the task ended successful or not. 0=successful. -1=unsuccesfull, -9=restored. A task is restored when it is in a running state for more than 2 times the timespan of normal scheduling.
  • RunResult; informational messages specific for the task

Currently there is no specific user interface available to consult this ScheduledTaskLog. Actions required based on the task results are going to be implemented in the EUCARIS Health Centre.

Use the following SQL query to select the most recent errors from this log:

SELECT * FROM ScheduledTaskLog WHERE RunStatus <> 0 order by RunTime desc

For more information or support please contact EUCARIS Operations.