[Pansophy] Fw: Error: Error Executing Database Query.
Valerie Bookwalter
bookwalt at jlab.org
Wed Mar 5 08:27:56 EST 2025
Adam,
I noticed you were getting an error last evening.
Would you please describe specifically what you were trying to look at so that we may correct the issue.
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: Tuesday, March 4, 2025 5:18 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: ADAMG
http://pansophy.jlab.org/production/P2024/Components/Global/TDNFilter2.cfc?method=SearchGrid&gpk=3&TRAVID=JLAB-NCR,JLAB-NCR&SerialName=SN&BooleanSelect=-1&iFilter1=&iFilter2=&DateOption=all&AfterDate=&BeforeDate=&pSize=2500&pageSize=2500&_cf_ajaxproxytoken=&_cf_clientid=40815838CF5F5394FD2273CC5BD7AE44&_cf_rc=4&_cf_nodebug=true&_cf_nocache=true&returnFormat=json&_dc=1741126680247&start=0&limit=2500&page=1&sortcolumn=&sortdirection=ASC
Time: 3/4/25 5:18 PM
Error - struct
Cause
Error - struct
Cause
Error - struct
ErrorPosition 472
Message ORA-00904: "VERIFYDATE1": invalid identifier
OracleErrorNumber 904
OriginalSql SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision
Sql SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision
StackTrace Error : 904, Position : 472, Sql = SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision, OriginalSql = SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision, Error Msg = ORA-00904: "VERIFYDATE1": invalid identifier 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:1642) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) 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 cfTDNFilter22ecfc1369551070$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc:323) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:687) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:261) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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 323
RAW_TRACE at cfTDNFilter22ecfc1369551070$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc:323)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc
TYPE CFML
Type oracle.jdbc.OracleDatabaseException
ErrorCode 904
Message ORA-00904: "VERIFYDATE1": invalid identifier
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: ORA-00904: "VERIFYDATE1": invalid identifier 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:1642) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) 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 cfTDNFilter22ecfc1369551070$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc:323) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:687) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:261) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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 : 904, Position : 472, Sql = SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision, OriginalSql = SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision, Error Msg = ORA-00904: "VERIFYDATE1": invalid identifier 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 323
RAW_TRACE at cfTDNFilter22ecfc1369551070$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc:323)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource TRAVELER
Detail ORA-00904: "VERIFYDATE1": invalid identifier
ErrorCode 42000
Exceptions
Error - array
1
Error - struct
causes
Error - array
1
Error - struct
ErrorPosition 472
Message ORA-00904: "VERIFYDATE1": invalid identifier
OracleErrorNumber 904
OriginalSql SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision
Sql SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision
StackTrace Error : 904, Position : 472, Sql = SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision, OriginalSql = SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision, Error Msg = ORA-00904: "VERIFYDATE1": invalid identifier 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:1642) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) 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 cfTDNFilter22ecfc1369551070$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc:323) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:687) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:261) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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 323
RAW_TRACE at cfTDNFilter22ecfc1369551070$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc:323)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc
TYPE CFML
Type oracle.jdbc.OracleDatabaseException
class java.sql.SQLSyntaxErrorException
message ORA-00904: "VERIFYDATE1": invalid identifier
Message Error Executing Database Query.
NativeErrorCode 904
RootCause
Error - struct
Cause
Error - struct
ErrorPosition 472
Message ORA-00904: "VERIFYDATE1": invalid identifier
OracleErrorNumber 904
OriginalSql SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision
Sql SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision
StackTrace Error : 904, Position : 472, Sql = SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision, OriginalSql = SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision, Error Msg = ORA-00904: "VERIFYDATE1": invalid identifier 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:1642) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) 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 cfTDNFilter22ecfc1369551070$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc:323) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:687) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:261) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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 323
RAW_TRACE at cfTDNFilter22ecfc1369551070$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc:323)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc
TYPE CFML
Type oracle.jdbc.OracleDatabaseException
ErrorCode 904
Message ORA-00904: "VERIFYDATE1": invalid identifier
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: ORA-00904: "VERIFYDATE1": invalid identifier 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:1642) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) 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 cfTDNFilter22ecfc1369551070$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc:323) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:687) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:261) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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 : 904, Position : 472, Sql = SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision, OriginalSql = SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision, Error Msg = ORA-00904: "VERIFYDATE1": invalid identifier 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 323
RAW_TRACE at cfTDNFilter22ecfc1369551070$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc:323)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42000
Sql SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision
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 cfTDNFilter22ecfc1369551070$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc:323) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:687) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:261) 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:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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-00904: "VERIFYDATE1": invalid identifier 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:1642) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) 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 : 904, Position : 472, Sql = SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision, OriginalSql = SELECT DISTINCT tos.trav_seq_num,tos.trav_revision,trav_open_date,trav_close_date,partdescription,dbms_lob.substr(describecomment,4000,1) describecomment,describestaff,describedate,tos.trav_complete,respondingengineer,respondingdate,initialdisposition,trav_max_page,attachTravs.travseqnumber,attachTravs.travelerid,trgt.SN,attachTravs.travelerrevision,attachTravs.trav_comp,attachTravs.attachTrav_max_page,reworkstaff,finalengineer,finaldate,finaldisposition,ReworkDate1,VerifyDate1,'maxpage='||TRAV_MAX_PAGE||'&trav_revision='||tos.TRAV_REVISION||'&trav_seq_num='||tos.trav_seq_num||'&travstat='||tos.TRAV_COMPLETE||'&serialnum='||sn||'&SN='||sn ncrlink, 'maxpage='||attachTravs.ATTACHTRAV_MAX_PAGE||'&trav_id='||attachTravs.TRAVELERID||'&trav_revision='||attachTravs.TRAVELERREVISION||'&trav_seq_num='||attachTravs.TRAVSEQNUMBER||'&travstat='||attachTravs.TRAV_COMP||'&serialnum='||sn||'&SN='||sn ntravlink FROM adapps.JLABNCR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT ref.travelerid, ref.travelerrevision, ref.travseqnumber, trav_complete trav_comp, thd.trav_max_page attachTrav_max_page FROM adapps.JLABNCR ref, adapps.TRAV_HEADER thd, adapps.TRAV_OWNERS tob WHERE tob.trav_id = ref.travelerid AND thd.trav_id = ref.travelerid AND tob.trav_revision = ref.travelerrevision AND thd.trav_revision = ref.travelerrevision AND tob.trav_seq_num = ref.travseqnumber AND tob.obs is null AND thd.obs is null AND ref.obs is null) attachTravs WHERE tos.trav_id = 'JLAB-NCR' and th.trav_id = tos.trav_id and tos.trav_revision = th.trav_revision and tos.ncrid = attachTravs.travelerid||'-'||attachTravs.travelerrevision||'-'||attachTravs.travseqnumber and tos.trav_seq_num = trgt.trav_seq_num and tos.obs is null and trgt.obs is null and th.obs is null AND attachTravs.travelerid = '' AND disposition = '' ORDER BY tos.trav_seq_num, tos.trav_revision, Error Msg = ORA-00904: "VERIFYDATE1": invalid identifier 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 323
RAW_TRACE at cfTDNFilter22ecfc1369551070$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc:323)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Global/TDNFilter2.cfc
TYPE CFML
Type Database
queryError ORA-00904: "VERIFYDATE1": invalid identifier
where [empty string]
Form - struct [empty]
URL - struct
AfterDate [empty string]
BeforeDate [empty string]
BooleanSelect -1
DateOption all
SerialName SN
TRAVID JLAB-NCR,JLAB-NCR
_cf_ajaxproxytoken [empty string]
_cf_clientid 40815838CF5F5394FD2273CC5BD7AE44
_cf_nocache true
_cf_nodebug true
_cf_rc 4
_dc 1741126680247
gpk 3
iFilter1 [empty string]
iFilter2 [empty string]
limit 2500
method SearchGrid
pSize 2500
page 1
pageSize 2500
returnFormat json
sortcolumn [empty string]
sortdirection ASC
start 0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20250305/52c6d459/attachment-0001.html>
More information about the Pansophy
mailing list