OTRS 5 para 6

Post Reply
fabricio
OTRS newbie
Posts: 8
Joined: 01 Apr 2019, 22:35
OTRS Version?: version 5
Real Name: Fabricio Araujo da Silva
Company: Quality Software

OTRS 5 para 6

Post by fabricio » 14 May 2019, 21:40

Senhores , boa tarde !

Estou com problemas para atualizar o otrs da versão 5 para 6 , meu ambiente é um Red Hat 6 e Oracle 11 .. SEGUE ABAIXO OS ERROS.

[Tue May 14 14:27:28 2019] DBUpdate-to-6.pl: DBD::Oracle::db do failed: ORA-01400: cannot insert NULL into ("OTRS"."NOTIFICATION_EVENT"." SUBJECT") (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, c hange_by, change_time)
[Tue May 14 14:27:28 2019] DBUpdate-to-6.pl: VALUES
[Tue May 14 14:27:28 2019] DBUpdate-to-6.pl: ('Ticket email delivery failure notification', 1, '', 1, '2019-05-14 18:27:28', 1, '2019 -05-14 18:27:28')"] at /opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-10 Perl: 5.16.3 OS: linux Time: Tue May 14 14:27:28 2019

Message: ORA-01400: cannot insert NULL into ("OTRS"."NOTIFICATION_EVENT"."SUBJECT") (DBD ERROR: OCIStmtExecute), SQL: 'INSERT INTO notif ication_event (name, valid_id, comments, create_by, create_time, change_by, change_time)
VALUES
('Ticket email delivery failure notification', 1, '', 1, '2019-05-14 18:27:28', 1, '2019-05-14 18:27:28')'

Traceback (33144):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 349
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 297
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::UpdateNotificationTables::Run Line: 66
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::Run Line: 134
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: /opt/otrs/scripts/DBUpdate-to-6.pl Line: 89


ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-10 Perl: 5.16.3 OS: linux Time: Tue May 14 14:27:28 2019

Message: Error during execution of 'INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_ time)
VALUES
('Ticket email delivery failure notification', 1, '', 1, '2019-05-14 18:27:28', 1, '2019-05-14 18:27:28')'!

Traceback (33144):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 352
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 297
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::UpdateNotificationTables::Run Line: 66
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::Run Line: 134
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: /opt/otrs/scripts/DBUpdate-to-6.pl Line: 89




Not possible to complete migration, check previous messages for more information.

fcasal
OTRS superhero
Posts: 327
Joined: 21 Apr 2014, 16:14
OTRS Version?: 6.0.18

Re: OTRS 5 para 6

Post by fcasal » 30 May 2019, 06:21

Hola.

Isto parece un problema de como está configurada actualmente a base de datos, como se nalgún momento se fixera unha mala instalación. Qué outras actualizacións se fixeron sobre esa contorna?

Unha posibilidade sería instalar noutra máquina unha versión en limpo do teu otrs 5 actual (co mesmo nivel de parches), exportar coa utilidade do otrs unha copia da base de datos e importala na nova. Vendo que tes Oracle, non será un traballo sinxelo, e quizáis un cambio a mysql/mariadb ou postgresql poida facilitar futuras actualizacións.

Un saludo

fabricio
OTRS newbie
Posts: 8
Joined: 01 Apr 2019, 22:35
OTRS Version?: version 5
Real Name: Fabricio Araujo da Silva
Company: Quality Software

Re: OTRS 5 para 6

Post by fabricio » 31 May 2019, 22:19

Estou fazendo essa mudança.... assim que terminar dou um feedback.

Obrigado.

Post Reply