[Pansophy] Error: Event handler exception.
Adam O'Brien
aobrien at jlab.org
Fri Aug 14 14:25:38 EDT 2020
Valerie,
Nope! I'm new and was just meandering around Pansophy to check out its functionality, figured training would be a safe place to start. Sorry about the mix-up.
Adam O'Brien
EBW Process Engineer
Cell: (513)290-3210
________________________________
From: Valerie Bookwalter <bookwalt at jlab.org>
Sent: Friday, August 14, 2020 1:20 PM
To: Adam O'Brien <aobrien at jlab.org>
Cc: pansophy <pansophy at jlab.org>
Subject: FW: Error: Event handler exception.
Adam O’Brien,
We received an error when you tried to use the new Training Traveler.
This is not yet released and still in testing. Is there something that you
Needed from this traveler?
Valerie
Pansophy Team
From: adapps at jlab.org <adapps at jlab.org>
Sent: Friday, August 14, 2020 12:27 PM
To: Valerie Bookwalter <bookwalt at jlab.org>; Megan McDonald <megan at jlab.org>; Mike Dickey <mdickey at jlab.org>
Subject: Error: Event handler exception.
An error occurred: AOBRIEN
http://pansophy.jlab.org/pansophy/Travelers/TRAVELER_FORM.cfm?project=SRFTRN&area=SRFTRN&system=CERT&TRAV_ID=SRFTRN-CERT&TRAV_REVISION=R1&page=1&maxpage=1&TRAV_SEQ_NUM=-1&travstat=n&serialnum=
Time: 8/14/20 12:27 PM
Error - struct
Cause
Error - struct
Cause
Error - struct
ErrorCode
904
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier
SQLState
42S22
StackTrace
java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddam.t(Unknown Source) at macromedia.jdbc.oraclebase.dde3.y(Unknown Source) at macromedia.jdbc.oraclebase.dde3.u(Unknown Source) at macromedia.jdbc.oraclebase.dde3.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240) at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
87
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CF_SRFTRN-CERT-R1-P1
LINE
1
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
240
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CF_TRAVELER_FORM
LINE
209
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
5
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc
TYPE
CFML
Type
java.sql.SQLSyntaxErrorException
DataSource
TRAVELER
Detail
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier
ErrorCode
42S22
Exceptions
Error - array
1
Error - struct
class
java.sql.SQLSyntaxErrorException
message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier
Message
Error Executing Database Query.
NativeErrorCode
904
RootCause
Error - struct
ErrorCode
904
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier
SQLState
42S22
StackTrace
java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddam.t(Unknown Source) at macromedia.jdbc.oraclebase.dde3.y(Unknown Source) at macromedia.jdbc.oraclebase.dde3.u(Unknown Source) at macromedia.jdbc.oraclebase.dde3.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240) at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
87
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CF_SRFTRN-CERT-R1-P1
LINE
1
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
240
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CF_TRAVELER_FORM
LINE
209
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
5
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc
TYPE
CFML
Type
java.sql.SQLSyntaxErrorException
SQLState
42S22
Sql
Select project_id from adapps.trav_projects where obs is null and retired is null order by project_id
StackTrace
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240) at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddam.t(Unknown Source) at macromedia.jdbc.oraclebase.dde3.y(Unknown Source) at macromedia.jdbc.oraclebase.dde3.u(Unknown Source) at macromedia.jdbc.oraclebase.dde3.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) ... 67 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
87
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CF_SRFTRN-CERT-R1-P1
LINE
1
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
240
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CF_TRAVELER_FORM
LINE
209
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
5
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc
TYPE
CFML
Type
Database
queryError
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier
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
ErrorCode
904
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier
SQLState
42S22
StackTrace
java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddam.t(Unknown Source) at macromedia.jdbc.oraclebase.dde3.y(Unknown Source) at macromedia.jdbc.oraclebase.dde3.u(Unknown Source) at macromedia.jdbc.oraclebase.dde3.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240) at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
87
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CF_SRFTRN-CERT-R1-P1
LINE
1
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
240
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CF_TRAVELER_FORM
LINE
209
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
5
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc
TYPE
CFML
Type
java.sql.SQLSyntaxErrorException
DataSource
TRAVELER
Detail
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier
ErrorCode
42S22
Exceptions
Error - array
1
Error - struct
class
java.sql.SQLSyntaxErrorException
message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier
Message
Error Executing Database Query.
NativeErrorCode
904
RootCause
Error - struct
ErrorCode
904
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier
SQLState
42S22
StackTrace
java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddam.t(Unknown Source) at macromedia.jdbc.oraclebase.dde3.y(Unknown Source) at macromedia.jdbc.oraclebase.dde3.u(Unknown Source) at macromedia.jdbc.oraclebase.dde3.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240) at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
87
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CF_SRFTRN-CERT-R1-P1
LINE
1
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
240
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CF_TRAVELER_FORM
LINE
209
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
5
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc
TYPE
CFML
Type
java.sql.SQLSyntaxErrorException
SQLState
42S22
Sql
Select project_id from adapps.trav_projects where obs is null and retired is null order by project_id
StackTrace
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240) at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddam.t(Unknown Source) at macromedia.jdbc.oraclebase.dde3.y(Unknown Source) at macromedia.jdbc.oraclebase.dde3.u(Unknown Source) at macromedia.jdbc.oraclebase.dde3.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) ... 67 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
87
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CF_SRFTRN-CERT-R1-P1
LINE
1
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
240
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CF_TRAVELER_FORM
LINE
209
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
5
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc
TYPE
CFML
Type
Database
queryError
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier
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:553) 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:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87) at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240) at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) ... 41 more Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "RETIRED": invalid identifier at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddam.t(Unknown Source) at macromedia.jdbc.oraclebase.dde3.y(Unknown Source) at macromedia.jdbc.oraclebase.dde3.u(Unknown Source) at macromedia.jdbc.oraclebase.dde3.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) ... 67 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
87
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705._factor8(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:87)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CF_SRFTRN-CERT-R1-P1
LINE
1
RAW_TRACE
at cfSRFTRN2dCERT2dR12dP12ecfm1835053705.runPage(/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/travelers2012/cfmfiles/SRFTRN/SRFTRN-CERT-R1-P1.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
240
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891._factor6(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:240)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CF_TRAVELER_FORM
LINE
209
RAW_TRACE
at cfTRAVELER_FORM2ecfm346315891.runPage(/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm:209)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Travelers/TRAVELER_FORM.cfm
TYPE
CFML
5
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc684580161$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc
TYPE
CFML
Type
Database
name
onRequest
Form - struct
FIELDNAMES
SUBMIT
SUBMIT
NEW
URL - struct
NCR_NUM
0
SNTYPE
[empty string]
TRAV_ID
SRFTRN-CERT
TRAV_REVISION
R1
TRAV_SEQ_NUM
-1
area
SRFTRN
maxpage
1
page
1
project
SRFTRN
serialnum
[empty string]
system
CERT
title
TRAVELERS
travstat
n
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20200814/285ddd28/attachment-0001.html>
More information about the Pansophy
mailing list