BUG: DB Upgrade fails if Object STATISTICDETAILS not found

By Alex on Wed, 08/14/2019 - 10:49

Try to upgrade from AS2 1.1 build 51 to AS2 1.1 build 53 failed, because dbupgrade from v39 to v40 ist not successful.

INFORMATION: mendelson opensource AS2 1.1 build 53
Aug 14, 2019 9:23:17 AM de.mendelson.comm.as2.server.AS2Server start
INFORMATION: (c) 2000-2018 mendelson-e-commerce GmbH Berlin, Germany
[Server@1e965684]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1e965684]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1e965684]: [Thread[main,5,main]]: setPort(3333)
[Server@1e965684]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1e965684]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1e965684]: [Thread[main,5,main]]: setDatabasePath(0,AS2_DB_CONFIG)
[Server@1e965684]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1e965684]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1e965684]: [Thread[main,5,main]]: setDatabaseName(0,config)
[Server@1e965684]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1e965684]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1e965684]: [Thread[main,5,main]]: setDatabasePath(1,AS2_DB_RUNTIME)
[Server@1e965684]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1e965684]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1e965684]: [Thread[main,5,main]]: setDatabaseName(1,runtime)
log4j:WARN No appenders could be found for logger (hsqldb.db.HSQLDB3E40B62A58.ENGINE).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Aug 14, 2019 9:23:24 AM de.mendelson.comm.as2.database.DBServer updateDB
INFORMATION: Automatisches Datenbankupdate: Die gefundene DB Version ist 39, die benoetigte ist 41.
Aug 14, 2019 9:23:24 AM de.mendelson.comm.as2.database.DBServer updateDB
INFORMATION: Inkrementelles Datenbankupdate gestartet...
Aug 14, 2019 9:23:24 AM de.mendelson.comm.as2.database.DBServer updateDB
INFORMATION: Beginne Update der runtime DB auf Version 40...
[========= ] 33.33%
Aug 14, 2019 9:23:30 AM de.mendelson.comm.as2.database.DBServer startDBUpdate
WARNUNG: user lacks privilege or object not found: STATISTICDETAILS
Aug 14, 2019 9:23:30 AM de.mendelson.comm.as2.database.DBServer updateDB
INFORMATION: FATAL: Es ist unmoeglich, die DB von der Version 39 zur Version 40 zu modifizieren.

Forum
AS2

Comments

Profile picture for user service

Submitted by service on Thu, 08/15/2019 - 09:07

Alex,

this problem occurs only if you are updating from a really(!) old initial version of the mendelson community AS2. The version must be older than 2008 or 2009. It does not happen for commercial versions updates as these versions have an other database structure.

The easiest workaround is to delete your runtime database, then start the server. mendelson AS2 will create a new, intial runtime database. You will keep your configuration, just the transaction log entries in the overview of the client are lost. The server log files will still exist and also all your inbound transaction data will be kept.

But hey why don't you update to the latest version which is b55 from 01/2019? b53 is from 01/2018?

Regards