<html xmlns:v="urn:schemas-microsoft-com:vml" 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)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hello Joop<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>As per your guessing you are right I am
facing problem of corruption in sql query when I upgraded from 3.6.3 to 3.8.6
application is working fine but when I want to look at page where custom fields
are or want to see the page where tickets basics are there. I am not able to go
that page and RT doesn’t seem too returned with that page and goes in
unending loop of query firing and also I get the query which I posted to you
which is not firing as per your suggestion. So can you can help me in how to
fix this problem I am not been able to find any solution for it.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Any help is highly appreciated.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks & Regards<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Varun Vyas<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
color=black face="Times New Roman"><span style='font-size:12.0pt;color:windowtext'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 color=black face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight:bold'>From:</span></font></b><font
size=2 color=black face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;
color:windowtext'> Joop [mailto:JoopvandeWege@mococo.nl] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, November 03, 2009
1:23 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Varun<br>
<b><span style='font-weight:bold'>Cc:</span></b>
rt-users@lists.bestpractical.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [rt-users] Database
upgrade issue from RT 3.6.3 to RT 3.8.4</span></font><font color=black><span
style='color:windowtext'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'>Varun wrote: <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Hello All<u1:p></u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black 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<u1:p></u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black 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"
moz-do-not-send=true>http://rtbeta.elitecore.co.in/Ticket/Display.html?id=132467</a><u1:p></u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt'><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>
</span></font><font face="Courier New"><span style='font-family:"Courier New"'>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>
</span></font><o:p></o:p></p>
</div>
</body>
</html>