Page 1 of 1

Errornous jobs after upgrade to 21.04

Posted: Tue Oct 05, 2021 3:08 pm
by AndreasT
After upgrading OpenEMM top Verison 21.04.000.124 the jobs are no longer running
OMT "Show OpenEMM status" says:
"Jobqueue status: 8 errorneous jobs (BirtReports, LoginTrackTableCleaner, CalendarCommentMailingService, ...)"

But I cannot find a logfile where I can look for a reason.

Any hints?

Thanks

Andreas

Re: Errornous jobs after upgrade to 21.04

Posted: Tue Oct 05, 2021 7:32 pm
by maschoff
Please check with menu 1 if OpenEMM is still running.

Re: Errornous jobs after upgrade to 21.04

Posted: Wed Oct 06, 2021 8:28 am
by AndreasT
I think the other parts of OpenEMM are running:

=============================================
= OpenEMM Maintenance Tool (OMT) v21.04.099 =
=============================================
Hostname: openemm
OpenEMM License: OpenEMM (ID: 0)
OpenEMM Runtime Version: 21.04.099
OpenEMM Version: 21.04.000.124
System-Url: https://(hidden for security)

Current menu: Show OpenEMM status

OpenEMM status:
Operating System (OS): CentOS 8
Python version: 3.9.1 (default, Dec 8 2020, 22:48:27) [GCC 8.3.1 20191121 (Red Hat 8.3.1-5)]
Sendmail Version: 8.15.2
Database client version: /usr/bin/mysql Ver 15.1 Distrib 10.3.28-MariaDB, for Linux (x86_64) using readline 5.1
Database Connection: OK
System-Time: 2021-10-06 09:25:01
System-Time-DB: 2021-10-06 09:25:01
Database version: MariaDB 10.3.28-MariaDB
OpenEMM database structure exists (Version 21.04.000.079)
Database table emm_db_errorlog_tbl: OK
Jobqueue status: 8 errorneous jobs (BirtReports, LoginTrackTableCleaner, CalendarCommentMailingService, ...)
DKIM keys available for domains: None
Java version: 11.0.12 (Oracle)
Tomcat version: 9.0.45.0
Tomcat-Native version: 1.2.23
Wkhtml version: wkhtmltopdf 0.12.6 (with patched qt)
OpenEMM Application is running (Tomcat ProcessID: 869652, started at: Oct05 4:56)
OpenEMM Backend ok: once
OpenEMM Backend running: mailout, update, trigger, generate, mta, pickdist, slrtscn, direct-path, bav-update, bavd, bav, mlcontrol

Re: Errornous jobs after upgrade to 21.04

Posted: Wed Oct 06, 2021 9:10 am
by maschoff
Could you list all jobs that are not running (see administration -> system status) please?

Furthermore, we plan to publish an update later this week that might fix this problem.

Re: Errornous jobs after upgrade to 21.04

Posted: Wed Oct 06, 2021 1:00 pm
by AndreasT
The system status shows me the jobs as follows:

2 Inaktiv BirtReports
3 Inaktiv LoginTrackTableCleaner
4 Inaktiv CalendarCommentMailingService
5 Inaktiv DeletedContentblockCleaner
6 Inaktiv UndoRelictCleaner
7 Inaktiv AutoOptimization
8 Inaktiv DBErrorCheck
9 Inaktiv WebserviceLoginTrackTableCleaner

Re: Errornous jobs after upgrade to 21.04

Posted: Wed Oct 06, 2021 2:47 pm
by maschoff
Strange. Have you tried to restart the stopped jobs via the system status page?

Re: Errornous jobs after upgrade to 21.04

Posted: Thu Oct 07, 2021 7:41 am
by AndreasT
There is no option in the status page to start the jobs. In the Joblist the jobs and the status-icon are not clickable.

Re: Errornous jobs after upgrade to 21.04

Posted: Thu Oct 07, 2021 11:02 am
by maschoff
Administration > System Status > field "Start job by description" > enter name of job & press button

Re: Errornous jobs after upgrade to 21.04

Posted: Thu Oct 07, 2021 3:25 pm
by AndreasT
The GUI simply says "ERROR". In the EMM Logfile I can see a Java Exception:

This JobQueueNode is currently not active

Re: Errornous jobs after upgrade to 21.04

Posted: Tue Oct 12, 2021 9:27 am
by AndreasT
Is there somewhere a logfile where I can look why the JobQueueNode did not start?