[Pansophy] Fw: Error: Error Executing Database Query.
Megan McDonald
megan at jlab.org
Thu Apr 17 08:21:04 EDT 2025
Hey Peter!
We see you were getting an error yesterday. What were you trying to look at when you received the error message?
Megan
________________________________
From: adapps at jlab.org <adapps at jlab.org>
Sent: Wednesday, April 16, 2025 4:44 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: POWEN
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=86B943EA50FAA2516D72335B31FD66AB&_cf_rc=4&_cf_nodebug=true&_cf_nocache=true&returnFormat=json&_dc=1744836290634&start=0&limit=2500&page=1&sortcolumn=&sortdirection=ASC
Time: 4/16/25 4:44 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:1653) at coldfusion.sql.Executive.executeQuery(Executive.java:1395) at coldfusion.sql.Executive.executeQuery(Executive.java:1325) 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:668) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:598) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:561) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:477) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:451) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:726) 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:1653) at coldfusion.sql.Executive.executeQuery(Executive.java:1395) at coldfusion.sql.Executive.executeQuery(Executive.java:1325) 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:668) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:598) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:561) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:477) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:451) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:726) 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:1653) at coldfusion.sql.Executive.executeQuery(Executive.java:1395) at coldfusion.sql.Executive.executeQuery(Executive.java:1325) 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:668) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:598) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:561) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:477) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:451) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:726) 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:1653) at coldfusion.sql.Executive.executeQuery(Executive.java:1395) at coldfusion.sql.Executive.executeQuery(Executive.java:1325) 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:668) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:598) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:561) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:477) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:451) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:726) 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:1653) at coldfusion.sql.Executive.executeQuery(Executive.java:1395) at coldfusion.sql.Executive.executeQuery(Executive.java:1325) 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:668) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:598) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:561) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:477) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:451) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:726) 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:668) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:598) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:561) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:477) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:451) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:726) 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:1653) at coldfusion.sql.Executive.executeQuery(Executive.java:1395) at coldfusion.sql.Executive.executeQuery(Executive.java:1325) 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 86B943EA50FAA2516D72335B31FD66AB
_cf_nocache true
_cf_nodebug true
_cf_rc 4
_dc 1744836290634
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/20250417/a971fa12/attachment-0001.htm>
More information about the Pansophy
mailing list