DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Moderator: crythias

Post Reply
brunocampos87
Znuny newbie
Posts: 3
Joined: 02 Feb 2018, 14:19
Znuny Version: fives
Real Name: bruno
Company: ufpb

DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Post by brunocampos87 »

Friends,

Good morning!!

I have a problem

I follow the steps of tutorial on website otrs

When i run script DBUpdate-to-6.pl in the step 8: Step 8 of 37: Migrate configuration ... show this message:

DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1.


How can i fix this?
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Post by reneeb »

Did you check that all tables are utf8?
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
brunocampos87
Znuny newbie
Posts: 3
Joined: 02 Feb 2018, 14:19
Znuny Version: fives
Real Name: bruno
Company: ufpb

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Post by brunocampos87 »

Yes.

I dont understand very well.

At the same time, in the log of mysql show me this:

/var/log/mysql/error.log




180201 11:55:48 InnoDB: ERROR: the age of the last checkpoint is 9434075,

InnoDB: which exceeds the log group capacity 9433498.

InnoDB: If you are using big BLOB or TEXT rows, you must set the

InnoDB: combined size of log files at least 10 times bigger than the

InnoDB: largest such row.

180201 11:56:04 InnoDB: ERROR: the age of the last checkpoint is 9437612,

InnoDB: which exceeds the log group capacity 9433498.

InnoDB: If you are using big BLOB or TEXT rows, you must set the

InnoDB: combined size of log files at least 10 times bigger than the

InnoDB: largest such row.

180201 11:56:20 InnoDB: ERROR: the age of the last checkpoint is 9434135,

InnoDB: which exceeds the log group capacity 9433498.

InnoDB: If you are using big BLOB or TEXT rows, you must set the

InnoDB: combined size of log files at least 10 times bigger than the

InnoDB: largest such row.

180201 11:56:43 InnoDB: ERROR: the age of the last checkpoint is 9449825,

InnoDB: which exceeds the log group capacity 9433498.

InnoDB: If you are using big BLOB or TEXT rows, you must set the

InnoDB: combined size of log files at least 10 times bigger than the

InnoDB: largest such row.

180201 11:57:04 InnoDB: ERROR: the age of the last checkpoint is 9438727,

InnoDB: which exceeds the log group capacity 9433498.

InnoDB: If you are using big BLOB or TEXT rows, you must set the

InnoDB: combined size of log files at least 10 times bigger than the

InnoDB: largest such row.

180201 11:57:20 InnoDB: ERROR: the age of the last checkpoint is 9442345,

InnoDB: which exceeds the log group capacity 9433498.

InnoDB: If you are using big BLOB or TEXT rows, you must set the

InnoDB: combined size of log files at least 10 times bigger than the

InnoDB: largest such row.

180201 11:57:37 InnoDB: ERROR: the age of the last checkpoint is 9437790,

InnoDB: which exceeds the log group capacity 9433498.



Now i question, have connection with the error?
tentacle
Znuny newbie
Posts: 20
Joined: 13 Apr 2013, 10:30
Znuny Version: 3.2.4
Real Name: Jaska

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Post by tentacle »

Same error here.

Where should I look for more information on this?

---

Databases are UTF-8

Centos 7
MariaDB 5.5.56

otrs-5.0.23-01.noarch.rpm -> otrs-6.0.6-01.noarch.rpm
tentacle
Znuny newbie
Posts: 20
Joined: 13 Apr 2013, 10:30
Znuny Version: 3.2.4
Real Name: Jaska

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Post by tentacle »

Could anyone give me a hint where to look for problems?

Ok it might be some weird letter in the database but how to find it?

DBUpdate-to-6.pl gives this error and stops:

[Wed Aug 15 14:12:53 2018] DBUpdate-to-6.pl: utf8 "\xE4" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 407, <$FH> chunk 1.

This time I tried otrs-5.0.23-01.noarch.rpm -> otrs-6.0.10-01.noarch.rpm
tentacle
Znuny newbie
Posts: 20
Joined: 13 Apr 2013, 10:30
Znuny Version: 3.2.4
Real Name: Jaska

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Post by tentacle »

Still happens on newest version 6.0.12

Any tips?

There must be some weird letters or something in the database but the question is how to find those.
thomas91
Znuny advanced
Posts: 103
Joined: 23 Dec 2010, 23:01
Znuny Version: 6.0.18
Location: Lauda-Königshofen

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Post by thomas91 »

Hey,

i still have the same Problem. How did you fix it?
MfG Thomas

Produktiv:
OTRS: 5.0.9
ITSM: 5.0.?
FAQ: 5.0.?
OS: Debian 9.8 x64
Application: Apache2/MySQL 5.5
VM auf: VMware ESXi 6.5
E-Mails: MS Exchange 2013

-- Achtung, es folgt ein Witz:

Code: Select all

    # dpkg-reconfigure brain
    Paket »brain« ist nicht installiert und es ist keine Info verfügbar.
-- weiter geht's im Thread…[/size]
tentacle
Znuny newbie
Posts: 20
Joined: 13 Apr 2013, 10:30
Znuny Version: 3.2.4
Real Name: Jaska

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Post by tentacle »

Same here.

Still can't upgrade.

Any hints?
tentacle
Znuny newbie
Posts: 20
Joined: 13 Apr 2013, 10:30
Znuny Version: 3.2.4
Real Name: Jaska

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Post by tentacle »

Hi,

Could somebody point me to right direction on how to find weird characters from the database dump?

I'm pretty sure there's some unsupported character which crashes the upgrade.

DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Post by root »

tentacle wrote: 04 May 2020, 09:25 Could somebody point me to right direction on how to find weird characters from the database dump?
Hi,

Check your current sysconfig (ZZZAuto.pm) first.
What is you current OTRS version?

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
tentacle
Znuny newbie
Posts: 20
Joined: 13 Apr 2013, 10:30
Znuny Version: 3.2.4
Real Name: Jaska

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Post by tentacle »

Hi,

In ZZZAuto.pm there indeed was few broken characters and upgrade worked perfect after that!

Thanks!

I'd offer you 48 beers right now in a bar if I could. This really helped a lot!
Post Reply