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
OTRS newbie
Posts: 3
Joined: 02 Feb 2018, 14:19
OTRS 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 » 02 Feb 2018, 15:31

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
OTRS guru
Posts: 4669
Joined: 13 Mar 2011, 09:54
OTRS Version?: 3.3.x
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 » 02 Feb 2018, 15:59

Did you check that all tables are utf8?
Perl / OTRS development: http://perl-services.de
Free OTRS add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de

brunocampos87
OTRS newbie
Posts: 3
Joined: 02 Feb 2018, 14:19
OTRS 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 » 02 Feb 2018, 16:23

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
OTRS newbie
Posts: 16
Joined: 13 Apr 2013, 10:30
OTRS 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 » 22 Mar 2018, 14:36

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
OTRS newbie
Posts: 16
Joined: 13 Apr 2013, 10:30
OTRS 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 » 15 Aug 2018, 13:22

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

Post Reply