<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I tried to sort the NCR list but hit the wrong column. I accidentally hit verifydate1 and it tried to sort by it. It hung, but i didn't realize it created an error message; refreshing the screen fixed it. Is this what you're referring to? I also closed that
D3.<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<img style="max-width:100%" size="49924" contenttype="image/png" data-outlook-trace="F:1|T:1" src="cid:d39eac7d-2366-4f5d-923a-a0346ce19288"><br>
</div>
<div id="appendonsend"></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> Valerie Bookwalter <bookwalt@jlab.org><br>
<b>Sent:</b> Tuesday, August 17, 2021 1:30 PM<br>
<b>To:</b> Naeem Huque <huque@jlab.org><br>
<b>Cc:</b> pansophy <pansophy@jlab.org><br>
<b>Subject:</b> RE: 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;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:#0563C1;
text-decoration:underline}
a:visited, span.x_MsoHyperlinkFollowed
{color:#954F72;
text-decoration:underline}
p.x_msonormal0, li.x_msonormal0, div.x_msonormal0
{margin-right:0in;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
span.x_EmailStyle19
{font-family:"Calibri",sans-serif;
color:#1F497D}
.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">
<div class="x_WordSection1">
<p class="x_MsoNormal"><span style="font-size:14.0pt; color:#1F497D">Naeem,</span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; color:#1F497D"> </span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; color:#1F497D">What are you trying to do that you get an error?</span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; color:#1F497D"> </span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; color:#1F497D">Valerie</span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; color:#1F497D"> </span></p>
<p class="x_MsoNormal"><b>From:</b> adapps@jlab.org <adapps@jlab.org> <br>
<b>Sent:</b> Tuesday, August 17, 2021 12:57 PM<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.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">An error occurred: HUQUE <br>
<a>http://pansophy.jlab.org/production/P2020/Components/Global/TDNFilter2.cfc?method=SearchGrid&&&&gpk=3&&&&TId=SNSPPU-NCR,SNSPPU-NCR&&&&SerialName=SN&&&&BooleanSelect=n&&&&iFilter1=Select%20All&&&&iFilter2=Select%20All&&&&DateOption=all&&&&AfterDate=&&&&BeforeDate=&&&&pSize=2500&pageSize=2500&_cf_ajaxproxytoken=76E18885940FB7A4&_cf_clientid=5004DF95633481CD95D9BAEF3B87E3DF&_cf_rc=4&_cf_nodebug=true&_cf_nocache=true&returnFormat=json&_dc=1629219441559&page=1&start=0&limit=2500&sortcolumn=VERIFYDATE1&sortdirection=DESC</a>
<br>
Time: 8/17/21 12:57 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">Cause</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">ErrorCode</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">1791
</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">Message</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">[Macromedia][Oracle JDBC Driver][Oracle]ORA-01791: not a SELECTed expression
</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">SQLState</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">HY000
</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">StackTrace</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">java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01791: not a SELECTed expression 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.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
cfTDNFilter22ecfc1176543322$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/TDNFilter2.cfc:340) 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)
</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">Suppressed</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">TagContext</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">1</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">COLUMN</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">0
</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">ID</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">CFQUERY
</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">LINE</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">340
</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">RAW_TRACE</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">at cfTDNFilter22ecfc1176543322$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/TDNFilter2.cfc:340)
</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">TEMPLATE</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">/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/TDNFilter2.cfc
</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">TYPE</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">CFML
</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">Type</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">java.sql.SQLException
</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">DataSource</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">TRAVELER
</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">Detail</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">[Macromedia][Oracle JDBC Driver][Oracle]ORA-01791: not a SELECTed expression
</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">ErrorCode</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">HY000
</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">Exceptions</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">1</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">class</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">java.sql.SQLException
</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">message</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">[Macromedia][Oracle JDBC Driver][Oracle]ORA-01791: not a SELECTed expression
</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">Message</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">Error Executing Database Query.
</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">NativeErrorCode</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">1791
</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">RootCause</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">ErrorCode</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">1791
</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">Message</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">[Macromedia][Oracle JDBC Driver][Oracle]ORA-01791: not a SELECTed expression
</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">SQLState</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">HY000
</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">StackTrace</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">java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01791: not a SELECTed expression 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.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
cfTDNFilter22ecfc1176543322$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/TDNFilter2.cfc:340) 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)
</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">Suppressed</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">TagContext</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">1</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">COLUMN</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">0
</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">ID</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">CFQUERY
</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">LINE</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">340
</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">RAW_TRACE</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">at cfTDNFilter22ecfc1176543322$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/TDNFilter2.cfc:340)
</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">TEMPLATE</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">/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/TDNFilter2.cfc
</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">TYPE</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">CFML
</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">Type</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">java.sql.SQLException
</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">SQLState</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">HY000
</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">Sql</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">SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,disposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn
ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink
FROM adapps.SNSPPUNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.SNSPPUNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS
tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is
null) attachTravs WHERE tos.trav_id = 'SNSPPU-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num
and tos.obs is null and trgt.obs is null and th.obs is null AND trav_complete = 'n' ORDER BY VERIFYDATE1 DESC
</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">StackTrace</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">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 cfTDNFilter22ecfc1176543322$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/TDNFilter2.cfc:340) 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-01791: not a SELECTed expression 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.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></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">Suppressed</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">TagContext</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">1</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">COLUMN</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">0
</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">ID</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">CFQUERY
</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">LINE</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">340
</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">RAW_TRACE</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">at cfTDNFilter22ecfc1176543322$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/TDNFilter2.cfc:340)
</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">TEMPLATE</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">/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/TDNFilter2.cfc
</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">TYPE</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">CFML
</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">Type</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">Database
</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">queryError</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">[Macromedia][Oracle JDBC Driver][Oracle]ORA-01791: not a SELECTed expression
</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">where</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">[empty string]
</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">AfterDate</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">[empty string]
</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">BeforeDate</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">[empty string]
</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">BooleanSelect</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">n
</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">DateOption</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">all
</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">SerialName</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">SN
</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">TId</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">SNSPPU-NCR,SNSPPU-NCR
</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">_cf_ajaxproxytoken</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">76E18885940FB7A4
</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">_cf_clientid</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">5004DF95633481CD95D9BAEF3B87E3DF
</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">_cf_nocache</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">true
</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">_cf_nodebug</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">true
</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">_cf_rc</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">4
</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">_dc</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">1629219441559
</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">gpk</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">3
</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">iFilter1</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">Select All
</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">iFilter2</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">Select All
</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">limit</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">2500
</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">method</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">SearchGrid
</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">pSize</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">2500
</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">page</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">1
</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">pageSize</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">2500
</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">returnFormat</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">json
</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">sortcolumn</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">VERIFYDATE1
</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">sortdirection</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">DESC
</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">start</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">0
</span></p>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal"> </p>
</div>
</div>
</body>
</html>