DBUpdate-to-5.pl fails upgrade from 4.0.1

[fRd]

Hello,

I'm trying to the tarball upgrade towards version 5.0.1 on a Debian system.

When running the DBUpdate-to-5.pl script it fails in Step3. I believe there is a rights problem on the database (PostgreSQL)
Maybe important to know is that this is an OTRS appliance which unfortunately has no out of the box support for upgrades to OTRS 5.

The error which is thrown is:
Step 3 of 16: Migrate Database Column Types...[Tue Feb 23 16:54:11 2016] DBUpdate-to-5.pl: DBD::Pg::db do failed: FEHLER: Berechtigung nur für Eigentümer der Relation scheduler_task at /TARGET/SHARE/opt/otrs/Kernel/System/DB.pm line 449.
ERROR: OTRS-DBUpdate-to-5.pl-86 Perl: 5.10.1 OS: linux Time: Tue Feb 23 16:54:11 2016

Message: FEHLER: Berechtigung nur für Eigentümer der Relation scheduler_task, SQL: 'ALTER TABLE scheduler_task ALTER id TYPE BIGINT'

Traceback (4168):
Module: main::_MigrateDatabaseColumnTypes Line: 330
Module: ./DBUpdate-to-5.pl Line: 158

ERROR: OTRS-DBUpdate-to-5.pl-86 Perl: 5.10.1 OS: linux Time: Tue Feb 23 16:54:11 2016

Message: Error during execution of 'ALTER TABLE scheduler_task ALTER id TYPE BIGINT'!

Traceback (4168):
Module: main::_MigrateDatabaseColumnTypes Line: 332
Module: ./DBUpdate-to-5.pl Line: 158

error.

[Tue Feb 23 16:54:11 2016] DBUpdate-to-5.pl: Died at ./DBUpdate-to-5.pl line 163.


Anyone an idea how to solve this?

Thanks!
Fred

[JeremyB3ntham]

DId you set the permissions?

bin/otrs.SetPermissions.pl

Also, check the DB connection: bin/otrs.CheckDB.pl

[fRd]

Hi Jeremy, thanks for the reply.

I finally found some time to try the upgrade again, but resulted in the same error.

SetPermissions --> I have done this.
CheckDB --> This script is not present in my bin folder. I verified it also from the downloaded tarball and the script isn't present there either...

Any other suggestions?

UPDATE:
We migrated the complete OTRS system a fresh installed CentOS system with a fresh installed OTRS and now have a healthy upgradeable system.

Thanks!
KR,
fRd