[Pansophy] Error: Event handler exception.

Fri Aug 14 16:20:45 EDT 2020

No problem Adam.

Let us know if you would like a tour through Pansophy.
Just email pansophy at jlab.org for any questions.
Megan or myself can get you up to speed per se.
Welcome Aboard.

Valerie
Pansophy Team
________________________________
From: Adam O'Brien <aobrien at jlab.org>
Sent: Friday, August 14, 2020 2:25 PM
To: Valerie Bookwalter <bookwalt at jlab.org>
Cc: pansophy <pansophy at jlab.org>
Subject: Re: Error: Event handler exception.

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/1c0ad91a/attachment-0001.html>