[Pansophy] Error: Error Executing Database Query.
Ashley Mitchell
ashleya at jlab.org
Wed Jan 10 13:56:22 EST 2024
I have no idea, I probably was clicking where I shouldn't be looking for something.
Sorry I'm not more helpful. I got whatever I was looking for.
- Ashley
________________________________
From: Valerie Bookwalter <bookwalt at jlab.org>
Sent: Wednesday, January 10, 2024 12:15 PM
To: Ashley Mitchell <ashleya at jlab.org>
Cc: pansophy <pansophy at jlab.org>
Subject: FW: Error: Error Executing Database Query.
Ashley,
I see you received an error yesterday.
What were you investigating when this occurred?
Valerie Bookwalter
Jefferson Lab, ACC
SRF Operations
SRFOPS Software Systems Group
1-757-269-5802 (OFFICE – currently working offsite)
From: adapps at jlab.org <adapps at jlab.org>
Sent: Tuesday, January 9, 2024 11:43 AM
To: Valerie Bookwalter <bookwalt at jlab.org>; Megan McDonald <megan at jlab.org>; Mike Dickey <mdickey at jlab.org>; Allen Samuels <samuels at jlab.org>; Matthew Menia <menia at jlab.org>
Subject: Error: Error Executing Database Query.
An error occurred: ASHLEYA
http://pansophy.jlab.org/production/P2022/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%27ER5C-CMA-CM-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=53DE1C8C58AC9686&_cf_clientid=F4B91F049662E8EE48F33578709C5D74&_cf_rc=1&_cf_nodebug=true&_cf_nocache=true&returnFormat=json&_dc=1704818571738&start=0&limit=500&page=1&sortcolumn=&sortdirection=ASC
Time: 1/9/24 11:42 AM
Error - struct
Cause
Error - struct
ErrorCode
936
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00936: missing expression
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00936: missing expression at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456) at macromedia.jdbc.oracle.am.a(OracleImplResultset.java:935) at macromedia.jdbc.oracle.am.a(OracleImplResultset.java:484) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3327) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.oraclebase.go.execute(BaseStatement.java:4425) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfTDNFilter2ecfc1910689674$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/TDNFilter.cfc:157) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:251) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:588) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:156) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:298) at javax.servlet.http.HttpServlet.service(HttpServlet.java:655) at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
157
RAW_TRACE
at cfTDNFilter2ecfc1910689674$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/TDNFilter.cfc:157)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/TDNFilter.cfc
TYPE
CFML
Type
java.sql.SQLException
DataSource
TRAVELER
Detail
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00936: missing expression
ErrorCode
HY000
Exceptions
Error - array
1
Error - struct
class
java.sql.SQLException
message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00936: missing expression
Message
Error Executing Database Query.
NativeErrorCode
936
RootCause
Error - struct
ErrorCode
936
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00936: missing expression
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00936: missing expression at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456) at macromedia.jdbc.oracle.am.a(OracleImplResultset.java:935) at macromedia.jdbc.oracle.am.a(OracleImplResultset.java:484) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3327) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.oraclebase.go.execute(BaseStatement.java:4425) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfTDNFilter2ecfc1910689674$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/TDNFilter.cfc:157) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:251) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:588) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:156) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:298) at javax.servlet.http.HttpServlet.service(HttpServlet.java:655) at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
157
RAW_TRACE
at cfTDNFilter2ecfc1910689674$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/TDNFilter.cfc:157)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/TDNFilter.cfc
TYPE
CFML
Type
java.sql.SQLException
SQLState
HY000
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 = 'ER5C-CMA-CM-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:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfTDNFilter2ecfc1910689674$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/TDNFilter.cfc:157) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:251) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:588) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:156) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:298) at javax.servlet.http.HttpServlet.service(HttpServlet.java:655) at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00936: missing expression at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456) at macromedia.jdbc.oracle.am.a(OracleImplResultset.java:935) at macromedia.jdbc.oracle.am.a(OracleImplResultset.java:484) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3327) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.oraclebase.go.execute(BaseStatement.java:4425) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) ... 53 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
157
RAW_TRACE
at cfTDNFilter2ecfc1910689674$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/TDNFilter.cfc:157)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Components/Global/TDNFilter.cfc
TYPE
CFML
Type
Database
queryError
[Macromedia][Oracle JDBC Driver][Oracle]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 = 'ER5C-CMA-CM-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
53DE1C8C58AC9686
_cf_clientid
F4B91F049662E8EE48F33578709C5D74
_cf_nocache
true
_cf_nodebug
true
_cf_rc
1
_dc
1704818571738
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/20240110/008161d8/attachment-0001.html>
More information about the Pansophy
mailing list