[Pansophy] BRAZ TRAVELER Re: Error: Event handler exception.
Megan McDonald
megan at jlab.org
Tue Sep 30 13:32:01 EDT 2025
Hi Greg,
Just sending an email to have close the gap on our discussion over Taco Tuesday.
It appears that Tiffany had told us that she needed data moved to C100R-FURN-CEBRZ-BRAZ from another traveler. I searched my email and found no information on this. You mentioned at lunch that the traveler was pulled and separated from another, C100R-FURN-WBA-BRAZ.
Could you go through the traveler and maybe any other emails or previous discussions with Tiffany on this? I am fine with moving data, especially if it facilitates the functionality of the WINWGD Status Board, I just need to know what data. I am also willing to assist with any datamining that may be helpful in determining this information
Megan
________________________________
From: Gregory Grose <grose at jlab.org>
Sent: Tuesday, September 30, 2025 9:26 AM
To: Megan McDonald <megan at jlab.org>
Cc: pansophy <pansophy at jlab.org>
Subject: Re: Error: Event handler exception.
Both work. Thanks Megan.
Greg
________________________________
From: Megan McDonald <megan at jlab.org>
Sent: Monday, September 29, 2025 4:05 PM
To: Gregory Grose <grose at jlab.org>
Cc: pansophy <pansophy at jlab.org>
Subject: Re: Error: Event handler exception.
Can you try it now?
Megan
________________________________
From: Gregory Grose <grose at jlab.org>
Sent: Monday, September 29, 2025 3:53 PM
To: Megan McDonald <megan at jlab.org>
Cc: pansophy <pansophy at jlab.org>
Subject: Re: Error: Event handler exception.
And while I've got you, I also have been receiving an error when submitting traveler C100R-FURN-CEBRZ-BRAZ. (Apologies for tacking this on but it just crossed my mind.)
Greg
________________________________
From: Gregory Grose <grose at jlab.org>
Sent: Monday, September 29, 2025 3:51 PM
To: Megan McDonald <megan at jlab.org>
Cc: pansophy <pansophy at jlab.org>
Subject: Re: Error: Event handler exception.
Yes via SN search
Greg
________________________________
From: Megan McDonald <megan at jlab.org>
Sent: Monday, September 29, 2025 3:39 PM
To: Gregory Grose <grose at jlab.org>
Cc: pansophy <pansophy at jlab.org>
Subject: Re: Error: Event handler exception.
Nevermind, I see the traveler is no longer online. How are you accessing this? Via SN search?
Megan
________________________________
From: Megan McDonald <megan at jlab.org>
Sent: Monday, September 29, 2025 3:38 PM
To: Gregory Grose <grose at jlab.org>
Subject: Fw: Error: Event handler exception.
Hey Greg,
I see you're getting an error in C100R-INSP-WGD-RCYC. Can you describe what you're doing when you get the error?
Megan
________________________________
From: adapps at jlab.org <adapps at jlab.org>
Sent: Monday, September 29, 2025 3:20 PM
To: Valerie Bookwalter <bookwalt at jlab.org>; Megan McDonald <megan at jlab.org>; Matthew Menia <menia at jlab.org>; Mike Dickey <mdickey at jlab.org>
Subject: Error: Event handler exception.
An error occurred: GROSE
http://pansophy.jlab.org/pansophy/Travelers/TRAVELER_FORM.cfm?project=C100R&area=C100R&system=INSP&page=1&SNType=WGDSN&trav_id=C100R-INSP-WGD-RCYC&maxpage=5&trav_revision=R2&trav_seq_num=37&travstat=y&serialnum=F067764/13&SN=F067764/13
Time: 9/29/25 3:20 PM
Error - struct
Cause
Error - struct
Cause
Error - struct
Cause
Error - struct
ErrorPosition 385
Message ORA-01747: invalid user.table.column, table.column, or column specification
OracleErrorNumber 1747
OriginalSql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
Sql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
StackTrace Error : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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 cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type oracle.jdbc.OracleDatabaseException
ErrorCode 1747
Message ORA-01747: invalid user.table.column, table.column, or column specification
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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 cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) 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 : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 100 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource TRAVELER
Detail ORA-01747: invalid user.table.column, table.column, or column specification
ErrorCode 42000
Exceptions
Error - array
1
Error - struct
causes
Error - array
1
Error - struct
ErrorPosition 385
Message ORA-01747: invalid user.table.column, table.column, or column specification
OracleErrorNumber 1747
OriginalSql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
Sql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
StackTrace Error : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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 cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type oracle.jdbc.OracleDatabaseException
class java.sql.SQLSyntaxErrorException
message ORA-01747: invalid user.table.column, table.column, or column specification
Message Error Executing Database Query.
NativeErrorCode 1747
RootCause
Error - struct
Cause
Error - struct
ErrorPosition 385
Message ORA-01747: invalid user.table.column, table.column, or column specification
OracleErrorNumber 1747
OriginalSql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
Sql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
StackTrace Error : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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 cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type oracle.jdbc.OracleDatabaseException
ErrorCode 1747
Message ORA-01747: invalid user.table.column, table.column, or column specification
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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 cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) 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 : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 100 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42000
Sql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) 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-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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) ... 80 more Caused by: Error : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 100 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type Database
queryError ORA-01747: invalid user.table.column, table.column, or column specification
where [empty string]
Detail An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.
Message Event handler exception.
RootCause
Error - struct
Cause
Error - struct
Cause
Error - struct
ErrorPosition 385
Message ORA-01747: invalid user.table.column, table.column, or column specification
OracleErrorNumber 1747
OriginalSql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
Sql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
StackTrace Error : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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 cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type oracle.jdbc.OracleDatabaseException
ErrorCode 1747
Message ORA-01747: invalid user.table.column, table.column, or column specification
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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 cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) 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 : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 100 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource TRAVELER
Detail ORA-01747: invalid user.table.column, table.column, or column specification
ErrorCode 42000
Exceptions
Error - array
1
Error - struct
causes
Error - array
1
Error - struct
ErrorPosition 385
Message ORA-01747: invalid user.table.column, table.column, or column specification
OracleErrorNumber 1747
OriginalSql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
Sql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
StackTrace Error : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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 cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type oracle.jdbc.OracleDatabaseException
class java.sql.SQLSyntaxErrorException
message ORA-01747: invalid user.table.column, table.column, or column specification
Message Error Executing Database Query.
NativeErrorCode 1747
RootCause
Error - struct
Cause
Error - struct
ErrorPosition 385
Message ORA-01747: invalid user.table.column, table.column, or column specification
OracleErrorNumber 1747
OriginalSql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
Sql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
StackTrace Error : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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 cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type oracle.jdbc.OracleDatabaseException
ErrorCode 1747
Message ORA-01747: invalid user.table.column, table.column, or column specification
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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 cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) 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 : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 100 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42000
Sql SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) 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-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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) ... 80 more Caused by: Error : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 100 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type Database
queryError ORA-01747: invalid user.table.column, table.column, or column specification
where [empty string]
StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:319) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) 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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: 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 cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10) at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9) at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) ... 41 more Caused by: java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) 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) ... 80 more Caused by: Error : 1747, Position : 385, Sql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, OriginalSql = SELECT DISTINCT TRAV_OWNERS.TRAV_SEQ_NUM, TRAV_OWNERS.TRAV_OPEN_WHO, TRAV_OWNERS.TRAV_ID, TRAV_OWNERS.TRAV_REVISION, TRAV_OWNERS.mod_user, TRAV_OWNERS.mod_date, TRAV_OWNERS.NCRID, TRAV_OWNERS.TRAV_COMPLETE, TRAV_OWNERS.TRAV_CLOSE_WHO, TRAV_HEADER.TRAV_MAX_PAGE, C100RINSPWGDRCYC. AS myvar FROM adapps.TRAV_OWNERS, adapps.TRAV_HEADER, adapps.C100RINSPWGDRCYC WHERE TRAV_OWNERS.TRAV_ID = TRAV_HEADER.TRAV_ID AND TRAV_OWNERS.TRAV_REVISION = TRAV_HEADER.TRAV_REVISION AND TRAV_OWNERS.TRAV_SEQ_NUM = C100RINSPWGDRCYC.TRAV_SEQ_NUM AND TRAV_OWNERS.TRAV_ID='C100R-INSP-WGD-RCYC' AND C100RINSPWGDRCYC.obs is NULL AND TRAV_OWNERS.obs is NULL ORDER BY TRAV_OWNERS.TRAV_SEQ_NUM DESC, Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 100 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 58
RAW_TRACE at cfGET_SERIAL_VARIABLE2ecfc2122272077$funcGET_SERIAL_VARIABLE.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc:58)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Components/Travelers/GET_SERIAL_VARIABLE.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 12
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor1(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:12)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 10
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor2(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:10)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 9
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460._factor12(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:9)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
5
Error - struct
COLUMN 0
ID CF_TRAVELER_MENU_BAR
LINE 1
RAW_TRACE at cfTRAVELER_MENU_BAR2ecfm1576295460.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm:1)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_MENU_BAR.cfm
TYPE CFML
6
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 239
RAW_TRACE at cfTRAVELER_FORM2ecfm1176187272.runPage(/sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm:239)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Travelers/TRAVELER_FORM.cfm
TYPE CFML
7
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 257
RAW_TRACE at cfApplication2ecfc433765026$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2024/Application.cfc:257)
TEMPLATE /sgroup/asd/www/pansophy/html/production/P2024/Application.cfc
TYPE CFML
Type Database
name onRequest
Form - struct [empty]
URL - struct
NCR_NUM 0
SN F067764/13
SNType WGDSN
area C100R
maxpage 5
page 1
project C100R
serialnum F067764/13
system INSP
title pansophy/TRAVELERS
trav_id C100R-INSP-WGD-RCYC
trav_revision R2
trav_seq_num 37
travstat y
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20250930/9cd6f37d/attachment-0001.htm>
More information about the Pansophy
mailing list