[SOLVED] Errors on DBUpdate-to-5.pl From 4.0.x to 5.0.6

Moderator: crythias

Post Reply
Giulio Soleni
Znuny wizard
Posts: 392
Joined: 30 Dec 2010, 14:35
Znuny Version: 6.0.x and 5.0.x
Real Name: Giulio Soleni
Company: IKS srl

[SOLVED] Errors on DBUpdate-to-5.pl From 4.0.x to 5.0.6

Post by Giulio Soleni »

Hi,
I am trying to update my test system on CentOS 6.7 OTRS 4.0.8 with ITSM and FAQ (4.0.2) to the last available version today (5.0.6).
The db is MySQL 5.6.29.
I followed the usual procedure (http://otrs.github.io/doc/manual/admin/ ... ading.html) ... by the way there is a small error in the step 6.1 since manual ask to run scripts/DBUpdate-to-5.mysql.sql stored procedure before checking for db availability ... but that's not my issue.

As soon as I run database migration script DBUpdate-to-5.pl I got a bunch of errors:

Code: Select all

[otrs@x-otrs ~]$ scripts/DBUpdate-to-5.pl

Migration started...

Step 1 of 17: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.

Step 2 of 17: Check framework version...done.

Step 3 of 17: Migrate Database Column Types...done.

Step 4 of 17: Migrate charset to UTF-8 on auto_response table...done.

Step 5 of 17: Migrate charset to UTF-8 on notification_event table...done.

Step 6 of 17: Migrate event based notifications to support multiple languages...done.

Step 7 of 17: Migrate notifications to event based notifications...done.

Step 8 of 17: Migrate send notification user preferences...done.

Step 9 of 17: Add Email notification method to all event based notifications...done.

Step 10 of 17: Migrate Output configurations to the new module locations...
--- Toolbar modules...[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
...done.
--- Ticket menu modules...[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
...done.
--- Ticket overview menu modules......done.
--- Ticket overview modules......done.
--- Preferences group modules...[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
...done.
--- SLA/Service/Queue preference modules......done.
--- Article pre view modules......done.
--- NavBar menu modules......done.
--- NavBar ModuleAdmin modules...[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
...done.
--- Dashboard modules...[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
...done.
--- Customer user generic modules...[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
...done.
--- FilterText modules......done.
done.

Step 11 of 17: Add TicketZoom menu cluster configurations...[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 13:17:41 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
...done.
done.

Step 12 of 17: Fixup statistics time field configuration where the time interval is too small...
Updated statistic 105 (ITSMChange Count Changes).
Updated statistic 106 (ITSMChange Changes per Category).
Updated statistic 107 (ITSMChange rejected changes).
Updated statistic 108 (ITSMChange retracted changes).
Updated statistic 109 (Relation Tickets (by types) <-> Changes).
Updated statistic 110 (RfCs per Requester).
done.

Step 13 of 17: Fixup wrong notification tags...done.

Step 14 of 17: Fixup dashboard statistics output format configuration...
done.

Step 15 of 17: Uninstall Merged Feature Add-Ons...done.

Step 16 of 17: Clean up the cache...done.

Step 17 of 17: Refresh configuration cache another time...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.

Migration completed!
On a next attempt to run the same script the number of "does not map to Unicode at..." issues is reduced, but still persists...

Code: Select all

[otrs@x-otrs ~]$ scripts/DBUpdate-to-5.pl

Migration started...

Step 1 of 17: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.

Step 2 of 17: Check framework version...done.

Step 3 of 17: Migrate Database Column Types...done.

Step 4 of 17: Migrate charset to UTF-8 on auto_response table...done.

Step 5 of 17: Migrate charset to UTF-8 on notification_event table...done.

Step 6 of 17: Migrate event based notifications to support multiple languages...done.

Step 7 of 17: Migrate notifications to event based notifications...done.

Step 8 of 17: Migrate send notification user preferences...done.

Step 9 of 17: Add Email notification method to all event based notifications...done.

Step 10 of 17: Migrate Output configurations to the new module locations...
--- Toolbar modules......done.
--- Ticket menu modules......done.
--- Ticket overview menu modules......done.
--- Ticket overview modules......done.
--- Preferences group modules......done.
--- SLA/Service/Queue preference modules......done.
--- Article pre view modules......done.
--- NavBar menu modules......done.
--- NavBar ModuleAdmin modules......done.
--- Dashboard modules......done.
--- Customer user generic modules...[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
...done.
--- FilterText modules......done.
done.

Step 11 of 17: Add TicketZoom menu cluster configurations...[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE8" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 302.
[Sun Feb 14 17:11:04 2016] DBUpdate-to-5.pl: utf8 "\xE0" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 471, <$In> line 441.
...done.
done.

Step 12 of 17: Fixup statistics time field configuration where the time interval is too small...
done.

Step 13 of 17: Fixup wrong notification tags...done.

Step 14 of 17: Fixup dashboard statistics output format configuration...
done.

Step 15 of 17: Uninstall Merged Feature Add-Ons...done.

Step 16 of 17: Clean up the cache...done.

Step 17 of 17: Refresh configuration cache another time...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.

Migration completed!
[otrs@x-otrs ~]$
I also tried successfully to update the system to the last available OTRS 4 version (4.0.15 today) before updating it to 5.0.6 but the results are the same.

What could have triggered that kind of errors?

Thank you in advance for your help!
Giulio
Last edited by Giulio Soleni on 20 Feb 2016, 20:18, edited 1 time in total.
OTRS 6.0.x on CentOS 7.x with MariaDB 10.2.x database connected to an Active Directory for Agents and Customers.
ITSM and FAQ modules installed.
Top
Giulio Soleni
Znuny wizard
Posts: 392
Joined: 30 Dec 2010, 14:35
Znuny Version: 6.0.x and 5.0.x
Real Name: Giulio Soleni
Company: IKS srl

Re: Errors on DBUpdate-to-5.pl From 4.0.x to 5.0.6

Post by Giulio Soleni »

after removing /opt/otrs/Kernel/Config/Files/ZZZAuto.pm and triggering a rebuild:

Code: Select all

/opt/otrs/bin/otrs.Console.pl Maint::Config::Rebuild
scripts/DBUpdate-to-5.pl gives no errors ...
however errors have gone... along with all my configurations :(

The strange thing is the present configurations look fine in OTRS 4.0.x and I went through several updates without any similar issue so far.
OTRS 6.0.x on CentOS 7.x with MariaDB 10.2.x database connected to an Active Directory for Agents and Customers.
ITSM and FAQ modules installed.
Top
Giulio Soleni
Znuny wizard
Posts: 392
Joined: 30 Dec 2010, 14:35
Znuny Version: 6.0.x and 5.0.x
Real Name: Giulio Soleni
Company: IKS srl

Re: Errors on DBUpdate-to-5.pl From 4.0.x to 5.0.6

Post by Giulio Soleni »

Fixed after checking a couple of lines in my /opt/otrs/Kernel/Config/Files/ZZZAuto.pm
I actually had a couple characters apparently corrupted (at line 302 and line 441 as detected by the DBUpdate-to-5.pl script
OTRS 6.0.x on CentOS 7.x with MariaDB 10.2.x database connected to an Active Directory for Agents and Customers.
ITSM and FAQ modules installed.
Top
Post Reply

Return to “Help”