error in DB schema update during migration to 4.0.5

Moderator: crythias

Locked
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

error in DB schema update during migration to 4.0.5

Post by aph »

I'm in the process of migrating from 3.3.9 to 4.0.5 following this guide http://otrs.github.io/doc/manual/admin/ ... ading.html

I got stuck at step 6, at step 6.2 to be precise. I get the following error when running DBUpdate-to-4.pl script

Code: Select all

Step 4 of 15: Migrate ProcessManagement EntityIDs... [Tue Feb  3 14:04:41 2015] DBUpdate-to-4.pl: Kernel::System::Time does not declare its object dependencies! at /opt/otrs/Kernel/System/DB.pm line 411
Kernel::System::Time does not declare its object dependencies! at /opt/otrs/Kernel/System/ObjectManager.pm line 537
        Kernel::System::ObjectManager::_DieWithError('Kernel::System::ObjectManager=HASH(0xaad218)', 'Error', 'Kernel::System::Time does not declare its object dependencies!') called at /opt/otrs/Kernel/System/ObjectManager.pm line 208
        Kernel::System::ObjectManager::_ObjectBuild('Kernel::System::ObjectManager=HASH(0xaad218)', 'Package', 'Kernel::System::Time') called at /opt/otrs/Kernel/System/ObjectManager.pm line 176
        Kernel::System::ObjectManager::Get('Kernel::System::ObjectManager=HASH(0xaad218)', 'Kernel::System::Time') called at /opt/otrs/Kernel/System/DB.pm line 411
        Kernel::System::DB::Do('Kernel::System::DB=HASH(0x2ba84c0)', 'SQL', 'SET NAMES utf8') called at /opt/otrs/Kernel/System/DB.pm line 200
        Kernel::System::DB::Connect('Kernel::System::DB=HASH(0x2ba84c0)') called at /opt/otrs/Kernel/System/DB.pm line 155
        Kernel::System::DB::new('Kernel::System::DB') called at /opt/otrs/Kernel/System/ObjectManager.pm line 222
        Kernel::System::ObjectManager::_ObjectBuild('Kernel::System::ObjectManager=HASH(0xaad218)', 'Package', 'Kernel::System::DB') called at /opt/otrs/Kernel/System/ObjectManager.pm line 176
        Kernel::System::ObjectManager::Get('Kernel::System::ObjectManager=HASH(0xaad218)', 'Kernel::System::DB') called at /opt/otrs/Kernel/System/ProcessManagement/DB/ActivityDialog.pm line 61
        Kernel::System::ProcessManagement::DB::ActivityDialog::new('Kernel::System::ProcessManagement::DB::ActivityDialog') called at /opt/otrs/Kernel/System/ProcessManagement/DB/Process.pm line 68
        Kernel::System::ProcessManagement::DB::Process::new('Kernel::System::ProcessManagement::DB::Process') called at DBUpdate-to-4.pl line 455
        main::_MigrateProcessManagementEntityIDs() called at DBUpdate-to-4.pl line 121
I installed otrs-4.0.5-01.noarch.rpm. The mysql database version is 5.1.73 and storage engine is MyISAM

How do I rectify these errors?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: error in DB schema update during migration to 4.0.5

Post by aph »

Any idea as to why the database migration fails with the mentioned error?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: error in DB schema update during migration to 4.0.5

Post by aph »

I hate to bump the thread, but any pointers as to why this error may be occuring? As far as I can see, I followed the migration guide to the point
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: error in DB schema update during migration to 4.0.5

Post by aph »

any ideas on this one?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: error in DB schema update during migration to 4.0.5

Post by crythias »

A search leads to custom code (Kernel/Custom?) might not be fully set with current API.

Short: It shouldn't be happening in stock code.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: error in DB schema update during migration to 4.0.5

Post by aph »

Thank you.

As a matter of fact there was a file Time.pm in the ..../Custom/Kernel/Config directory. I have removed that file and was able to successfully run bin/otrs.CheckDB.pl. and scripts/DBUpdate-to-4.mysql.sql

The migration was successful :)
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
Locked