[rt-devel] Data import errors : attachments and users

[mixo]

While importing data I ran into some problems. From the import logs

User errors:
+++++++++++++++++++++++++++++++++++++++++++++=
Jun 30 08:45:27 dhcp7 RT: Creating user 0114527926 at host.name at 
/root/dumpfile-to-rt-3.0 line 617.  (/opt/rt3/lib/RT.pm:235)
Jun 30 08:45:27 dhcp7 RT: DBD::Pg::st execute failed: ERROR:  pg_atoi: 
error in "0114527926 at host.name": can't parse "@host.name" at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.  
(/opt/rt3/lib/RT.pm:235)
+++++++++++++++++++++++++++++++++++++++++++++=

+++++++++++++++++++++++++++++++++++++++++++++=
Jul  1 00:00:03 dhcp7 RT: Creating user yvette at ho-st.name at 
/root/dumpfile-to-rt-3.0 line 617.  (/opt/rt3/lib/RT.pm:235) 
Jul  1 00:00:03 dhcp7 RT: DBD::Pg::st execute failed: ERROR:  pg_atoi: 
error in "yvette at internext-sa.com": can't parse "yvette at ho-st.name" at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.  
(/opt/rt3/lib/RT.pm:235) 
Jul  1 00:00:03 dhcp7 RT: RT::Handle=HASH(0x8d90ed0) couldn't execute 
the query 'SELECT  * FROM Users WHERE id = ?' at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.  
(/opt/rt3/lib/RT.pm:235) 
+++++++++++++++++++++++++++++++++++++++++++++=

Attachment errors:

++++++++not supported+++++++++++++++++++++++++++++++++++++=
Jul  1 06:02:44 dhcp7 RT: DBD::Pg::st execute failed: ERROR:  Unicode >= 
0x10000 is not supported at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.  
(/opt/rt3/lib/RT.pm:235)
Jul  1 06:02:44 dhcp7 RT: RT::Handle=HASH(0x8d90ed0) couldn't execute 
the query 'INSERT INTO Attachments (ContentType, Parent, Filename, 
Headers, Creator, Created, Content, ContentEncoding, TransactionId) 
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)' at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.  
(/opt/rt3/lib/RT.pm:235)
Jul  1 06:02:44 dhcp7 RT: Couldn't create attachment HASH(0x8e5f980) 
$VAR1 = {           'ContentType' => 
'application/octet-stream',           'Filename' => 
'error.txt',           'Created' => '2001-10-27 09:37:05+00',           
'Headers' => 'Content-Type: application/octet-stream; name="error.txt" 
Content-Transfer-Encoding: quoted-printable Content-Description: 
error.txt Content-Disposition: inline; filename="error.txt" ',           
'Content' => 'Sorry, but we couldn\'t open the attach file when sending 
this message original file: 
f:\\×ÊÁÏ\\¸öÈËͼƬ\\ͼƬ\\ve\'head&rotor\'(1468336423).jpg ',           
'ContentEncoding' => 'none',           'Creator' => '1260',           
'Parent' => '11893',           'TransactionId' => '16584'         };  
(/opt/rt3/lib/RT.pm:235)
+++++++++++++++++++++++++++++++++++++++++++++=

+++++++++invalid++++++++++++++++++++++++++++++++++++=
Jul  3 22:37:40 dhcp7 RT: DBD::Pg::st execute failed: ERROR:  Invalid 
UNICODE character sequence found (0xe9203c) at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.  
(/opt/rt3/lib/RT.pm:235)
Jul  3 22:37:40 dhcp7 RT: RT::Handle=HASH(0x8d90ed0) couldn't execute 
the query 'INSERT INTO Attachments (ContentType, Subject, Headers, 
Creator, Created, TransactionId) VALUES (?, ?, ?, ?, ?, ?)' at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.  
(/opt/rt3/lib/RT.pm:235)
Jul  3 22:37:40 dhcp7 RT: Couldn't create attachment HASH(0x8fd9130) 
$VAR1 = {           'Subject' => 'Fw: virus HOAX warning - please 
check',           'ContentType' => 'multipart/alternative',           
'Headers' => 'Received: from host (host [it]) by rt-host (8.11.6/8.11.6) 
with ESMTP id g439Js711895; Fri, 3 May 2002 11:19:54 +0200 Received: 
from host2 (host2 [IP2]) by host (8.11.6/8.11.0) with ESMTP id 
g439a8a12957; Fri, 3 May 2002 11:36:15 +0200 Received: from dave (host3 
[IP3]) by host2 (8.9.3/8.9.3) with SMTP id LAA10884; Fri, 3 May 2002 
11:25:30 +0200 (SAST) (envelope-from dave at host3) Message-Id: 
<001901c1f290$e13a6ec0$9148a8c0 at host4> From: "Dave Johnstone" 
<dave at host> To: "ZIKI BOTES" <name2 at host5>, "Name 3" <zaid at host2>, 
"Host2" <zaid at host6>, "Name4" <Name4 at host7>, "Yon R
Jul  4 00:44:59 dhcp7 RT: DBD::Pg::st execute failed: ERROR:  Invalid 
UNICODE character sequence found (0xe46720) at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.  
(/opt/rt3/lib/RT.pm:235)
+++++++++++++++++++++++++++++++++++++++++++++=
(Changed names and email addresses)

And, the following message appeared twice before the import was interupted:
+++++++++++++++++++++++++++++++++++++++++++++=
 [crit]: Failed to create user : Must specify 'Name' attribute 
(/opt/rt3/lib/RT/User_Overlay.pm:595)
 [error]: Could not load create a user with the email address '' to add 
as a watcher for ticket 7064 (/opt/rt3/lib/RT/Ticket_Overlay.pm:1420)
+++++++++++++++++++++++++++++++++++++++++++++=

What could be the cause of the problem(s), and how can it (they) be solved?

System:
 perl-5.8.0-88  (perl-DBI-1.32-5 , perl-DBD-Pg-1.21-2 )
 postgresql-7.3.2-3
 Redhat 9 (2.4.20-8smp)
 RT 3.0.3