An error occurred:
MENIA <br>
http://pansophy.jlab.org/development/P2024/Components/Queries/SNQuery.cfc?method=SNRecs&_cf_ajaxproxytoken=4D569CECA087528AB6AB&returnFormat=json&argumentCollection=%7B%22Projects%22%3A%22C100R%22%2C%22IDTYPE%22%3A%22CMSN%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=B891BDD4D7B7F33CCAC27D4AFD618609&_cf_rc=8 <br>
Time: 4/16/24 7:53 AM<br>
<table class="cfdump_struct">
<tr><th class="struct" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - struct</th></tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Cause</td>
<td>
<table class="cfdump_struct">
<tr><th class="struct" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - struct</th></tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">ErrorCode</td>
<td>
932
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Message</td>
<td>
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">SQLState</td>
<td>
HY000
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">StackTrace</td>
<td>
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 cfSNQuery2ecfc1777856504$funcSNRECS.runFunction(/sgroup/asd/www/pansophy/html/development/P2024/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:588)
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:655)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
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:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Suppressed</td>
<td>
<table class="cfdump_array">
<tr><th class="array" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - array[empty]
</th></tr>
</table>
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">TagContext</td>
<td>
<table class="cfdump_array">
<tr><th class="array" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - array
</th></tr>
<tr><td class="array" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">1</td>
<td>
<table class="cfdump_struct">
<tr><th class="struct" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - struct</th></tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">COLUMN</td>
<td>
0
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">ID</td>
<td>
CFQUERY
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">LINE</td>
<td>
74
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">RAW_TRACE</td>
<td>
at cfSNQuery2ecfc1777856504$funcSNRECS.runFunction(/sgroup/asd/www/pansophy/html/development/P2024/Components/Queries/SNQuery.cfc:74)
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">TEMPLATE</td>
<td>
/sgroup/asd/www/pansophy/html/development/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">TYPE</td>
<td>
CFML
</td>
</tr>
</table>
</td></tr>
</table>
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Type</td>
<td>
java.sql.SQLException
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">DataSource</td>
<td>
TRAVELERtst
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Detail</td>
<td>
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">ErrorCode</td>
<td>
HY000
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Exceptions</td>
<td>
<table class="cfdump_array">
<tr><th class="array" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - array
</th></tr>
<tr><td class="array" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">1</td>
<td>
<table class="cfdump_struct">
<tr><th class="struct" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - struct</th></tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">class</td>
<td>
java.sql.SQLException
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">message</td>
<td>
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB
</td>
</tr>
</table>
</td></tr>
</table>
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Message</td>
<td>
Error Executing Database Query.
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">NativeErrorCode</td>
<td>
932
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">RootCause</td>
<td>
<table class="cfdump_struct">
<tr><th class="struct" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - struct</th></tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">ErrorCode</td>
<td>
932
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Message</td>
<td>
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">SQLState</td>
<td>
HY000
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">StackTrace</td>
<td>
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 cfSNQuery2ecfc1777856504$funcSNRECS.runFunction(/sgroup/asd/www/pansophy/html/development/P2024/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:588)
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:655)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
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:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Suppressed</td>
<td>
<table class="cfdump_array">
<tr><th class="array" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - array[empty]
</th></tr>
</table>
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">TagContext</td>
<td>
<table class="cfdump_array">
<tr><th class="array" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - array
</th></tr>
<tr><td class="array" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">1</td>
<td>
<table class="cfdump_struct">
<tr><th class="struct" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - struct</th></tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">COLUMN</td>
<td>
0
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">ID</td>
<td>
CFQUERY
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">LINE</td>
<td>
74
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">RAW_TRACE</td>
<td>
at cfSNQuery2ecfc1777856504$funcSNRECS.runFunction(/sgroup/asd/www/pansophy/html/development/P2024/Components/Queries/SNQuery.cfc:74)
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">TEMPLATE</td>
<td>
/sgroup/asd/www/pansophy/html/development/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">TYPE</td>
<td>
CFML
</td>
</tr>
</table>
</td></tr>
</table>
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Type</td>
<td>
java.sql.SQLException
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">SQLState</td>
<td>
HY000
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Sql</td>
<td>
SELECT distinct trgt.RFCableProblems Name
FROM adappstst.C100RCMTFCMACTS trgt,
adappstst.TRAV_HEADER th,
adappstst.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
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">StackTrace</td>
<td>
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 cfSNQuery2ecfc1777856504$funcSNRECS.runFunction(/sgroup/asd/www/pansophy/html/development/P2024/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:588)
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:655)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
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:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
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
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Suppressed</td>
<td>
<table class="cfdump_array">
<tr><th class="array" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - array[empty]
</th></tr>
</table>
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">TagContext</td>
<td>
<table class="cfdump_array">
<tr><th class="array" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - array
</th></tr>
<tr><td class="array" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">1</td>
<td>
<table class="cfdump_struct">
<tr><th class="struct" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Error - struct</th></tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">COLUMN</td>
<td>
0
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">ID</td>
<td>
CFQUERY
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">LINE</td>
<td>
74
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">RAW_TRACE</td>
<td>
at cfSNQuery2ecfc1777856504$funcSNRECS.runFunction(/sgroup/asd/www/pansophy/html/development/P2024/Components/Queries/SNQuery.cfc:74)
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">TEMPLATE</td>
<td>
/sgroup/asd/www/pansophy/html/development/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">TYPE</td>
<td>
CFML
</td>
</tr>
</table>
</td></tr>
</table>
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">Type</td>
<td>
Database
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">queryError</td>
<td>
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected - got CLOB
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">where</td>
<td>
(param 1) = [type='IN', class='java.lang.String', value='C100R-CMTF-CM-ACTS', sqltype='cf_sql_varchar'] , (param 2) = [type='IN', class='java.lang.String', value='trgt.RFCableProblems', sqltype='cf_sql_varchar']
</td>
</tr>
</table>
<table class="cfdump_struct">
<tr><th class="struct" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">Form - struct [empty]</th></tr>
</table>
<table class="cfdump_struct">
<tr><th class="struct" colspan="2" onClick="cfdump_toggleTable(this);" style="cursor:pointer;" title="click to collapse">URL - struct</th></tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">_cf_ajaxproxytoken</td>
<td>
4D569CECA087528AB6AB
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">_cf_clientid</td>
<td>
B891BDD4D7B7F33CCAC27D4AFD618609
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">_cf_nocache</td>
<td>
true
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">_cf_nodebug</td>
<td>
true
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">_cf_rc</td>
<td>
8
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">argumentCollection</td>
<td>
{"Projects":"C100R","IDTYPE":"CMSN"}
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">method</td>
<td>
SNRecs
</td>
</tr>
<tr>
<td class="struct" onClick="cfdump_toggleRow(this);" style="cursor:pointer;" title="click to collapse">returnFormat</td>
<td>
json
</td>
</tr>
</table>