<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
Hi Greg,</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
I see you were getting an error on C100R-CHEM-COMP-DEGR. It should be fixed now</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
Megan</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> adapps@jlab.org <adapps@jlab.org><br>
<b>Sent:</b> Wednesday, May 28, 2025 8:51 AM<br>
<b>To:</b> Valerie Bookwalter <bookwalt@jlab.org>; Megan McDonald <megan@jlab.org>; Matthew Menia <menia@jlab.org>; Mike Dickey <mdickey@jlab.org><br>
<b>Subject:</b> Error: Error Executing Database Query.</font>
<div> </div>
</div>
<div>An error occurred: GROSE <br>
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
<br>
Time: 5/28/25 8:51 AM<br>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Cause</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Cause</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ErrorPosition</td>
<td>862 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Message</td>
<td>ORA-00904: "TRGT"."WINDSN": invalid identifier </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OracleErrorNumber</td>
<td>904 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OriginalSql</td>
<td>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(+)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Sql</td>
<td>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(+)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">StackTrace</td>
<td>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)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Suppressed</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array[empty]
</th>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TagContext</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>181 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">2</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CF_SNQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>131 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">3</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFINVOKE </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>385 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Type</td>
<td>oracle.jdbc.OracleDatabaseException </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ErrorCode</td>
<td>904 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Message</td>
<td>ORA-00904: "TRGT"."WINDSN": invalid identifier </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">SQLState</td>
<td>42000 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">StackTrace</td>
<td>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
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Suppressed</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array[empty]
</th>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TagContext</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>181 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">2</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CF_SNQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>131 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">3</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFINVOKE </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>385 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Type</td>
<td>java.sql.SQLSyntaxErrorException </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">DataSource</td>
<td>TRAVELER </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Detail</td>
<td>ORA-00904: "TRGT"."WINDSN": invalid identifier </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ErrorCode</td>
<td>42000 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Exceptions</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">causes</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ErrorPosition</td>
<td>862 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Message</td>
<td>ORA-00904: "TRGT"."WINDSN": invalid identifier </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OracleErrorNumber</td>
<td>904 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OriginalSql</td>
<td>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(+)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Sql</td>
<td>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(+)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">StackTrace</td>
<td>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)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Suppressed</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array[empty]
</th>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TagContext</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>181 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">2</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CF_SNQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>131 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">3</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFINVOKE </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>385 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Type</td>
<td>oracle.jdbc.OracleDatabaseException </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">class</td>
<td>java.sql.SQLSyntaxErrorException </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">message</td>
<td>ORA-00904: "TRGT"."WINDSN": invalid identifier </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Message</td>
<td>Error Executing Database Query. </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">NativeErrorCode</td>
<td>904 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RootCause</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Cause</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ErrorPosition</td>
<td>862 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Message</td>
<td>ORA-00904: "TRGT"."WINDSN": invalid identifier </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OracleErrorNumber</td>
<td>904 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">OriginalSql</td>
<td>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(+)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Sql</td>
<td>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(+)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">StackTrace</td>
<td>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)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Suppressed</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array[empty]
</th>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TagContext</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>181 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">2</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CF_SNQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>131 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">3</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFINVOKE </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>385 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Type</td>
<td>oracle.jdbc.OracleDatabaseException </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ErrorCode</td>
<td>904 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Message</td>
<td>ORA-00904: "TRGT"."WINDSN": invalid identifier </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">SQLState</td>
<td>42000 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">StackTrace</td>
<td>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
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Suppressed</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array[empty]
</th>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TagContext</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>181 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">2</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CF_SNQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>131 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">3</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFINVOKE </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>385 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Type</td>
<td>java.sql.SQLSyntaxErrorException </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">SQLState</td>
<td>42000 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Sql</td>
<td>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(+)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">StackTrace</td>
<td>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
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Suppressed</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array[empty]
</th>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TagContext</td>
<td>
<table class="x_cfdump_array">
<tbody>
<tr>
<th class="x_array" colspan="2" title="click to collapse" style="">Error - array </th>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">1</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>181 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcDATAREC._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:181)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">2</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CF_SNQUERY </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>131 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcDATAREC.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:131)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_array" title="click to collapse" style="">3</td>
<td>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Error - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">COLUMN</td>
<td>0 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">ID</td>
<td>CFINVOKE </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">LINE</td>
<td>385 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">RAW_TRACE</td>
<td>at cfSNQuery2ecfc979005021$funcPERCENTCLOSED.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc:385)
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TEMPLATE</td>
<td>/sgroup/asd/www/pansophy/html/production/P2024/Components/Queries/SNQuery.cfc
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">TYPE</td>
<td>CFML </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">Type</td>
<td>Database </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">queryError</td>
<td>ORA-00904: "TRGT"."WINDSN": invalid identifier </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">where</td>
<td>(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']
</td>
</tr>
</tbody>
</table>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">Form - struct [empty]</th>
</tr>
</tbody>
</table>
<table class="x_cfdump_struct">
<tbody>
<tr>
<th class="x_struct" colspan="2" title="click to collapse" style="">URL - struct</th>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">_cf_ajaxproxytoken</td>
<td>[empty string] </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">_cf_clientid</td>
<td>5B6E862E03FFE9B1A380E2DA333B9E78 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">_cf_nocache</td>
<td>true </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">_cf_nodebug</td>
<td>true </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">_cf_rc</td>
<td>38 </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">argumentCollection</td>
<td>{"Projects":"C100R","IDTYPE":"WINDSN","IDNAME":"F898271 04"} </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">method</td>
<td>PercentClosed </td>
</tr>
<tr>
<td class="x_struct" title="click to collapse" style="">returnFormat</td>
<td>json </td>
</tr>
</tbody>
</table>
</div>
</body>
</html>