Copying OTRS Data between version 5 and 6 on different servers

Moderator: crythias

Post Reply
retro2707
OTRS wizard
Posts: 131
Joined: 16 Apr 2014, 17:06
OTRS Version?: 6.0.12

Copying OTRS Data between version 5 and 6 on different servers

Post by retro2707 » 12 Oct 2018, 16:00

Hi,

We have an old version 5 machine with OTRS and the KIX addon installed. We wanted to migrate to a new server and put on version 6 (Kix is not supported on that version) but retain the ticket, sla and agent data.

I found a module called DB clone, which only seems to work on a blank db? I really want to import the data into the existing version 6 DB.

Anyway, even creating a new DB on the new version 6 server and trying to export the data there I got the error below.

Any ideas on the points above or the error please?

Thanks!

Code: Select all

ERROR: OTRS-otrs.Console.pl-Maint::Database::Clone-01 Perl: 5.10.1 OS: linux Time: Thu Oct 11 15:08:42 2018

 Message: Table 'otrs-clone.change_freekey' doesn't exist, SQL: '
            SELECT COUNT(*)
            FROM change_freekey'

 Traceback (15802):
   Module: Kernel::System::CloneDB::Driver::Base::RowCount Line: 171
   Module: Kernel::System::CloneDB::Driver::Base::SanityChecks Line: 125
   Module: Kernel::System::CloneDB::Backend::SanityChecks Line: 269
   Module: Kernel::System::Console::Command::Maint::Database::Clone::Run Line: 100
   Module: (eval) Line: 460
   Module: Kernel::System::Console::BaseCommand::Execute Line: 454
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 86
   Module: bin/otrs.Console.pl Line: 38

Error: Died at /opt/otrs/Kernel/System/CloneDB/Driver/Base.pm line 171.
Setup:
OTRS 6.0.12
Hosted on CentOS 7.4/ MySQL - MariaDB (5.5.60)

root
Moderator
Posts: 1350
Joined: 18 Dec 2007, 12:23
OTRS Version?: 4/5/6
Real Name: Roy Kaldung
Company: Znuny Inc.
Contact:

Re: Copying OTRS Data between version 5 and 6 on different servers

Post by root » 12 Oct 2018, 17:26

Hi,

I would try to use the databasedump from OTRS 5 for OTRS 6 and the configuration files (Config.pm, ZZZAuto.pm, TicketCounter.log, etc.) and start a migration form this point. As an alternative you should really consider professional help on this.

- Roy
OTRS 4/5/6 CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

You need professional services? Check out https://www.znuny.com/

retro2707
OTRS wizard
Posts: 131
Joined: 16 Apr 2014, 17:06
OTRS Version?: 6.0.12

Re: Copying OTRS Data between version 5 and 6 on different servers

Post by retro2707 » 15 Oct 2018, 11:25

Thanks Roy,

Will have a look into this.

Brendan
Setup:
OTRS 6.0.12
Hosted on CentOS 7.4/ MySQL - MariaDB (5.5.60)

Post Reply