<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr" style="zoom: 0%;">
<div dir="auto">Hi Valerie,<br>
<br>
</div>
<div dir="auto">Thank you very much for checking. I was just trying to look at the status of the documents. I didn''t realize that on 2 of them I am not on the list of approvers, so I can't see the list. That was the error I got, which I think is correct.<br>
<br>
</div>
<div dir="auto">Kindly,<br>
</div>
<div dir="auto">a.<br>
<br>
</div>
<div dir="auto"><!-- tmjah_g_1299s -->Get<!-- tmjah_g_1299e --> <a href="https://bluemail.me">
<!-- tmjah_g_1299s -->BlueMail for Android<!-- tmjah_g_1299e --></a><!-- tmjah_g_1299s --><!-- tmjah_g_1299e -->
</div>
<div class="gmail_quote">On Aug 25, 2025, at 4:44 PM, Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org" target="_blank">bookwalt@jlab.org</a>> wrote:
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);" class="elementToProof">
Alex,</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);" class="elementToProof">
I see you are getting an error.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);" class="elementToProof">
Please let me know what you are trying to do and we will try to help resolve.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);" class="elementToProof">
Thank you.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div id="Signature">
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<br>
</div>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="font-size: 12pt;">Valerie Bookwalter</span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;">Jefferson Lab, Accelerator Dept. </p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;">SRFOPS Software Systems Group</p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"><span style="color: rgb(5, 99, 193);"><u><a style="color: rgb(5, 99, 193); margin-top: 0px; margin-bottom: 0px;" href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a></u></span></p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;">757-269-5802</p>
<p style="margin: 0in; font-family: Calibri, sans-serif; font-size: 11pt;"> </p>
</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> adapps@jlab.org <adapps@jlab.org><br>
<b>Sent:</b> Monday, August 25, 2025 4:19 PM<br>
<b>To:</b> Valerie Bookwalter <bookwalt@jlab.org>; Megan McDonald <megan@jlab.org>; Matthew Menia <menia@jlab.org>; Mike Dickey <mdickey@jlab.org><br>
<b>Subject:</b> Error: Error Executing Database Query.</font>
<div> </div>
</div>
<div>An error occurred: ACASTILL <br>
http://pansophy.jlab.org/production/P2024/Components/Global/TDNFilter.cfc?method=SearchGrid&dSource=TRAVELER&Fields=,%20,%20&Tables=adapps.%20trgt,%20%20adapps.TRAV_OWNERS%20tos,%20%20adapps.TRAV_HEADER%20th&Conditions=trgt.trav_seq_num%20=%20tos.trav_seq_num%20AND%20tos.trav_id%20=%20%27C100R-CMA-HELV-ASSY%27%20AND%20tos.trav_id%20=%20th.trav_id%20AND%20tos.trav_revision%20=%20th.trav_revision%20AND%20trgt.obs%20is%20NULL%20AND%20tos.obs%20is%20NULL&BooleanSelect=-1&BoolField=trav_complete&iFilters=&iFilter1=&iFilter2=&KeyDates=&DateOption=all&AfterDate=&BeforeDate=&OrderBy=&pSize=500&pageSize=500&_cf_ajaxproxytoken=&_cf_clientid=DF8073CE121A051490D391FB4710E7E5&_cf_rc=1&_cf_nodebug=true&_cf_nocache=true&returnFormat=json&_dc=1756153155667&start=0&limit=500&page=1&sortcolumn=&sortdirection=ASC
<br>
Time: 8/25/25 4:19 PM<br>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Cause</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Cause</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ErrorPosition</td>
<td>16 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Message</td>
<td>ORA-00936: missing expression </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OracleErrorNumber</td>
<td>936 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OriginalSql</td>
<td>SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is
NULL AND tos.obs is NULL </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Sql</td>
<td>SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is
NULL AND tos.obs is NULL </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">StackTrace</td>
<td>Error : 936, Position : 16, Sql = SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision
= th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL, OriginalSql = SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id
= th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL, Error Msg = ORA-00936: missing expression at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265)
at coldfusion.sql.Executive.executeQuery(Executive.java:1649) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:262) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:606) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
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:167) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:324) at javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
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:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Suppressed</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array[empty]
</th>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TagContext</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>157 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Type</td>
<td>oracle.jdbc.OracleDatabaseException </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ErrorCode</td>
<td>936 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Message</td>
<td>ORA-00936: missing expression </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">SQLState</td>
<td>42000 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">StackTrace</td>
<td>java.sql.SQLSyntaxErrorException: ORA-00936: missing expression at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649)
at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762)
at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:262) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:606) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) 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:167) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:324) at javax.servlet.http.HttpServlet.service(HttpServlet.java:529) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: Error : 936, Position : 16, Sql = SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER
th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL, OriginalSql = SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS
tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL, Error Msg = ORA-00936: missing expression
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 70 more
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Suppressed</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array[empty]
</th>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TagContext</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>157 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Type</td>
<td>java.sql.SQLSyntaxErrorException </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">DataSource</td>
<td>TRAVELER </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Detail</td>
<td>ORA-00936: missing expression </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ErrorCode</td>
<td>42000 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Exceptions</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">causes</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ErrorPosition</td>
<td>16 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Message</td>
<td>ORA-00936: missing expression </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OracleErrorNumber</td>
<td>936 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OriginalSql</td>
<td>SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is
NULL AND tos.obs is NULL </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Sql</td>
<td>SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is
NULL AND tos.obs is NULL </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">StackTrace</td>
<td>Error : 936, Position : 16, Sql = SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision
= th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL, OriginalSql = SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id
= th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL, Error Msg = ORA-00936: missing expression at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265)
at coldfusion.sql.Executive.executeQuery(Executive.java:1649) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:262) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:606) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
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:167) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:324) at javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
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:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Suppressed</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array[empty]
</th>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TagContext</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>157 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Type</td>
<td>oracle.jdbc.OracleDatabaseException </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">class</td>
<td>java.sql.SQLSyntaxErrorException </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">message</td>
<td>ORA-00936: missing expression </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Message</td>
<td>Error Executing Database Query. </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">NativeErrorCode</td>
<td>936 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RootCause</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Cause</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ErrorPosition</td>
<td>16 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Message</td>
<td>ORA-00936: missing expression </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OracleErrorNumber</td>
<td>936 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OriginalSql</td>
<td>SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is
NULL AND tos.obs is NULL </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Sql</td>
<td>SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is
NULL AND tos.obs is NULL </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">StackTrace</td>
<td>Error : 936, Position : 16, Sql = SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision
= th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL, OriginalSql = SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id
= th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL, Error Msg = ORA-00936: missing expression at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265)
at coldfusion.sql.Executive.executeQuery(Executive.java:1649) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:262) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:606) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
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:167) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:324) at javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
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:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Suppressed</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array[empty]
</th>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TagContext</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>157 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Type</td>
<td>oracle.jdbc.OracleDatabaseException </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ErrorCode</td>
<td>936 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Message</td>
<td>ORA-00936: missing expression </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">SQLState</td>
<td>42000 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">StackTrace</td>
<td>java.sql.SQLSyntaxErrorException: ORA-00936: missing expression at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649)
at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762)
at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:262) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:606) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) 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:167) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:324) at javax.servlet.http.HttpServlet.service(HttpServlet.java:529) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: Error : 936, Position : 16, Sql = SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER
th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL, OriginalSql = SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS
tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL, Error Msg = ORA-00936: missing expression
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 70 more
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Suppressed</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array[empty]
</th>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TagContext</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>157 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Type</td>
<td>java.sql.SQLSyntaxErrorException </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">SQLState</td>
<td>42000 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Sql</td>
<td>SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is
NULL AND tos.obs is NULL </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">StackTrace</td>
<td>coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:262) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:606) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
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:167) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:324) at javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
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:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: java.sql.SQLSyntaxErrorException:
ORA-00936: missing expression at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) at coldfusion.sql.Executive.executeQuery(Executive.java:1391)
at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) ...
50 more Caused by: Error : 936, Position : 16, Sql = SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision
= th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL, OriginalSql = SELECT DISTINCT , , FROM adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th WHERE trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id
= th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL, Error Msg = ORA-00936: missing expression at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 70 more
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Suppressed</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array[empty]
</th>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TagContext</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>157 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Type</td>
<td>Database </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">queryError</td>
<td>ORA-00936: missing expression </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">where</td>
<td>[empty string] </td>
</tr>
</tbody>
</table>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Form - struct [empty]</th>
</tr>
</tbody>
</table>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">URL - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">AfterDate</td>
<td>[empty string] </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">BeforeDate</td>
<td>[empty string] </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">BoolField</td>
<td>trav_complete </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">BooleanSelect</td>
<td>-1 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Conditions</td>
<td>trgt.trav_seq_num = tos.trav_seq_num AND tos.trav_id = 'C100R-CMA-HELV-ASSY' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision AND trgt.obs is NULL AND tos.obs is NULL
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">DateOption</td>
<td>all </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Fields</td>
<td>, , </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">KeyDates</td>
<td>[empty string] </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OrderBy</td>
<td>[empty string] </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Tables</td>
<td>adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">_cf_ajaxproxytoken</td>
<td>[empty string] </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">_cf_clientid</td>
<td>DF8073CE121A051490D391FB4710E7E5 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">_cf_nocache</td>
<td>true </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">_cf_nodebug</td>
<td>true </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">_cf_rc</td>
<td>1 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">_dc</td>
<td>1756153155667 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">dSource</td>
<td>TRAVELER </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">iFilter1</td>
<td>[empty string] </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">iFilter2</td>
<td>[empty string] </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">iFilters</td>
<td>[empty string] </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">limit</td>
<td>500 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">method</td>
<td>SearchGrid </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">pSize</td>
<td>500 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">page</td>
<td>1 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">pageSize</td>
<td>500 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">returnFormat</td>
<td>json </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">sortcolumn</td>
<td>[empty string] </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">sortdirection</td>
<td>ASC </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">start</td>
<td>0 </td>
</tr>
</tbody>
</table>
</div>
</blockquote>
</div>
</body>
</html>