[Pansophy] Fw: Error: Error Executing Database Query.

Wed May 28 09:07:09 EDT 2025

Hi Greg,
I see you were getting an error on C100R-CHEM-COMP-DEGR. It should be fixed now
Megan
________________________________
From: adapps at jlab.org <adapps at jlab.org>
Sent: Wednesday, May 28, 2025 8:51 AM
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: GROSE
http://pansophy.jlab.org/production/P2024/Components/Queries/SNQuery.cfc?method=PercentClosed&_cf_ajaxproxytoken=&returnFormat=json&argumentCollection=%7B%22Projects%22%3A%22C100R%22%2C%22IDTYPE%22%3A%22WINDSN%22%2C%22IDNAME%22%3A%22F898271%2004%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=5B6E862E03FFE9B1A380E2DA333B9E78&_cf_rc=38
Time: 5/28/25 8:51 AM
Error - struct
Cause
Error - struct
Cause
Error - struct
ErrorPosition   862
Message ORA-00904: "TRGT"."WINDSN": invalid identifier
OracleErrorNumber       904
OriginalSql     SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = ?) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = ?) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+)
Sql     SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = :1 ) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = :2 ) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+)
StackTrace      Error : 904, Position : 862, Sql = SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = :1 ) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = :2 ) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+), OriginalSql = SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = ?) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = ?) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+), Error Msg = ORA-00904: "TRGT"."WINDSN": 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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1665) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181) at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:669) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:599) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:562) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:450) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:727) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:571) at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:669) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:599) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:562) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:450) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:727) 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    181
RAW_TRACE       at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
2
Error - struct
COLUMN  0
ID      CF_SNQUERY
LINE    131
RAW_TRACE       at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
3
Error - struct
COLUMN  0
ID      CFINVOKE
LINE    385
RAW_TRACE       at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
Type    oracle.jdbc.OracleDatabaseException
ErrorCode       904
Message ORA-00904: "TRGT"."WINDSN": invalid identifier
SQLState        42000
StackTrace      java.sql.SQLSyntaxErrorException: ORA-00904: "TRGT"."WINDSN": 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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1665) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181) at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:669) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:599) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:562) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:450) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:727) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:571) at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:669) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:599) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:562) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:450) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:727) 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 : 862, Sql = SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = :1 ) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = :2 ) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+), OriginalSql = SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = ?) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = ?) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+), Error Msg = ORA-00904: "TRGT"."WINDSN": invalid identifier at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 83 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN  0
ID      CFQUERY
LINE    181
RAW_TRACE       at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
2
Error - struct
COLUMN  0
ID      CF_SNQUERY
LINE    131
RAW_TRACE       at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
3
Error - struct
COLUMN  0
ID      CFINVOKE
LINE    385
RAW_TRACE       at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
Type    java.sql.SQLSyntaxErrorException
DataSource      TRAVELER
Detail  ORA-00904: "TRGT"."WINDSN": invalid identifier
ErrorCode       42000
Exceptions
Error - array
1
Error - struct
causes
Error - array
1
Error - struct
ErrorPosition   862
Message ORA-00904: "TRGT"."WINDSN": invalid identifier
OracleErrorNumber       904
OriginalSql     SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = ?) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = ?) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+)
Sql     SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = :1 ) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = :2 ) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+)
StackTrace      Error : 904, Position : 862, Sql = SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = :1 ) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = :2 ) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+), OriginalSql = SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = ?) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = ?) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+), Error Msg = ORA-00904: "TRGT"."WINDSN": 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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1665) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181) at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:669) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:599) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:562) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:450) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:727) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:571) at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:669) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:599) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:562) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:450) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:727) 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    181
RAW_TRACE       at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
2
Error - struct
COLUMN  0
ID      CF_SNQUERY
LINE    131
RAW_TRACE       at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
3
Error - struct
COLUMN  0
ID      CFINVOKE
LINE    385
RAW_TRACE       at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
Type    oracle.jdbc.OracleDatabaseException
class   java.sql.SQLSyntaxErrorException
message ORA-00904: "TRGT"."WINDSN": invalid identifier
Message Error Executing Database Query.
NativeErrorCode 904
RootCause
Error - struct
Cause
Error - struct
ErrorPosition   862
Message ORA-00904: "TRGT"."WINDSN": invalid identifier
OracleErrorNumber       904
OriginalSql     SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = ?) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = ?) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+)
Sql     SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = :1 ) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = :2 ) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+)
StackTrace      Error : 904, Position : 862, Sql = SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = :1 ) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = :2 ) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+), OriginalSql = SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = ?) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = ?) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+), Error Msg = ORA-00904: "TRGT"."WINDSN": 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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1665) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181) at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:669) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:599) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:562) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:450) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:727) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:571) at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:669) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:599) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:562) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:450) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:727) 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    181
RAW_TRACE       at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
2
Error - struct
COLUMN  0
ID      CF_SNQUERY
LINE    131
RAW_TRACE       at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
3
Error - struct
COLUMN  0
ID      CFINVOKE
LINE    385
RAW_TRACE       at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
Type    oracle.jdbc.OracleDatabaseException
ErrorCode       904
Message ORA-00904: "TRGT"."WINDSN": invalid identifier
SQLState        42000
StackTrace      java.sql.SQLSyntaxErrorException: ORA-00904: "TRGT"."WINDSN": 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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1665) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181) at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:669) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:599) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:562) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:450) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:727) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:571) at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:669) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:599) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:562) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:450) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:727) 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 : 862, Sql = SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = :1 ) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = :2 ) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+), OriginalSql = SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = ?) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = ?) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+), Error Msg = ORA-00904: "TRGT"."WINDSN": invalid identifier at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 83 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN  0
ID      CFQUERY
LINE    181
RAW_TRACE       at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
2
Error - struct
COLUMN  0
ID      CF_SNQUERY
LINE    131
RAW_TRACE       at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
3
Error - struct
COLUMN  0
ID      CFINVOKE
LINE    385
RAW_TRACE       at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
Type    java.sql.SQLSyntaxErrorException
SQLState        42000
Sql     SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = (param 1) ) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = (param 2) ) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+)
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 cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181) at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:669) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:599) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:562) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:450) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:727) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:571) at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:669) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:599) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:562) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:450) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:727) 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: "TRGT"."WINDSN": 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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1665) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) ... 62 more Caused by: Error : 904, Position : 862, Sql = SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = :1 ) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = :2 ) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+), OriginalSql = SELECT trgt.trav_seq_num, trgt.WINDSN serial_number, tos.trav_revision, trav_open_who, trav_open_date, trav_complete, trav_close_who, trav_close_date, trav_max_page, D3, d3_name, d3_rev, d3_stat, d3_max_page, NCR, ncr_name, ncr_rev, ncr_stat, ncr_max_page, 'maxpage='||trav_max_page||'&trav_revision='||tos.trav_revision||'&trav_seq_num='||trgt.trav_seq_num||'&travstat='||trav_complete||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN travlink, 'maxpage='||ncr_max_page||'&trav_id='||ncr_name||'&trav_revision='||ncr_rev||'&trav_seq_num='||NCR||'&travstat='||ncr_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN ntravlink, 'maxpage='||d3_max_page||'&trav_id='||d3_name||'&trav_revision='||d3_rev||'&trav_seq_num='||D3||'&travstat='||d3_stat||'&serialnum='||trgt.WINDSN||'&SN='||trgt.WINDSN dtravlink FROM adapps.C100RCHEMCOMPDEGR trgt, adapps.TRAV_HEADER th, adapps.TRAV_OWNERS tos, (SELECT DISTINCT tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num ntrav, toa.trav_seq_num ncr, toa.trav_revision ncr_rev, toa.trav_id ncr_name, toa.trav_complete ncr_stat, trav_max_page ncr_max_page FROM adapps.TRAV_OWNERS toa, adapps.TRAV_OWNERS tob, adapps.TRAV_HEADER th WHERE toa.ncrid = tob.trav_id||'-'||tob.trav_revision||'-'||tob.trav_seq_num AND th.trav_id = toa.trav_id AND th.obs is null AND th.trav_revision = toa.trav_revision AND tob.trav_id = ?) ncrs, (SELECT DISTINCT tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num dtrav, toc.trav_seq_num d3, toc.trav_revision d3_rev, toc.trav_id d3_name, toc.trav_complete d3_stat, trav_max_page d3_max_page FROM adapps.TRAV_OWNERS toc, adapps.TRAV_OWNERS tod, adapps.TRAV_HEADER th WHERE toc.d3id = tod.trav_id||'-'||tod.trav_revision||'-'||tod.trav_seq_num AND th.trav_id = toc.trav_id AND th.obs is null AND th.trav_revision = toc.trav_revision AND tod.trav_id = ?) d3s WHERE tos.trav_id = 'C100R-CHEM-COMP-DEGR' AND tos.trav_id = th.trav_id AND tos.trav_revision = th.trav_revision 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 tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = ntrav(+) AND tos.trav_id||'-'||tos.trav_revision||'-'||tos.trav_seq_num = dtrav(+), Error Msg = ORA-00904: "TRGT"."WINDSN": invalid identifier at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 83 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN  0
ID      CFQUERY
LINE    181
RAW_TRACE       at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
2
Error - struct
COLUMN  0
ID      CF_SNQUERY
LINE    131
RAW_TRACE       at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
3
Error - struct
COLUMN  0
ID      CFINVOKE
LINE    385
RAW_TRACE       at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385)
TEMPLATE        /sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
TYPE    CFML
Type    Database
queryError      ORA-00904: "TRGT"."WINDSN": invalid identifier
where   (param 1) = [type='IN', class='java.lang.String', value='C100R-CHEM-COMP-DEGR', sqltype='cf_sql_varchar'] , (param 2) = [type='IN', class='java.lang.String', value='C100R-CHEM-COMP-DEGR', sqltype='cf_sql_varchar']
Form - struct [empty]
URL - struct
_cf_ajaxproxytoken      [empty string]
_cf_clientid    5B6E862E03FFE9B1A380E2DA333B9E78
_cf_nocache     true
_cf_nodebug     true
_cf_rc  38
argumentCollection      {"Projects":"C100R","IDTYPE":"WINDSN","IDNAME":"F898271 04"}
method  PercentClosed
returnFormat    json
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20250528/d2726d35/attachment-0001.htm>