[rt-users] Attachments Truncated When Retrieved From Oracle?

[Darren Nickerson]

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 at ifax.com
+1.215.438.4638 ext 8106 office
+1.215.243.8335 fax


----- Original Message ----- 
From: "Don Johnson" <drj826 at acm.org>
To: <rt-users at 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 at lists.bestpractical.com
> http://lists.bestpractical.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>