[Pansophy] Error: Event handler exception. - Shipping Form Error
Naeem Huque
huque at jlab.org
Thu Jul 6 12:58:59 EDT 2023
Hi Valerie,
I tried to create a new form with some AUPPS serial numbers. The error came up when I hit submit
Thanks,
Naeem
________________________________
From: Valerie Bookwalter <bookwalt at jlab.org>
Sent: Thursday, July 6, 2023 11:40 AM
To: Naeem Huque <huque at jlab.org>
Cc: pansophy <pansophy at jlab.org>
Subject: FW: Error: Event handler exception. - Shipping Form Error
Naeem,
I’m trying to determine what might have happened with the shipping form error you received.
The debug information in below. It shows that no values were transferred to the database.
Can you tell me what you did?
Like, you selected your form, hit submit.
Or, you selected your form, made some changes, hit submit.
Etc.
Thanks for the help.
Valerie
From: Matthew Menia <menia at jlab.org>
Sent: Thursday, July 6, 2023 11:30 AM
To: pansophy <pansophy at jlab.org>; Valerie Bookwalter <bookwalt at jlab.org>
Subject: FW: Error: Event handler exception.
From: adapps at jlab.org<mailto:adapps at jlab.org> <adapps at jlab.org<mailto:adapps at jlab.org>>
Sent: Thursday, July 6, 2023 8:18 AM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>; Megan McDonald <megan at jlab.org<mailto:megan at jlab.org>>; Mike Dickey <mdickey at jlab.org<mailto:mdickey at jlab.org>>; Allen Samuels <samuels at jlab.org<mailto:samuels at jlab.org>>; Matthew Menia <menia at jlab.org<mailto:menia at jlab.org>>
Subject: Error: Event handler exception.
An error occurred: HUQUE
http://pansophy.jlab.org/pansophy/Facilities/SRFOPS_ShippingFormProcess.cfm?
Time: 7/6/23 8:18 AM
Error - struct
Cause
Error - struct
Cause
Error - struct
ErrorCode
1840
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3390) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.oraclebase.go.execute(BaseStatement.java:4425) 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 cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134) at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.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:4329) at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) 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:551) 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:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 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:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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
183
RAW_TRACE
at cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFINVOKE
LINE
134
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
1
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc
TYPE
CFML
Type
java.sql.SQLException
DataSource
FACILITY
Detail
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format
ErrorCode
HY000
Exceptions
Error - array
1
Error - struct
class
java.sql.SQLException
message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format
Message
Error Executing Database Query.
NativeErrorCode
1840
RootCause
Error - struct
ErrorCode
1840
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3390) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.oraclebase.go.execute(BaseStatement.java:4425) 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 cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134) at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.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:4329) at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) 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:551) 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:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 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:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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
183
RAW_TRACE
at cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFINVOKE
LINE
134
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
1
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc
TYPE
CFML
Type
java.sql.SQLException
SQLState
HY000
Sql
INSERT INTO adapps.SRFOPS_SHIPPINGFORM ( FORMSEQNUM, FORMDATE, REQUESTOR, PROJECT, PROJECTCOMMENT, DESCRIPTION, COMPONENT, COMPSN, COMPONENTTYPE, COMPONENTSN, AUTHNUMBER, RTVNUMBER, NCRNUMBER, SHIPPINGNOTES, SHIPPINGDOC, EMAILNAMES, OTHERNOTES, PREPARATIONNOTES, RECIPIENT, MOD_DATE, MOD_USER) VALUES ( '', TO_DATE(' ','DD-FMMonth-FMYYYY HH24:MI'), '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', sysdate, 'HUQUE')
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 cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134) at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.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:4329) at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) 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:551) 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:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 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:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3390) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.oraclebase.go.execute(BaseStatement.java:4425) 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) ... 74 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
183
RAW_TRACE
at cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFINVOKE
LINE
134
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
1
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc
TYPE
CFML
Type
Database
queryError
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format
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
1840
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3390) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.oraclebase.go.execute(BaseStatement.java:4425) 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 cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134) at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.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:4329) at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) 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:551) 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:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 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:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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
183
RAW_TRACE
at cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFINVOKE
LINE
134
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
1
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc
TYPE
CFML
Type
java.sql.SQLException
DataSource
FACILITY
Detail
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format
ErrorCode
HY000
Exceptions
Error - array
1
Error - struct
class
java.sql.SQLException
message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format
Message
Error Executing Database Query.
NativeErrorCode
1840
RootCause
Error - struct
ErrorCode
1840
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3390) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.oraclebase.go.execute(BaseStatement.java:4425) 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 cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134) at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.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:4329) at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) 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:551) 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:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 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:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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
183
RAW_TRACE
at cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFINVOKE
LINE
134
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
1
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc
TYPE
CFML
Type
java.sql.SQLException
SQLState
HY000
Sql
INSERT INTO adapps.SRFOPS_SHIPPINGFORM ( FORMSEQNUM, FORMDATE, REQUESTOR, PROJECT, PROJECTCOMMENT, DESCRIPTION, COMPONENT, COMPSN, COMPONENTTYPE, COMPONENTSN, AUTHNUMBER, RTVNUMBER, NCRNUMBER, SHIPPINGNOTES, SHIPPINGDOC, EMAILNAMES, OTHERNOTES, PREPARATIONNOTES, RECIPIENT, MOD_DATE, MOD_USER) VALUES ( '', TO_DATE(' ','DD-FMMonth-FMYYYY HH24:MI'), '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', sysdate, 'HUQUE')
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 cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134) at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.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:4329) at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) 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:551) 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:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 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:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3390) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.oraclebase.go.execute(BaseStatement.java:4425) 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) ... 74 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
183
RAW_TRACE
at cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFINVOKE
LINE
134
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
1
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc
TYPE
CFML
Type
Database
queryError
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format
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:551) 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:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 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:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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 cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134) at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.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:4329) at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) 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.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01840: input value not long enough for date format at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456) at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3390) at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467) at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.oraclebase.go.execute(BaseStatement.java:4425) 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) ... 74 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
183
RAW_TRACE
at cfShippingForm2ecfc1637808283$funcFNDUPPROW.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc:183)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Components/Facilities/ShippingForm.cfc
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFINVOKE
LINE
134
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:134)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
1
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:1)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc
TYPE
CFML
Type
Database
name
onRequest
Form - struct
AUTHNUMBER
https://misportal.jlab.org/railsForms/shipping_authorizations/158030/edit
CLOSEDATE
[empty string]
CLOSENAME
HUQUE
COMPONENT
HHOMSN
COMPONENTSN
[empty string]
COMPONENTTYPE
[empty string]
COMPSN
HCACFHC004-UP000001,HCACFHC004-UP000002,HCACFHC004-UP000003
DESCRIPTION
HHOM Damper assemblies
FIELDNAMES
PROJSCOPEVAL,FORMSEQNUM,FORMDATE,REQUESTOR,PROJECT,PROJECTCOMMENT,DESCRIPTION,AUTHNUMBER,RTVNUMBER,NCRNUMBER,COMPONENT,COMPSN,COMPSN,COMPSN,COMPONENTTYPE,COMPONENTSN,PREPARATIONNOTES,SHIPPINGNOTES,OTHERNOTES,RECIPIENT,SHIPPINGDOC,CLOSEDATE,CLOSENAME,SUBBTN
FORMDATE
[empty string]
FORMSEQNUM
0
NCRNUMBER
N/A
OTHERNOTES
N/A
PREPARATIONNOTES
Protect knife edges while handling
PROJECT
AUPPS
PROJECTCOMMENT
[empty string]
PROJSCOPEVAL
[empty string]
RECIPIENT
Caleb Conn - (937) 298-9390
REQUESTOR
HUQUE
RTVNUMBER
N/A
SHIPPINGDOC
[empty string]
SHIPPINGNOTES
N/A
SUBBTN
SUBMIT_TO_EMAIL
URL - struct
area
C75
project
C75
system
[empty string]
title
FACILITIES
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20230706/5b129532/attachment-0001.html>
More information about the Pansophy
mailing list