<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hello All<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[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: <a
href="http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467">http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467</a><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[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: <a
href="http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467">http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467</a><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[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: <a href="http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467">http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467</a><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[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: <a
href="http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467">http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467</a><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks & Regards<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Varun Vyas<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>