AnsweredAssumed Answered

DB Upgrade to 5.9 fails on PostgreSQL Database

Question asked by pcsquirrel on Jun 12, 2012
Latest reply on Jun 13, 2012 by frederikheremans1
DB Upgrade to 5.9 fails on PostgreSQL Database with the following Exception:

"couldn't upgrade db schema: update ACT_GE_BYTEARRAY set GENERATED_ = 0"

Resulting in PSQLException
"FEHLER: Spalte »generated_« hat Typ boolean, aber der Ausdruck hat Typ integer
  Hinweis: Sie müssen den Ausdruck umschreiben oder eine Typumwandlung vornehmen.
  Position: 42"

The problem is in "activiti.postgres.upgradestep.58.to.59.engine.sql"

Line 58:

update ACT_GE_BYTEARRAY set GENERATED_ = 0;

should be

update ACT_GE_BYTEARRAY set GENERATED_ = false;


Kind regards
Philipp Eichhorn

Outcomes