Migrated to OTRS appliance 4.0.3

[ltkvien]

Hi All,

I have OTRS 3.3.11 which is installed on Windows Server 2012 and I'd like to migrate to OTRS appliance 4.0.3 (installed as a virtual machine). When I run the command perl otrs.OTRSCloneDB.pl -r, it runs with the error below:

[Wed Dec 17 17:39:45 2014] otrs.CloneDB.pl: HINWEIS: CREATE TABLE / PRIMARY KEY erstellt implizit einen Index \x{00c2}»faq_voting_pkey\x{00c2}« f\x{00c3}¼r Tabelle \x{00c2}»faq_voting\x{00c2}«
.[Wed Dec 17 17:39:45 2014] otrs.CloneDB.pl: DBD::Pg::db do failed: FEHLER: Relation \x{00c2}»faq_voting\x{00c2}« existiert bereits at D:/otrs/OTRS/Kernel/System/DB.pm line 495.
ERROR: OTRS-otrs.CloneDB.pl-77 Perl: 5.16.3 OS: MSWin32 Time: Wed Dec 17 17:39:45 2014

Message: FEHLER: Relation \x{00c2}»faq_voting\x{00c2}« existiert bereits, SQL: 'CREATE INDEX faq_voting ON faq_voting (item_id)'

Traceback (4532): Module: Kernel::System::CloneDB::Backend::PopulateTargetStructuresPre (OTRS 3.3.11) Line: 416
Module: D:\otrs\OTRS\bin\otrs.CloneDB.pl (unknown version) Line: 75

.[Wed Dec 17 17:39:45 2014] otrs.CloneDB.pl: ERROR: Could not generate structures in target database!
[Wed Dec 17 17:39:45 2014] otrs.CloneDB.pl: Please make sure the target database is empty.

Kindly help.

[ltkvien]

When I run the command perl otrs.CloneDB.pl -r and receive this error at the phase 1/2:

At the command line, the error is:

-20 16:43:03] Creating structures in target database (phase 1/2)[Sat Dec 20 16:43:03 2014] otrs.CloneDB.pl: HINWEIS: CREATE TABLE erstellt implizit eine Sequenz \x{00c2}»acl_id_seq1\x{00c2}« f\x{00c3}¼r die \x{00c2}»serial\x{00c2}«-Spalte \x{00c2}»acl.id\x{00c2}«
[Sat Dec 20 16:43:03 2014] otrs.CloneDB.pl: DBD::Pg::db do failed: FEHLER: Relation \x{00c2}»acl\x{00c2}« existiert bereits at D:/otrs/OTRS/Kernel/System/DB.pm line 499.

In the log file, I found that information as below:

[Error][Kernel::System::CloneDB::Backend::PopulateTargetStructuresPre][416] FEHLER: Relation »acl« existiert bereits, SQL: 'CREATE TABLE acl (
id serial NOT NULL,
name VARCHAR (200) NOT NULL,
comments VARCHAR (250) NULL,
description VARCHAR (250) NULL,
valid_id INTEGER NOT NULL,
stop_after_match INTEGER NULL,
config_match TEXT NULL,
config_change TEXT NULL,
create_time timestamp(0) NOT NULL,
create_by INTEGER NOT NULL,
change_time timestamp(0) NOT NULL,
change_by INTEGER NOT NULL,
PRIMARY KEY(id),
CONSTRAINT acl_name UNIQUE (name)
)'

[Rooobaaat]

The error

.[Wed Dec 17 17:39:45 2014] otrs.CloneDB.pl: ERROR: Could not generate structures in target database!
[Wed Dec 17 17:39:45 2014] otrs.CloneDB.pl: Please make sure the target database is empty.

says everything...

Please follow the migration guide on:
http://otrs.github.io/doc/manual/admin/ ... -appliance

Drop the existing database of your appliance to have an empty database for the clone data

The OTRSCloneDB script will not remove the data in the existing otrs database of the appliance, so we need to do this manually

[ltkvien]

The error

.[Wed Dec 17 17:39:45 2014] otrs.CloneDB.pl: ERROR: Could not generate structures in target database!
[Wed Dec 17 17:39:45 2014] otrs.CloneDB.pl: Please make sure the target database is empty.

says everything...

Please follow the migration guide on:
http://otrs.github.io/doc/manual/admin/ ... -appliance

Drop the existing database of your appliance to have an empty database for the clone data

The OTRSCloneDB script will not remove the data in the existing otrs database of the appliance, so we need to do this manually

Hi Rooobaaat, thanks for your time, but I've already dropped the otrs database as the manual before. Now I have 2 errors, 1 error was Wednesday (it gone), 1 error is today:

20 16:43:03] Creating structures in target database (phase 1/2)[Sat Dec 20 16:43:03 2014] otrs.CloneDB.pl: HINWEIS: CREATE TABLE erstellt implizit eine Sequenz \x{00c2}»acl_id_seq1\x{00c2}« f\x{00c3}¼r die \x{00c2}»serial\x{00c2}«-Spalte \x{00c2}»acl.id\x{00c2}«
[Sat Dec 20 16:43:03 2014] otrs.CloneDB.pl: DBD::Pg::db do failed: FEHLER: Relation \x{00c2}»acl\x{00c2}« existiert bereits at D:/otrs/OTRS/Kernel/System/DB.pm line 499.

[eandrex]

you want to migrate your current OTRS 3.3 to OTRS Appliance 4.0.3.

Ok, i havent used OTRS Applianche.. but by "4.0.3" i assume it is running OTRS 4.0.3.. so
you should update your curren OTRS 3.3 to OTRS 4.0.3..after that, you should do a backup of your database an restored it in your OTRS appliance..

however, if you are using MSSQL Server, you do need OTRSCloneDB

[ltkvien]

you want to migrate your current OTRS 3.3 to OTRS Appliance 4.0.3.

Ok, i havent used OTRS Applianche.. but by "4.0.3" i assume it is running OTRS 4.0.3.. so
you should update your curren OTRS 3.3 to OTRS 4.0.3..after that, you should do a backup of your database an restored it in your OTRS appliance..

however, if you are using MSSQL Server, you do need OTRSCloneDB

OK eandrex, thanks for your info. I tried a lot of ways, but still stuck in the clonedb.pl phase 1. I tried to update my windows based OTRS 3.3.9 to 3.3.11 and clonedb to OTRS appliance 3.3.11, it doesn't work. And I tried to install OTRS appliance 3.3.9 and migrate the database from OTRS windows 3.3.9 to appliance 3.3.9, it doesn't work, too.
Now I just want to install another server with OTRS appliance 3.3.9 and clonedb from my windows based OTRS 3.3.9 to it.

[ardli]

same problem with me
viewtopic.php?f=62&t=27601

[beastmoar]

Hello,

i have the same Problem. Switching from OTRS 3.3.8 Windows to 3.3.8 Appliance... When you deinstall the FAQ Paket, then it works for me...
But how do i get these CloneDB with FAQ-Data? Any Ideas?

Greetings
Alex

[maridispi]

Hi

I'm on the same issue cloning the DB to the Appliance. My OTRS Windows and Appliance Version 3.3.10 and stopping on the FAQ tables:

***********
ERROR: OTRS-otrs.CloneDB.pl-11 Perl: 5.12.3 OS: MSWin32 Time: Fri Feb 13 11:46:3
4 2015
Message: FEHLER: Relation »faq_voting« existiert bereits, SQL: 'CREATE INDEX
faq_voting ON faq_voting (item_id)'
Traceback (3344):
Module: Kernel::System::CloneDB::Backend::PopulateTargetStructuresPre (OTRS 3
.3.10) Line: 416
Module: otrs.CloneDB.pl (unknown version) Line: 75
.[Fri Feb 13 11:46:34 2015] otrs.CloneDB.pl: ERROR: Could not generate structure
s in target database!
[Fri Feb 13 11:46:34 2015] otrs.CloneDB.pl: Please make sure the target database
is empty.
*************

I've dropped the existing database and recreate it according to the upgrade guide. When i check the the new created otrs db before i run the CloneDB Script, it say's me there are no table into the DB:

Code: Select all

postgres=#
postgres=# \connect otrs
psql (8.4.21)
Sie sind jetzt verbunden mit der Datenbank »otrs«.
otrs=# SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';
 table_name
------------
(0 Zeilen)

[jojo]

yes, this is a bug in FAQ 3x

[maridispi]

yes, this is a bug in FAQ 3x

Thank you.
And what can I do? update first the otrs instance on the Win OS to 4.0.x / FAQ 4.0.1 and then migrate to the appliance?

[jojo]

currently the database migration script is not ported to OTRS4

[eturconi]

Guys.... What do u suggest to fix the issue above?
Regards
Emanuele

[crythias]

For db migration, It seems reasonable to do a standard dump and import, akin to disaster recovery procedures.
I, personally, haven't used clonedb, so I can't comment further.

[eturconi]

Hi crythias,
my issue is related to the fact i'm migrating from mysql to postgres and when I try to import, postgres give me a lot of syntax errors
CloneDB is not working either due to the issue described above: could you please suggest me how to procede my migrations?
Thanks to everyone

I'm migrating from Windows MYSQL OTRS 3.3.5 to OTRS 3.3.5
Faq module 2.3.1

[crythias]

Converting between MySQL and postgres is likely outside the scope of this forum.