<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
<div dir="ltr">
<div></div>
<div>
<div dir="ltr">Hello there Megan,</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">All I have done in Pansophy was attempt an inventory search of silicon nitride ball bearings by searching parts by name keyword. I was able to see the list, and unless I didn't log out properly or something I didn't notice an error.</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">-Daniel</div>
</div>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Megan McDonald <megan@jlab.org><br>
<b>Sent:</b> Wednesday, November 8, 2023 1:01:18 PM<br>
<b>To:</b> Daniel Galway <galway@jlab.org><br>
<b>Cc:</b> pansophy@jlab.org <pansophy@jlab.org><br>
<b>Subject:</b> FW: Error: Error Executing Database Query.</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Verdana}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:#0563C1;
text-decoration:underline}
span.x_EmailStyle19
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-family:"Calibri",sans-serif}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
-->
</style>
<div lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="x_WordSection1">
<p class="x_MsoNormal">Hi Daniel,</p>
<p class="x_MsoNormal">We see that you got an error. Do you remember what you were doing when you received the error message?</p>
<p class="x_MsoNormal">Megan</p>
<p class="x_MsoNormal">Pansophy Team</p>
<p class="x_MsoNormal"> </p>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal"><b>From:</b> adapps@jlab.org <adapps@jlab.org> <br>
<b>Sent:</b> Wednesday, November 8, 2023 12:23 PM<br>
<b>To:</b> Valerie Bookwalter <bookwalt@jlab.org>; Megan McDonald <megan@jlab.org>; Mike Dickey <mdickey@jlab.org>; Allen Samuels <samuels@jlab.org>; Matthew Menia <menia@jlab.org><br>
<b>Subject:</b> Error: Error Executing Database Query.</p>
</div>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">An error occurred: GALWAY <br>
<a href="http://pansophy.jlab.org/production/P2022/Components/Global/DrillDown2.cfc?method=DFilter1&_cf_ajaxproxytoken=4B7281D41C47DF1F&returnFormat=json&argumentCollection=%7B%22gpk%22%3A%222%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=92543039A5B97AC1B21378D5BE1D2369&_cf_rc=0">http://pansophy.jlab.org/production/P2022/Components/Global/DrillDown2.cfc?method=DFilter1&_cf_ajaxproxytoken=4B7281D41C47DF1F&returnFormat=json&argumentCollection=%7B%22gpk%22%3A%222%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=92543039A5B97AC1B21378D5BE1D2369&_cf_rc=0</a>
<br>
Time: 11/8/23 12:23 PM</p>
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - struct</span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Cause</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - struct</span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">ErrorCode</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">911
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Message</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">SQLState</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">42000
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">StackTrace</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1085)
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.go.execute(BaseStatement.java:4425)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) 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
cfDrillDown22ecfc933123546$funcDFILTER1.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/DrillDown2.cfc:24) 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)
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Suppressed</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - array[empty]
</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">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">TagContext</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - array
</span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCFFCC; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">1</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - struct</span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">COLUMN</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">0
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">ID</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">CFQUERY
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">LINE</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">24
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">RAW_TRACE</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">at cfDrillDown22ecfc933123546$funcDFILTER1.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/DrillDown2.cfc:24)
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">TEMPLATE</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/DrillDown2.cfc
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">TYPE</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">CFML
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></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">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Type</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">java.sql.SQLSyntaxErrorException
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">DataSource</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">FACILITY
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Detail</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">ErrorCode</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">42000
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Exceptions</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - array
</span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCFFCC; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">1</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - struct</span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">class</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">java.sql.SQLSyntaxErrorException
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">message</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></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">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Message</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Error Executing Database Query.
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">NativeErrorCode</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">911
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">RootCause</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - struct</span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">ErrorCode</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">911
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Message</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">SQLState</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">42000
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">StackTrace</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1085)
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.go.execute(BaseStatement.java:4425)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) 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
cfDrillDown22ecfc933123546$funcDFILTER1.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/DrillDown2.cfc:24) 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)
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Suppressed</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - array[empty]
</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">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">TagContext</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - array
</span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCFFCC; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">1</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - struct</span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">COLUMN</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">0
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">ID</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">CFQUERY
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">LINE</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">24
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">RAW_TRACE</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">at cfDrillDown22ecfc933123546$funcDFILTER1.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/DrillDown2.cfc:24)
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">TEMPLATE</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/DrillDown2.cfc
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">TYPE</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">CFML
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></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">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Type</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">java.sql.SQLSyntaxErrorException
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">SQLState</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">42000
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Sql</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">SELECT DISTINCT DRAWINGLINE1 ColData FROM #session.schema#.inv_drawings ORDER BY ColData
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">StackTrace</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">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 cfDrillDown22ecfc933123546$funcDFILTER1.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/DrillDown2.cfc:24) 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.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1085)
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.go.execute(BaseStatement.java:4425)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) 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
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Suppressed</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - array[empty]
</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">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">TagContext</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - array
</span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCFFCC; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">1</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Error - struct</span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">COLUMN</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">0
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">ID</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">CFQUERY
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">LINE</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">24
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">RAW_TRACE</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">at cfDrillDown22ecfc933123546$funcDFILTER1.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/DrillDown2.cfc:24)
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">TEMPLATE</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/DrillDown2.cfc
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">TYPE</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">CFML
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></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">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Type</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">Database
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">queryError</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">where</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">[empty string]
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal"><span style="display:none"> </span></p>
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">Form - struct [empty]</span></b></p>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal"><span style="display:none"> </span></p>
<table class="x_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="x_MsoNormal"><b><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:white">URL - struct</span></b></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">_cf_ajaxproxytoken</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">4B7281D41C47DF1F
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">_cf_clientid</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">92543039A5B97AC1B21378D5BE1D2369
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">_cf_nocache</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">true
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">_cf_nodebug</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">true
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">_cf_rc</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">0
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">argumentCollection</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">{"gpk":"2"}
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">method</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">DFilter1
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
<tr>
<td valign="top" style="background:#CCDDFF; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">returnFormat</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
<td valign="top" style="background:white; padding:2.25pt 2.25pt 2.25pt 2.25pt">
<p class="x_MsoNormal"><span style="font-size:7.5pt; font-family:"Verdana",sans-serif; color:black">json
</span><span style="font-size:7.5pt; font-family:"Verdana",sans-serif"></span></p>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal"> </p>
</div>
</div>
</body>
</html>