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?

Re: Errornous jobs after upgrade to 21.04

Posted: Sat Jan 15, 2022 12:03 pm
by nhondong
I have the same error.

Any updates?

Re: Errornous jobs after upgrade to 21.04

Posted: Sat Jan 15, 2022 4:45 pm
by maschoff
I could not reproduce. Please restart OpenEMM and check the Tomcat log catalina.out in directory /home/openemm/logs for errors.

Re: Errornous jobs after upgrade to 21.04

Posted: Wed Mar 02, 2022 5:09 pm
by JuergenB
Same here after upgrading 21.04 to 21.10.000.108

Re: Errornous jobs after upgrade to 21.04

Posted: Wed Mar 02, 2022 5:55 pm
by maschoff
Since we cannot reproduce this problem, we have to dig a little bit deeper.

Re: Errornous jobs after upgrade to 21.04

Posted: Thu Mar 03, 2022 4:52 pm
by aso
Please have a look in your db table "config_tbl".
There should be an entry like (legacy, allowed for EMM version <= 21.04):
class, name, value
'system', '<your hostname>.IsActive', 1

or an entry like (simplified in new version, allowed for EMM version >= 21.04):
class, name, value, hostname
jobqueue, execute, 1, null

The meaning of this is, that your OpenEMM Server is allowed to execute the jobqueue jobs (batchjobs).
In EMM version 21.04 both types of entries are allowed, for migration reasons.

Maybe this entry was not properly inserted during configuration of the OpenEMM.