I did an inplace upgrade from 19.10 to 20.04.
I was using the command line installer and the status in the installer seems ok
Code: Select all
================================
= OpenEMM Installer v20.04.003 =
================================
Host: nl.gesext.de
License: OpenEMM (ID: 0)
Runtime Version: 20.04.000.043
Manual Version: 20.04.011
OpenEMM Version: 20.04.000.155
System-Url: https://nl.mydomain.tld
Code: Select all
License "OpenEMM" (ID: 0, Type: Inhouse)
Hostname nl.mydomain.tld
Java Version 1.8.0_252 (Oracle Corporation)
EMM Version 20.04.000.155
Temp Directory /home/openemm/temp
Install Path /home/openemm/release/emm/openemm-gui-20.04.000.155/
System Time 03.08.2020 12:37:03
Build Time 25.06.2020 09:29:24
Start Up Time 03.08.2020 12:36:06
Up Time 57 Sekunden
Configuration
Expiration Time 03.08.2020 12:41:28
DB Type MariaDB
DB URL jdbc:mariadb://127.0.0.1/openemm?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8
1)
The system status in the gui shows a general error because of a database error.
database seems to work - e.g. I can review old mailings. But the status screen shows this:
Code: Select all
Datenbank
Version Status
19.07.420 is Missing
19.10.270 is Missing
19.10.295 is Missing
20.01.008 OK
20.01.018 is Missing
20.01.023 OK
20.01.062 OK
20.01.225 OK
20.01.257 OK
20.01.300 OK
20.01.315 OK
20.01.460 is Missing
20.01.504 OK
I can look at the statistics of a single mailing, but if I want to compare 2 mailings, I do get the following. Is this connected or a different issue?
Code: Select all
The following items have errors:
ReportDesign (id = 1):
+ Invalid javascript expression: Wrapped org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT COALESCE(bounces_hard, 0) bounces, mailing_id FROM benchmark_mailing_stat_tbl WHERE company_id = ? and mailing_id in (126,127) ORDER BY days_between DESC]; nested exception is java.sql.SQLSyntaxErrorException: (conn=26) Table 'openemm.benchmark_mailing_stat_tbl' doesn't exist (/report/method[@name="initialize"]#16)
ReportDesign (id = 1):
+ There are errors evaluating script "importPackage(Packages.com.agnitas.reporting.birt.external.dataset);
mailingCompareDataSet = new Packages.com.agnitas.reporting.birt.external.dataset.MailingCompareDataSet();
mailingCompareData = mailingCompareDataSet.getSummaryData(reportContext.getPersistentGlobalVariable("tempTableID"), reportContext.getLocale());
currentrow = 0;":
Fail to execute script in function __bm_OPEN(). Source:
------
" + importPackage(Packages.com.agnitas.reporting.birt.external.dataset);
mailingCompareDataSet = new Packages.com.agnitas.reporting.birt.external.dataset.MailingCompareDataSet();
mailingCompareData = mailingCompareDataSet.getSummaryData(reportContext.getPersistentGlobalVariable("tempTableID"), reportContext.getLocale());
currentrow = 0; + "
-----
A BIRT exception occurred. See next exception for more information.
Can't find method com.agnitas.reporting.birt.external.dataset.MailingCompareDataSet.getSummaryData(null,java.util.Locale). (/report/data-sets/script-data-set[@id="754"]/method[@name="open"]#3).
+ There are errors evaluating script "if(currentrow >= mailingCompareData.size()) {
return false;
}
row["category"] = Packages.com.agnitas.messages.I18nString.getLocaleString(mailingCompareData.get(currentrow).getCategory(), reportContext.getLocale());
row["category_index"] = mailingCompareData.get(currentrow).getCategoryindex();
row["mailing_id"] = mailingCompareData.get(currentrow).getMailingId();
row["mailing_name"] = mailingCompareData.get(currentrow).getMailingName();
row["mailing_name_full"] = mailingCompareData.get(currentrow).getMailingNameFull();
row["value"] = mailingCompareData.get(currentrow).getCount();
row["rate"] = mailingCompareData.get(currentrow).getRate();
row["target_id"] = mailingCompareData.get(currentrow).getTargetGroupId();
row["target_name"] = "fdsfd";// mailingCompareData.get(currentrow).getTargetGroupName();
row["target_index"] = mailingCompareData.get(currentrow).getTargetGroupIndex();
if (row["target_index"] == 1) {
row["target_name_short"] = Packages.com.agnitas.messages.I18nString.getLocaleString(mailingCompareData.get(currentrow).getTargetShortName(), reportContext.getLocale());
}
else {
row["target_name_short"] = mailingCompareData.get(currentrow).getTargetShortName();
}
currentrow++;
return true;":
Fail to execute script in function __bm_FETCH(). Source:
------
" + if(currentrow >= mailingCompareData.size()) {
return false;
}
row["category"] = Packages.com.agnitas.messages.I18nString.getLocaleString(mailingCompareData.get(currentrow).getCategory(), reportContext.getLocale());
row["category_index"] = mailingCompareData.get(currentrow).getCategoryindex();
row["mailing_id"] = mailingCompareData.get(currentrow).getMailingId();
row["mailing_name"] = mailingCompareData.get(currentrow).getMailingName();
row["mailing_name_full"] = mailingCompareData.get(currentrow).getMailingNameFull();
row["value"] = mailingCompareData.get(currentrow).getCount();
row["rate"] = mailingCompareData.get(currentrow).getRate();
row["target_id"] = mailingCompareData.get(currentrow).getTargetGroupId();
row["target_name"] = "fdsfd";// mailingCompareData.get(currentrow).getTargetGroupName();
row["target_index"] = mailingCompareData.get(currentrow).getTargetGroupIndex();
if (row["target_index"] == 1) {
row["target_name_short"] = Packages.com.agnitas.messages.I18nString.getLocaleString(mailingCompareData.get(currentrow).getTargetShortName(), reportContext.getLocale());
}
else {
row["target_name_short"] = mailingCompareData.get(currentrow).getTargetShortName();
}
currentrow++;
return true; + "
-----
A BIRT exception occurred. See next exception for more information.
ReferenceError: "mailingCompareData" is not defined. (/report/data-sets/script-data-set[@id="754"]/method[@name="fetch"]#1).
+ Data Set script method "Fetch" returned null; expected a Boolean value.
Any idea where to look for the error? The 19 version was ok in these fields, but something was not upgraded correctly.
python3 is 3.8.5
After upgrading, however, I had to add some URLs to the config as these were undefined.
Code: Select all
birt.url.intern = https://nl.mydomain.tld:8080/birt
webservices.url = https://nl.mydomain.tld/2.0/
Robert