topic DB Upgrade to 5.9 fails on PostgreSQL Database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/db-upgrade-to-5-9-fails-on-postgresql-database/m-p/84185#M56634 <HTML><HEAD></HEAD><BODY><SPAN>DB Upgrade to 5.9 fails on PostgreSQL Database with the following Exception:</SPAN><BR /><BR /><SPAN>"couldn't upgrade db schema: update ACT_GE_BYTEARRAY set GENERATED_ = 0"</SPAN><BR /><BR /><SPAN>Resulting in PSQLException</SPAN><BR /><SPAN>"FEHLER: Spalte »generated_« hat Typ boolean, aber der Ausdruck hat Typ integer</SPAN><BR /><SPAN>&nbsp; Hinweis: Sie müssen den Ausdruck umschreiben oder eine Typumwandlung vornehmen.</SPAN><BR /><SPAN>&nbsp; Position: 42"</SPAN><BR /><BR /><SPAN>The problem is in "activiti.postgres.upgradestep.58.to.59.engine.sql"</SPAN><BR /><BR /><SPAN>Line 58:</SPAN><BR /><BR /><SPAN>update ACT_GE_BYTEARRAY set GENERATED_ = 0;</SPAN><BR /><BR /><SPAN>should be</SPAN><BR /><BR /><SPAN>update ACT_GE_BYTEARRAY set GENERATED_ = false;</SPAN><BR /><BR /><BR /><SPAN>Kind regards</SPAN><BR /><SPAN>Philipp Eichhorn</SPAN></BODY></HTML> Tue, 12 Jun 2012 08:10:03 GMT pcsquirrel 2012-06-12T08:10:03Z DB Upgrade to 5.9 fails on PostgreSQL Database https://connect.hyland.com/t5/alfresco-archive/db-upgrade-to-5-9-fails-on-postgresql-database/m-p/84185#M56634 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&nbsp; Hinweis: Sie müssen den Ausdruck umschreiben Tue, 12 Jun 2012 08:10:03 GMT https://connect.hyland.com/t5/alfresco-archive/db-upgrade-to-5-9-fails-on-postgresql-database/m-p/84185#M56634 pcsquirrel 2012-06-12T08:10:03Z Re: DB Upgrade to 5.9 fails on PostgreSQL Database https://connect.hyland.com/t5/alfresco-archive/db-upgrade-to-5-9-fails-on-postgresql-database/m-p/84186#M56635 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for reporting. Fixed in </SPAN><A href="http://jira.codehaus.org/browse/ACT-1143" rel="nofollow noopener noreferrer">http://jira.codehaus.org/browse/ACT-1143</A></BODY></HTML> Wed, 13 Jun 2012 08:08:01 GMT https://connect.hyland.com/t5/alfresco-archive/db-upgrade-to-5-9-fails-on-postgresql-database/m-p/84186#M56635 frederikherema1 2012-06-13T08:08:01Z