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
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
