<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
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:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></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 lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D">Justin,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D">We saw you were having a problem with a query. There was an incorrectly defined variable type in the database.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D">Please try again. Sorry for the inconvenience.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D">Valerie Bookwalter<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D">Jefferson Lab, SRF Department<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D">Pansophy Team<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D">1-757-813-6716 (CELL)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D">1-767-269-5802 (OFFICE – currently working offsite)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b>From:</b> adapps@jlab.org <adapps@jlab.org> <br>
<b>Sent:</b> Thursday, August 26, 2021 10:19 AM<br>
<b>To:</b> Valerie Bookwalter <bookwalt@jlab.org>; Megan McDonald <megan@jlab.org>; Mike Dickey <mdickey@jlab.org><br>
<b>Subject:</b> Error: Error Executing Database Query.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">An error occurred: JTKENT <br>
<a href="http://pansophy.jlab.org/production/P2020/Components/Queries/SNQuery.cfc?method=SNRecs&_cf_ajaxproxytoken=678DB0EDB6BD9D40&returnFormat=json&argumentCollection=%7B%22Projects%22%3A%22C50R%22%2C%22IDTYPE%22%3A%22DGLGSN%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=73C2F57EB9B513B05EAA6A001DE63BDA&_cf_rc=38">http://pansophy.jlab.org/production/P2020/Components/Queries/SNQuery.cfc?method=SNRecs&_cf_ajaxproxytoken=678DB0EDB6BD9D40&returnFormat=json&argumentCollection=%7B%22Projects%22%3A%22C50R%22%2C%22IDTYPE%22%3A%22DGLGSN%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=73C2F57EB9B513B05EAA6A001DE63BDA&_cf_rc=38</a>
<br>
Time: 8/26/21 10:18 AM<o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#0000CC">
<tbody>
<tr>
<td colspan="2" style="background:#4444CC;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - struct<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Cause<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#0000CC">
<tbody>
<tr>
<td colspan="2" style="background:#4444CC;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - struct<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">ErrorCode<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">932
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Message<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">[Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">SQLState<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">HY000
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">StackTrace<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103)
at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456) at macromedia.jdbc.oracle.am.a(OracleImplResultset.java:935)
at macromedia.jdbc.oracle.am.a(OracleImplResultset.java:484) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3327) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.oraclebase.fe.execute(BasePreparedStatement.java:2656)
at macromedia.jdbc.oraclebase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1583) at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at
coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfSNQuery2ecfc429222337$funcSNRECS.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Components/Queries/SNQuery.cfc:74) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:251)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:587) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:156)
at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:298) at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844)
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Suppressed<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#006600">
<tbody>
<tr>
<td style="background:#009900;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - array[empty]
<o:p></o:p></span></b></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">TagContext<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#006600">
<tbody>
<tr>
<td colspan="2" style="background:#009900;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - array
<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCFFCC;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">1<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#0000CC">
<tbody>
<tr>
<td colspan="2" style="background:#4444CC;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - struct<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">COLUMN<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">0
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">ID<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">CFQUERY
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">LINE<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">74
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">RAW_TRACE<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">at cfSNQuery2ecfc429222337$funcSNRECS.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Components/Queries/SNQuery.cfc:74)
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">TEMPLATE<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">/sgroup/asd/www/pansophy/html/production/P2020/Components/Queries/SNQuery.cfc
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">TYPE<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">CFML
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Type<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">java.sql.SQLException
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">DataSource<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">TRAVELER
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Detail<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">[Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">ErrorCode<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">HY000
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Exceptions<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#006600">
<tbody>
<tr>
<td colspan="2" style="background:#009900;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - array
<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCFFCC;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">1<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#0000CC">
<tbody>
<tr>
<td colspan="2" style="background:#4444CC;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - struct<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">class<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">java.sql.SQLException
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">message<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">[Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Message<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Error Executing Database Query.
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">NativeErrorCode<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">932
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">RootCause<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#0000CC">
<tbody>
<tr>
<td colspan="2" style="background:#4444CC;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - struct<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">ErrorCode<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">932
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Message<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">[Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">SQLState<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">HY000
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">StackTrace<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103)
at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456) at macromedia.jdbc.oracle.am.a(OracleImplResultset.java:935)
at macromedia.jdbc.oracle.am.a(OracleImplResultset.java:484) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3327) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.oraclebase.fe.execute(BasePreparedStatement.java:2656)
at macromedia.jdbc.oraclebase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1583) at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at
coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfSNQuery2ecfc429222337$funcSNRECS.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Components/Queries/SNQuery.cfc:74) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:251)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:587) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:156)
at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:298) at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844)
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Suppressed<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#006600">
<tbody>
<tr>
<td style="background:#009900;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - array[empty]
<o:p></o:p></span></b></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">TagContext<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#006600">
<tbody>
<tr>
<td colspan="2" style="background:#009900;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - array
<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCFFCC;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">1<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#0000CC">
<tbody>
<tr>
<td colspan="2" style="background:#4444CC;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - struct<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">COLUMN<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">0
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">ID<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">CFQUERY
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">LINE<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">74
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">RAW_TRACE<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">at cfSNQuery2ecfc429222337$funcSNRECS.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Components/Queries/SNQuery.cfc:74)
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">TEMPLATE<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">/sgroup/asd/www/pansophy/html/production/P2020/Components/Queries/SNQuery.cfc
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">TYPE<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">CFML
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Type<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">java.sql.SQLException
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">SQLState<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">HY000
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Sql<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">SELECT distinct trgt.Comment21 Name FROM adapps.C50RCPRASSYCMPL trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos WHERE tos.trav_id = (param 1) AND tos.trav_id = th.trav_id
AND tos.trav_revision = th.trav_revision AND tos.trav_seq_num = trgt.trav_seq_num AND tos.obs is null AND trgt.obs is null AND (param 2) is not null ORDER BY Name
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">StackTrace<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
at cfSNQuery2ecfc429222337$funcSNRECS.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Components/Queries/SNQuery.cfc:74) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:251)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:587) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:156)
at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:298) at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844) Caused by: java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected -
got CLOB at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456)
at macromedia.jdbc.oracle.am.a(OracleImplResultset.java:935) at macromedia.jdbc.oracle.am.a(OracleImplResultset.java:484) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3327) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322)
at macromedia.jdbc.oraclebase.fe.execute(BasePreparedStatement.java:2656) at macromedia.jdbc.oraclebase.fg.execute(BasePreparedStatementPoolable.java:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1583)
at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
... 53 more <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Suppressed<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#006600">
<tbody>
<tr>
<td style="background:#009900;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - array[empty]
<o:p></o:p></span></b></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">TagContext<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#006600">
<tbody>
<tr>
<td colspan="2" style="background:#009900;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - array
<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCFFCC;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">1<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#0000CC">
<tbody>
<tr>
<td colspan="2" style="background:#4444CC;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Error - struct<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">COLUMN<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">0
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">ID<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">CFQUERY
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">LINE<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">74
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">RAW_TRACE<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">at cfSNQuery2ecfc429222337$funcSNRECS.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Components/Queries/SNQuery.cfc:74)
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">TEMPLATE<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">/sgroup/asd/www/pansophy/html/production/P2020/Components/Queries/SNQuery.cfc
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">TYPE<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">CFML
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Type<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">Database
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">queryError<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">[Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">where<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">(param 1) = [type='IN', class='java.lang.String', value='C50R-CPR-ASSY-CMPL', sqltype='cf_sql_varchar'] , (param 2) = [type='IN', class='java.lang.String', value='trgt.Comment21',
sqltype='cf_sql_varchar'] <o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#0000CC">
<tbody>
<tr>
<td style="background:#4444CC;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">Form - struct [empty]<o:p></o:p></span></b></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#0000CC">
<tbody>
<tr>
<td colspan="2" style="background:#4444CC;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:white">URL - struct<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">_cf_ajaxproxytoken<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">678DB0EDB6BD9D40
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">_cf_clientid<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">73C2F57EB9B513B05EAA6A001DE63BDA
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">_cf_nocache<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">true
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">_cf_nodebug<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">true
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">_cf_rc<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">38
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">argumentCollection<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">{"Projects":"C50R","IDTYPE":"DGLGSN"}
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">method<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">SNRecs
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt;cursor:pointer">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">returnFormat<o:p></o:p></span></p>
</td>
<td valign="top" style="background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif">json
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>