[rt-users] Oracle CLOB error

[Ruslan Zakirov]

I think it's been fixed in 3.8.3

On Thu, Jun 4, 2009 at 7:05 PM, Maria Quinn <mail at mariaquinn.com> wrote:
> I've installed RT 3.8.2 on Redhat 4.1.2 with Oracle and DBD::Oracle 1.2.2.
>
> I'm getting the following errors in /var/log/messages as a result of
> forwarding a ticket:
>
> Jun  4 12:48:35 vbchwebt RT: DBD::Oracle::db prepare failed:
> ORA-00932: inconsistent datatypes: expected - got CLOB (DBD ERROR:
> error possibly near <*          > indicator at char 44 in 'SELECT
> main.* FROM Attachments main  WHERE (<*>main.Content != '') AND
> (main.TransactionId = '26') AND (main.id != '1')
> AND           (main.ContentType NOT LIKE 'multipart/%')  ORDER BY
> main.id ASC ') [for Statement "SELECT main.* FROM Attachments
> main  WHERE (main.Content != '') AN          D (main.TransactionId =
> '26') AND (main.id != '1') AND (main.ContentType NOT LIKE
> 'multipart/%')  ORDER BY main.id ASC "] at
> /usr/lib/perl5/site_perl/          5.8.8/DBIx/SearchBuilder/Handle.pm
> line 469, <GEN33> line 42.
> (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:469)
> Jun  4 12:48:35 vbchwebt RT: RT::Handle=HASH(0x83c95f0) couldn't
> prepare the query 'SELECT main.* FROM Attachments main  WHERE
> (main.Content != '') AN          D (main.TransactionId = '26') AND
> (main.id != '1') AND (main.ContentType NOT LIKE 'multipart/%')  ORDER
> BY main.id ASC 'ORA-00932: inconsistent dataty          pes: expected
> - got CLOB (DBD ERROR: error possibly near <*> indicator at char 44
> in 'SELECT main.* FROM Attachments main  WHERE (<*>main.Content !=
> '          ') AND (main.TransactionId = '26') AND (main.id != '1')
> AND (main.ContentType NOT LIKE 'multipart/%')  ORDER BY main.id ASC
> ') (/usr/lib/perl5/site_pe          rl/5.8.8/DBIx/SearchBuilder/Handle.pm:476)
>
> As far as I understand, it's not possible to select from a CLOB
> column in Oracle, so I'm wondering if I've got a misconfiguration somewhere.
>
> I haven't seen any errors in the front end relating to this, but I
> still have some unresolved issues configuring mail, which I'm also
> working on, so I'm still not clear what the extent of this problem is.
>
> Thanks in advance for any advice.
>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
Best regards, Ruslan.