[rt-users] dumpfile-to-rt-3.0 choking on attachment

[Robert Joost]

Hello,
This is my first post so please bear with me.

Trying to upgrade from RT2 to RT3. I successfully exported RT2 using 
rt-2.0-to-dumpfile.
(Using VERSION 1.23 of rt2-to-rt3-1.23)
RT2 is running on an RH8 box with Postgres 7.2

RT2 is at 2.0.15 and RT3 is at rt-3-0-4

I built another box with FreeBSD and built RT3, scp'd the dump over to 
that box and ran
dumpfile-to-rt-3.0.

After running ./dumpfile-to-rt-3.0 /tmp/dump

Importing groups
gggggggggggggggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqImporting 
tickets...t-17
.t-18
.t-19
Couldn't create attachment
$VAR1 = {
'Subject' => '',
'ContentType' => 'application/msword',
'Filename' => 'Script for testing the functionality of RT ticket 273.doc',
'Headers' => 'Content-Type: application/msword;
name="Script for testing the functionality of RT ticket 273.doc"
Content-Disposition: inline;
filename="Script for testing the functionality of RT ticket 273.doc"
Content-Transfer-Encoding: base64
',
'Creator' => '19',
'Parent' => '1133',
'Created' => '2003-01-22 00:53:13+00',
'ContentEncoding' => 'base64',
'id' => '1135',
'TransactionId' => '2420'
};

ERROR: parser: unterminated quoted string at or near "'ÐÏࡱ?á" at 
character 682
[Fri Jun 18 00:16:02 2004] [crit]: Died at ./dumpfile-to-rt-3.0 line 719.
(/usr/local/rt3/lib/RT.pm:242)


 From the postgres log:
ERROR: parser: unterminated quoted string at or near "'ÐÏࡱ?á" at 
character 682
LOG: recycled transaction log file 0000000000000000

AFTER this error, a select on the users table in the RT3 database showed 
all the users and a few of my users were able to login. I was able to 
login as root as well. So all the user data from the user tables was 
successfully imported :-)

Upon logging in, I saw only 1 ticket (there are over 4,000).

So dumpfile-to-rt-3.0 is choking per the error above.

I'm hoping someone will help me with this.

Thanks!

-- 
Rob Joost
Unix Administrator

KnowledgeNet
14624 N. Scottsdale Road, #300
Scottsdale, AZ  85254
Phone:   (480) 315-4841
Cell:    (602) 920-6113
Email: rob.joost at knowledgenet.com
Web:   <http://www.knowledgenet.com/>

Why KnowledgeNet? Listen and learn from top customers -- Cisco, US
Postal Service, and EMC, to name a few!
<http://www.knowledgenet.com/onlineevents/>

NOTICE: This communication may contain privileged or other confidential information. If you are not the intended recipient or believe that you may have received this communication in error, please reply to the sender indicating that fact and delete the copy you received. Thank you.