Attachments Truncated When Retrieved From Oracle?

RT Users
1

I’m having a problem where attachments are truncated when retrieved from
Oracle. They get added to the database just fine both through the web
and email gateways but get truncated when I try to retrieve them through
the web interface.

Oracle is not corrupting the attachments. It seems to be RT and its
retrieval of the attachments from the database where the problem
resides. Using a text document of 128k in size we were able to extract
from the database manually the entire file, but when download through RT
only 8k is returned (exactly 8000 bytes). When Word documents or jpeg
(i.e. binary files) are sent to RT only 5922 bytes are downloaded from
RT no matter how big the original attachments were. The entire
attachment seems to be in the database.

The “$MaxAttachmentSize” is properly set to “10000000” (10MB).

Has anyone else experienced this problem?

2

Don,

We burned may hours troubleshooting that one, but managed to track it down.
See:

  http://lists.fsck.com/pipermail/rt-users/2004-March/021397.html

You could edit Handle/Oracle.pm directly, or use the fix Jesse suggested he
was going to commit, which was:

"Setting this to what RT wants in RT::Handle seems to make sense:

in RT::Handle, you’ll see:

 if ($RT::DatabaseType eq 'Oracle') {
     $ENV{'NLS_LANG'} = ".UTF8";
 }

 $self->SUPER::Connect(
          User => $RT::DatabaseUser,
          Password => $RT::DatabasePassword,
         );

Try adding:

 $self->dbh->{LongReadLen}= $RT::MaxAttachmentSize;

just after that." (end quote from Jesse)

Hope that helps!

-Darren

Darren Nickerson
Senior Sales & Support Engineer
iFAX Solutions, Inc. www.ifax.com
darren.nickerson@ifax.com
+1.215.438.4638 ext 8106 office
+1.215.243.8335 fax----- Original Message -----
From: “Don Johnson” drj826@acm.org
To: rt-users@lists.bestpractical.com
Sent: Monday, March 22, 2004 6:10 PM
Subject: [rt-users] Attachments Truncated When Retrieved From Oracle?

I’m having a problem where attachments are truncated when retrieved from
Oracle. They get added to the database just fine both through the web
and email gateways but get truncated when I try to retrieve them through
the web interface.

Oracle is not corrupting the attachments. It seems to be RT and its
retrieval of the attachments from the database where the problem
resides. Using a text document of 128k in size we were able to extract
from the database manually the entire file, but when download through RT
only 8k is returned (exactly 8000 bytes). When Word documents or jpeg
(i.e. binary files) are sent to RT only 5922 bytes are downloaded from
RT no matter how big the original attachments were. The entire
attachment seems to be in the database.

The “$MaxAttachmentSize” is properly set to “10000000” (10MB).

Has anyone else experienced this problem?

rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm