[rt-users] Database upgrade issue from RT 3.6.3 to RT 3.8.4

[Varun]

Hello All

 

I have recently upgraded my application from RT 3.6.3 to 3.8.4. Application
has seems to be upgraded correctly but when I have upgraded database. It has
shown me that database upgrade is successful. And I have also been able to
log in system but whenever I tried to see the basics of any tickets or
custom fields of any ticket RT has gone into infinite loop of query and
seems to have been never returned from it when I checked in logs it has
shown me this error

 

 

[error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0xb8dce30)
couldn't prepare the query 'SELECT main.* FROM Attributes main  WHERE
(main.Content = '3') AND (main.Name = 'BasedOn') AND (main.ObjectType =
'RT::CustomField') 'ORA-00932: inconsistent datatypes: expected - got CLOB
(DBD ERROR: error possibly near <*> indicator at char 43 in 'SELECT main.*
FROM Attributes main  WHERE (<*>main.Content = '3') AND (main.Name =
'BasedOn') AND (main.ObjectType = 'RT::CustomField') '), referer:
http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467

 

[Tue Nov 03 16:14:02 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::Oracle::db prepare failed:
ORA-00932: inconsistent datatypes: expected - got CLOB (DBD ERROR: error
possibly near <*> indicator at char 43 in 'SELECT main.* FROM Attributes
main  WHERE (<*>main.Content = '3') AND (main.Name = 'BasedOn') AND
(main.ObjectType = 'RT::CustomField') ') [for Statement "SELECT main.* FROM
Attributes main  WHERE (main.Content = '3') AND (main.Name = 'BasedOn') AND
(main.ObjectType = 'RT::CustomField') "] at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 470,
<GEN106> line 2501., referer:
http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467

 

[Tue Nov 03 16:14:02 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0xb8dce30)
couldn't prepare the query 'SELECT main.* FROM Attributes main  WHERE
(main.Content = '3') AND (main.Name = 'BasedOn') AND (main.ObjectType =
'RT::CustomField') 'ORA-00932: inconsistent datatypes: expected - got CLOB
(DBD ERROR: error possibly near <*> indicator at char 43 in 'SELECT main.*
FROM Attributes main  WHERE (<*>main.Content = '3') AND (main.Name =
'BasedOn') AND (main.ObjectType = 'RT::CustomField') '), referer:
http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467

 

[Tue Nov 03 16:14:02 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::Oracle::db prepare failed:
ORA-00932: inconsistent datatypes: expected - got CLOB (DBD ERROR: error
possibly near <*> indicator at char 43 in 'SELECT main.* FROM Attributes
main  WHERE (<*>main.Content = '3') AND (main.Name = 'BasedOn') AND
(main.ObjectType = 'RT::CustomField') ') [for Statement "SELECT main.* FROM
Attributes main  WHERE (main.Content = '3') AND (main.Name = 'BasedOn') AND
(main.ObjectType = 'RT::CustomField') "] at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 470,
<GEN106> line 2501., referer:
http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467

 

 

I don't know what kind of error is this and also my upgrade database command
was completed successfully. Can any one suggest me what is the problem. And
how to correct and what I am missing

 

Thanks & Regards

Varun Vyas

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20091103/4b21934f/attachment.htm>