[Pansophy] Fw: Error: Error Executing Database Query.
Alex Castilla Loeza
acastill at jlab.org
Mon Aug 25 16:47:51 EDT 2025
Hi Valerie,
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.
Kindly,
a.
Get BlueMail for Android<https://bluemail.me>
On Aug 25, 2025, at 4:44 PM, Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>> wrote:
Alex,
I see you are getting an error.
Please let me know what you are trying to do and we will try to help resolve.
Thank you.
Valerie Bookwalter
Jefferson Lab, Accelerator Dept.
SRFOPS Software Systems Group
bookwalt at jlab.org<mailto:bookwalt at jlab.org>
757-269-5802
________________________________
From: adapps at jlab.org <adapps at jlab.org>
Sent: Monday, August 25, 2025 4:19 PM
To: Valerie Bookwalter <bookwalt at jlab.org>; Megan McDonald <megan at jlab.org>; Matthew Menia <menia at jlab.org>; Mike Dickey <mdickey at jlab.org>
Subject: Error: Error Executing Database Query.
An error occurred: ACASTILL
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
Time: 8/25/25 4:19 PM
Error - struct
Cause
Error - struct
Cause
Error - struct
ErrorPosition 16
Message ORA-00936: missing expression
OracleErrorNumber 936
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
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
StackTrace 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)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 157
RAW_TRACE at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc
TYPE CFML
Type oracle.jdbc.OracleDatabaseException
ErrorCode 936
Message ORA-00936: missing expression
SQLState 42000
StackTrace 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
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 157
RAW_TRACE at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource TRAVELER
Detail ORA-00936: missing expression
ErrorCode 42000
Exceptions
Error - array
1
Error - struct
causes
Error - array
1
Error - struct
ErrorPosition 16
Message ORA-00936: missing expression
OracleErrorNumber 936
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
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
StackTrace 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)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 157
RAW_TRACE at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc
TYPE CFML
Type oracle.jdbc.OracleDatabaseException
class java.sql.SQLSyntaxErrorException
message ORA-00936: missing expression
Message Error Executing Database Query.
NativeErrorCode 936
RootCause
Error - struct
Cause
Error - struct
ErrorPosition 16
Message ORA-00936: missing expression
OracleErrorNumber 936
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
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
StackTrace 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)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 157
RAW_TRACE at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc
TYPE CFML
Type oracle.jdbc.OracleDatabaseException
ErrorCode 936
Message ORA-00936: missing expression
SQLState 42000
StackTrace 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
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 157
RAW_TRACE at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42000
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
StackTrace 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
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 157
RAW_TRACE at cfTDNFilter2ecfc1985116040$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc:157)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter.cfc
TYPE CFML
Type Database
queryError ORA-00936: missing expression
where [empty string]
Form - struct [empty]
URL - struct
AfterDate [empty string]
BeforeDate [empty string]
BoolField trav_complete
BooleanSelect -1
Conditions 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
DateOption all
Fields , ,
KeyDates [empty string]
OrderBy [empty string]
Tables adapps. trgt, adapps.TRAV_OWNERS tos, adapps.TRAV_HEADER th
_cf_ajaxproxytoken [empty string]
_cf_clientid DF8073CE121A051490D391FB4710E7E5
_cf_nocache true
_cf_nodebug true
_cf_rc 1
_dc 1756153155667
dSource TRAVELER
iFilter1 [empty string]
iFilter2 [empty string]
iFilters [empty string]
limit 500
method SearchGrid
pSize 500
page 1
pageSize 500
returnFormat json
sortcolumn [empty string]
sortdirection ASC
start 0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20250825/6b94fb84/attachment-0001.htm>
More information about the Pansophy
mailing list