<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Varun wrote:
<blockquote cite="mid:73CFEA914BD14DAB81256110ACEF67DA@elitecore.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<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>
<div class="Section1">
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Hello All<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; 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 face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; 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
moz-do-not-send="true"
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 face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
</div>
</blockquote>
<br>
A good idea is when you get errors like these in your rt.log is to cut
and paste the sql statement into sqlplus and see if it will give you an
error message that is more clear then rt.log<br>
<br>
<br>
<font face="Courier New, Courier, monospace">SELECT main.* FROM
Attributes main WHERE (main.Content = '3') AND (main.Name = 'BasedOn')
AND (main.ObjectType = 'RT::CustomField')<br>
*<br>
ERROR at line 1:<br>
ORA-00932: inconsistent datatypes: expected - got CLOB<br>
<br>
As you, hopefully, can see, the * is under main.Content = '3' and if
you know Oracle SQL a bit then it is obvious that you can't do '=' on a
CLOB. So this qualifies as a bug.<br>
<br>
Are you sure you're on 3.8.4 because I posted to rt-devel about
something like it but that was for 3.8.6 where they overhauled
hierarchical customfields and I found that converting from old to new
resulted in something like this.<br>
<br>
Regards,<br>
<br>
Joop<br>
<br>
<br>
<br>
<br>
<br>
</font>
</body>
</html>