While importing data I ran into some problems. From the import logs
User errors:
Jun 30 08:45:27 dhcp7 RT: Creating user 0114527926@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@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@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@internext-sa.com”: can’t parse “yvette@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@host3) Message-Id:
001901c1f290$e13a6ec0$9148a8c0@host4 From: “Dave Johnstone”
dave@host To: “ZIKI BOTES” name2@host5, “Name 3” zaid@host2,
“Host2” zaid@host6, “Name4” Name4@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