Oracle CLOB error

RT Users
1

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, 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.

2

I think it’s been fixed in 3.8.3On Thu, Jun 4, 2009 at 7:05 PM, Maria Quinn mail@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, 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.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.

3

Thanks, Ruslan.

I’ve checked the release notes for 3.8.3 and I’m
can’t see this fix. Can anyone confirm if it is actually in there.

Regards,

Maria

At 16:27 04/06/2009, Ruslan Zakirov wrote:

4

I just upgraded to 3.8.3 but the error is still appearing in
/var/log/messages.

I’d be grateful for any other suggestions.

Thanks