Errornous jobs after upgrade to 21.04

Use this forum for questions regarding installation, upgrading and configuration of OpenEMM

Moderator: moderator

AndreasT
Posts: 8
Joined: Tue Oct 05, 2021 3:02 pm

Errornous jobs after upgrade to 21.04

Post 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
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Errornous jobs after upgrade to 21.04

Post by maschoff »

Please check with menu 1 if OpenEMM is still running.
OpenEMM Maintainer
AndreasT
Posts: 8
Joined: Tue Oct 05, 2021 3:02 pm

Re: Errornous jobs after upgrade to 21.04

Post 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
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Errornous jobs after upgrade to 21.04

Post 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.
OpenEMM Maintainer
AndreasT
Posts: 8
Joined: Tue Oct 05, 2021 3:02 pm

Re: Errornous jobs after upgrade to 21.04

Post 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
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Errornous jobs after upgrade to 21.04

Post by maschoff »

Strange. Have you tried to restart the stopped jobs via the system status page?
OpenEMM Maintainer
AndreasT
Posts: 8
Joined: Tue Oct 05, 2021 3:02 pm

Re: Errornous jobs after upgrade to 21.04

Post 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.
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Errornous jobs after upgrade to 21.04

Post by maschoff »

Administration > System Status > field "Start job by description" > enter name of job & press button
OpenEMM Maintainer
AndreasT
Posts: 8
Joined: Tue Oct 05, 2021 3:02 pm

Re: Errornous jobs after upgrade to 21.04

Post by AndreasT »

The GUI simply says "ERROR". In the EMM Logfile I can see a Java Exception:

This JobQueueNode is currently not active
AndreasT
Posts: 8
Joined: Tue Oct 05, 2021 3:02 pm

Re: Errornous jobs after upgrade to 21.04

Post by AndreasT »

Is there somewhere a logfile where I can look why the JobQueueNode did not start?
nhondong
Posts: 14
Joined: Tue May 04, 2021 3:39 pm

Re: Errornous jobs after upgrade to 21.04

Post by nhondong »

I have the same error.

Any updates?
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Errornous jobs after upgrade to 21.04

Post by maschoff »

I could not reproduce. Please restart OpenEMM and check the Tomcat log catalina.out in directory /home/openemm/logs for errors.
OpenEMM Maintainer
JuergenB
Posts: 140
Joined: Thu Dec 05, 2019 9:03 pm

Re: Errornous jobs after upgrade to 21.04

Post by JuergenB »

Same here after upgrading 21.04 to 21.10.000.108
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Errornous jobs after upgrade to 21.04

Post by maschoff »

Since we cannot reproduce this problem, we have to dig a little bit deeper.
OpenEMM Maintainer
aso
Posts: 33
Joined: Fri Jun 19, 2015 12:43 pm

Re: Errornous jobs after upgrade to 21.04

Post 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.
Post Reply