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.
OTRS update 5 to 6 issue
Moderator: crythias
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: OTRS update 5 to 6 issue
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.
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 6.0.x (private/testing/public) on Linux with MySQL database.
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
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