OTRS update 5 to 6 issue

Moderator: crythias

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 update 5 to 6 issue

Post by fabricio » 14 May 2019, 21:44

Dear All,

I've a problem when i try to update otrs 5 to 6, my scenario is Red Hat 6, and Bd Oracle 11. please find below the problem when i try to update.


[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.

crythias
Moderator
Posts: 10108
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: OTRS update 5 to 6 issue

Post by crythias » 22 May 2019, 06:34

I don't have enough information to be able to fix.

The short answer appears to be that the column "Subject" is not being filled with a value.

The columns that are filled are:
name, valid_id, comments, create_by, create_time, change_by, change_time

"Subject" is missing, and (apparently) according to the schema, is required to be non-null.
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
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

Post Reply