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

mixo mixo at beth.uniforum.org.za
Fri Jul 4 08:00:17 EDT 2003


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

User errors:
+++++++++++++++++++++++++++++++++++++++++++++=
Jun 30 08:45:27 localhost 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 localhost 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 localhost 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 localhost 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 localhost 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 localhost 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 localhost 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 localhost 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 localhost 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 localhost 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 localhost 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 localhost 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





More information about the rt-users mailing list