[GELÖST] Update auf 4.0.1 DBUpdate-to-4.pl - Step 4 Migrate ProcessManagement EntityIDs

Hilfe zu Znuny Problemen aller Art
Forum rules
Locked
NewUser
Znuny newbie
Posts: 13
Joined: 22 Dec 2015, 17:43
Znuny Version: 3.3.3

[GELÖST] Update auf 4.0.1 DBUpdate-to-4.pl - Step 4 Migrate ProcessManagement EntityIDs

Post by NewUser »

Hallo,

ich bin gerade dabei unser OTRS von 3.1.7 auf 4.0.1 upzugraden. Wenn ich das DBUpdate-to-4.pl Skript ausführe, bekomme ich folgende Fehlermeldung:

Code: Select all

Migration started...

Step 1 of 15: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.

Step 2 of 15: Check framework version... done.

Step 3 of 15: Migrate FontAwesome icons... done.

Step 4 of 15: Migrate ProcessManagement EntityIDs... [Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.pm_process' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.pm_process' doesn't exist, SQL: '
            SELECT id, entity_id
            FROM pm_process
            ORDER BY id'

 Traceback (4144):
   Module: Kernel::System::ProcessManagement::DB::Process::ProcessListGet Line: 878
   Module: main::_MigrateProcessManagementEntityIDs Line: 464
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.pm_activity' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.pm_activity' doesn't exist, SQL: '
            SELECT id, entity_id
            FROM pm_activity
            ORDER BY id'

 Traceback (4144):
   Module: Kernel::System::ProcessManagement::DB::Activity::ActivityListGet Line: 659
   Module: main::_MigrateProcessManagementEntityIDs Line: 467
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.pm_activity_dialog' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.pm_activity_dialog' doesn't exist, SQL: '
            SELECT id, entity_id
            FROM pm_activity_dialog
            ORDER BY id'

 Traceback (4144):
   Module: Kernel::System::ProcessManagement::DB::ActivityDialog::ActivityDialogListGet Line: 652
   Module: main::_MigrateProcessManagementEntityIDs Line: 470
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.pm_transition' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.pm_transition' doesn't exist, SQL: '
            SELECT id, entity_id
            FROM pm_transition
            ORDER BY id'

 Traceback (4144):
   Module: Kernel::System::ProcessManagement::DB::Transition::TransitionListGet Line: 638
   Module: main::_MigrateProcessManagementEntityIDs Line: 473
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.pm_transition_action' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.pm_transition_action' doesn't exist, SQL: '
            SELECT id, entity_id
            FROM pm_transition_action
            ORDER BY id'

 Traceback (4144):
   Module: Kernel::System::ProcessManagement::DB::TransitionAction::TransitionActionListGet Line: 651
   Module: main::_MigrateProcessManagementEntityIDs Line: 476
   Module: ./DBUpdate-to-4.pl Line: 121

ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Need ID or Name!

 Traceback (4144):
   Module: Kernel::System::DynamicField::DynamicFieldGet Line: 250
   Module: main::_MigrateProcessManagementEntityIDs Line: 504
   Module: ./DBUpdate-to-4.pl Line: 121

ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Need ID or Name!

 Traceback (4144):
   Module: Kernel::System::DynamicField::DynamicFieldGet Line: 250
   Module: main::_MigrateProcessManagementEntityIDs Line: 620
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.acl' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.acl' doesn't exist, SQL: '
            SELECT id
            FROM acl ORDER BY id'

 Traceback (4144):
   Module: Kernel::System::ACL::DB::ACL::ACLListGet Line: 743
   Module: main::_MigrateProcessManagementEntityIDs Line: 690
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.pm_entity_sync' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.pm_entity_sync' doesn't exist, SQL: '
        SELECT entity_type, entity_id, sync_state, create_time, change_time
        FROM pm_entity_sync ORDER BY entity_id ASC'

 Traceback (4144):
   Module: Kernel::System::ProcessManagement::DB::Entity::EntitySyncStateList Line: 431
   Module: main::_MigrateProcessManagementEntityIDs Line: 901
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.acl_sync' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.acl_sync' doesn't exist, SQL: '
        SELECT COUNT(*)
        FROM acl_sync'

 Traceback (4144):
   Module: Kernel::System::ACL::DB::ACL::ACLsNeedSync Line: 794
   Module: main::_MigrateProcessManagementEntityIDs Line: 935
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.pm_process' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.pm_process' doesn't exist, SQL: '
            SELECT id, entity_id
            FROM pm_process
            ORDER BY id'

 Traceback (4144):
   Module: Kernel::System::ProcessManagement::DB::Process::ProcessListGet Line: 878
   Module: Kernel::System::ProcessManagement::DB::Process::ProcessDump Line: 1180
   Module: main::_MigrateProcessManagementEntityIDs Line: 968
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.pm_activity' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.pm_activity' doesn't exist, SQL: '
            SELECT id, entity_id
            FROM pm_activity
            ORDER BY id'

 Traceback (4144):
   Module: Kernel::System::ProcessManagement::DB::Activity::ActivityListGet Line: 659
   Module: Kernel::System::ProcessManagement::DB::Process::ProcessDump Line: 1202
   Module: main::_MigrateProcessManagementEntityIDs Line: 968
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.pm_activity_dialog' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.pm_activity_dialog' doesn't exist, SQL: '
            SELECT id, entity_id
            FROM pm_activity_dialog
            ORDER BY id'

 Traceback (4144):
   Module: Kernel::System::ProcessManagement::DB::ActivityDialog::ActivityDialogListGet Line: 652
   Module: Kernel::System::ProcessManagement::DB::Process::ProcessDump Line: 1221
   Module: main::_MigrateProcessManagementEntityIDs Line: 968
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.pm_transition' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.pm_transition' doesn't exist, SQL: '
            SELECT id, entity_id
            FROM pm_transition
            ORDER BY id'

 Traceback (4144):
   Module: Kernel::System::ProcessManagement::DB::Transition::TransitionListGet Line: 638
   Module: Kernel::System::ProcessManagement::DB::Process::ProcessDump Line: 1247
   Module: main::_MigrateProcessManagementEntityIDs Line: 968
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::st execute failed: Table 'otrs2.pm_transition_action' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 584.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.pm_transition_action' doesn't exist, SQL: '
            SELECT id, entity_id
            FROM pm_transition_action
            ORDER BY id'

 Traceback (4144):
   Module: Kernel::System::ProcessManagement::DB::TransitionAction::TransitionActionListGet Line: 651
   Module: Kernel::System::ProcessManagement::DB::Process::ProcessDump Line: 1266
   Module: main::_MigrateProcessManagementEntityIDs Line: 968
   Module: ./DBUpdate-to-4.pl Line: 121

[Fri Jan 22 15:55:25 2016] DBUpdate-to-4.pl: DBD::mysql::db do failed: Table 'otrs2.pm_entity_sync' doesn't exist at /usr/share/otrs/Kernel/System/DB.pm line 442.
ERROR: OTRS-DBUpdate-to-4.pl-10 Perl: 5.22.1 OS: linux Time: Fri Jan 22 15:55:25 2016

 Message: Table 'otrs2.pm_entity_sync' doesn't exist, SQL: '
            DELETE FROM pm_entity_sync'

 Traceback (4144):
   Module: Kernel::System::ProcessManagement::DB::Entity::EntitySyncStatePurge Line: 344
   Module: main::_MigrateProcessManagementEntityIDs Line: 975
   Module: ./DBUpdate-to-4.pl Line: 121

Not a CODE reference at ./DBUpdate-to-4.pl line 981.
Last edited by NewUser on 27 Jan 2016, 16:36, edited 1 time in total.
Top
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Update auf 4.0.1 DBUpdate-to-4.pl - Step 4 Migrate ProcessManagement EntityIDs

Post by RStraub »

Huhu, du das Manual sagt dir, dass man den Migrationspfad einhalten soll/muss:
1.1->1.2->1.3->2.0->2.1->2.2->2.3->2.4->3.0->3.1->3.2->3.3->4.x

Da wirst du dann wohl erst 3.2, dann 3.3. dann 4.latest installieren müssen.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Top
NewUser
Znuny newbie
Posts: 13
Joined: 22 Dec 2015, 17:43
Znuny Version: 3.3.3

Re: Update auf 4.0.1 DBUpdate-to-4.pl - Step 4 Migrate ProcessManagement EntityIDs

Post by NewUser »

Das habe ich befürchtet. Führt wohl kein Weg dran vorbei.
Top
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:
Contact jojo

Re: Update auf 4.0.1 DBUpdate-to-4.pl - Step 4 Migrate ProcessManagement EntityIDs

Post by jojo »

Nein, führt es nicht. Bitte auch immer auf die jeweils letzte Version eines Releases updaten und nicht auf 0.1.

Aktuell ist übrigens OTRS5 und nicht die OTRS4
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Top
KlausNehrer
Znuny ninja
Posts: 1312
Joined: 25 May 2012, 08:51
Znuny Version: OTRS 4
Real Name: Klaus Nehrer

Re: Update auf 4.0.1 DBUpdate-to-4.pl - Step 4 Migrate ProcessManagement EntityIDs

Post by KlausNehrer »

Und wieso fragst Du erst und ignoriert es dann? (viewtopic.php?f=35&t=31293&p=127650#p127650).
Top
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Update auf 4.0.1 DBUpdate-to-4.pl - Step 4 Migrate ProcessManagement EntityIDs

Post by RStraub »

KlausNehrer wrote:Und wieso fragst Du erst und ignoriert es dann? (viewtopic.php?f=35&t=31293&p=127650#p127650).
Evtl. weil ein "Ja" auf eine "Oder" Frage nie ganz eindeutig ist ;)
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Top
NewUser
Znuny newbie
Posts: 13
Joined: 22 Dec 2015, 17:43
Znuny Version: 3.3.3

Re: Update auf 4.0.1 DBUpdate-to-4.pl - Step 4 Migrate ProcessManagement EntityIDs

Post by NewUser »

So ich habe jetzt folgende Versionen installiert (ausgehend von 3.1.7)

-->3.1.21
-->3.2.18
-->3.3.15

Ich versuche gerade das Upgrade auf 4.0.15 aber bekomme folgende Meldung, wenn ich "bin/otrs.CheckDB.pl" ausführe:

Code: Select all

/usr/bin/perl: relocation error: /usr/lib/i386-linux-gnu/perl5/5.22/auto/DBD/mysql/mysql.so: symbol mysql_options4, version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference
Kann mir diesbezüglich jemand weiterhelfen?

VG
Top
NewUser
Znuny newbie
Posts: 13
Joined: 22 Dec 2015, 17:43
Znuny Version: 3.3.3

Re: Update auf 4.0.1 DBUpdate-to-4.pl - Step 4 Migrate ProcessManagement EntityIDs

Post by NewUser »

So das Problem hat sich jetzt von alleine gelöst. Das komplette Debian war etwas veraltet und hat ein Upgrade gebraucht. Nachdem ich die anderen Updates nachgezogen hatte, hat auch das Upgrade auf OTRS 4.0.15 funktioniert.

Vielen Dank für die Hilfe.
Top
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: [GELÖST] Update auf 4.0.1 DBUpdate-to-4.pl - Step 4 Migrate ProcessManagement EntityIDs

Post by RStraub »

NIcht aufhören, ein Upgrade hast noch vor dir :)
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Top
NewUser
Znuny newbie
Posts: 13
Joined: 22 Dec 2015, 17:43
Znuny Version: 3.3.3

Re: [GELÖST] Update auf 4.0.1 DBUpdate-to-4.pl - Step 4 Migrate ProcessManagement EntityIDs

Post by NewUser »

Schon geschehen :D
Top
Locked

Return to “Hilfe”