[Pansophy] FW: Error: Event handler exception.

Fri Jul 1 14:37:20 EDT 2022

Your ComponentType is too long. What are you entering?
What Project is selected?

Valerie

From: adapps at jlab.org <adapps at jlab.org>
Sent: Friday, July 1, 2022 2:36 PM
To: Valerie Bookwalter <bookwalt at jlab.org>; Megan McDonald <megan at jlab.org>; Mike Dickey <mdickey at jlab.org>; David Parham <dparham at jlab.org>; Allen Samuels <samuels at jlab.org>
Subject: Error: Event handler exception.

An error occurred: DHAKAL
http://pansophy.jlab.org/pansophy/Facilities/SRFOPS_ShippingFormProcess.cfm?
Time: 7/1/22 2:36 PM
Error - struct
Cause
Error - struct
Cause
Error - struct
ErrorCode
12899
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64) 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 cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11) 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
LINE
-1
RAW_TRACE
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
TEMPLATE
actual: 73, maximum
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFQUERY
LINE
52
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
12
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
11
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
5
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
6
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-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
ErrorCode
HY000
Exceptions
Error - array
1
Error - struct
class
java.sql.SQLException
message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
Message
Error Executing Database Query.
NativeErrorCode
12899
RootCause
Error - struct
ErrorCode
12899
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64) 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 cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11) 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
LINE
-1
RAW_TRACE
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
TEMPLATE
actual: 73, maximum
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFQUERY
LINE
52
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
12
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
11
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
5
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
6
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 ('12', sysdate, 'DHAKAL', 'SNSPPU', '', 'PPU cavity hardware assembly as received from vendor PPU cavity shipping box', 'OTHER', '', 'Cavity assembly hardware, The quantity are attached. Non inventory items ', '', 'N/A', 'N/A', 'N/A', 'Cavity shipment box need to be picked up from blue Crab', 'SNS PPU PIC.xlsx', 'HUQUE', 'N/A', 'Parts removed from cavity and packaged in a box all together (1 box) 6 cavity sipping box (orange color)', 'John Mammosser Oak Ridge National Laboratory, 9500 Spallation Drive SNS Site, Building 8600 Oak Ridge, TN 37830-6460 Ph: 757.334.4810 ', sysdate, 'DHAKAL')
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 cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11) 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-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64) 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) ... 63 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
52
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
12
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
11
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
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
5
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
6
Error - struct
COLUMN
0
ID
CF_THREAD
LINE
-1
RAW_TRACE
Caused by: java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
TEMPLATE
actual: 73, maximum
TYPE
CFML
Type
Database
queryError
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
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
12899
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64) 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 cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11) 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
LINE
-1
RAW_TRACE
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
TEMPLATE
actual: 73, maximum
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFQUERY
LINE
52
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
12
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
11
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
5
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
6
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-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
ErrorCode
HY000
Exceptions
Error - array
1
Error - struct
class
java.sql.SQLException
message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
Message
Error Executing Database Query.
NativeErrorCode
12899
RootCause
Error - struct
ErrorCode
12899
Message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
SQLState
HY000
StackTrace
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64) 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 cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11) 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
LINE
-1
RAW_TRACE
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
TEMPLATE
actual: 73, maximum
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFQUERY
LINE
52
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
12
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
11
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
5
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
6
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 ('12', sysdate, 'DHAKAL', 'SNSPPU', '', 'PPU cavity hardware assembly as received from vendor PPU cavity shipping box', 'OTHER', '', 'Cavity assembly hardware, The quantity are attached. Non inventory items ', '', 'N/A', 'N/A', 'N/A', 'Cavity shipment box need to be picked up from blue Crab', 'SNS PPU PIC.xlsx', 'HUQUE', 'N/A', 'Parts removed from cavity and packaged in a box all together (1 box) 6 cavity sipping box (orange color)', 'John Mammosser Oak Ridge National Laboratory, 9500 Spallation Drive SNS Site, Building 8600 Oak Ridge, TN 37830-6460 Ph: 757.334.4810 ', sysdate, 'DHAKAL')
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 cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11) 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-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64) 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) ... 63 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
52
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
12
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
11
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
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
5
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
6
Error - struct
COLUMN
0
ID
CF_THREAD
LINE
-1
RAW_TRACE
Caused by: java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
TEMPLATE
actual: 73, maximum
TYPE
CFML
Type
Database
queryError
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
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 cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12) at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11) 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-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64) 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) ... 63 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CFQUERY
LINE
52
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor1(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:52)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
12
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor2(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:12)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CF_SRFOPS_SHIPPINGFORMPROCESS
LINE
11
RAW_TRACE
at cfSRFOPS_ShippingFormProcess2ecfm1596282899._factor8(/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm:11)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Facilities/SRFOPS_ShippingFormProcess.cfm
TYPE
CFML
4
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
5
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
6
Error - struct
COLUMN
0
ID
??
LINE
-1
RAW_TRACE
Caused by: java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 73, maximum: 64)
TEMPLATE
actual: 73, maximum
TYPE
CFML
Type
Database
name
onRequest

Form - struct
AUTHNUMBER
N/A
CLOSEDATE
[empty string]
CLOSENAME
DHAKAL
COMPONENT
OTHER
COMPONENTSN
[empty string]
COMPONENTTYPE
Cavity assembly hardware, The quantity are attached. Non inventory items
DESCRIPTION
PPU cavity hardware assembly as received from vendor PPU cavity shipping box
EMAILNAMES
HUQUE
FIELDNAMES
PROJSCOPEVAL,FORMSEQNUM,FORMDATE,REQUESTOR,PROJECT,PROJECTCOMMENT,DESCRIPTION,AUTHNUMBER,RTVNUMBER,NCRNUMBER,COMPONENT,COMPONENTTYPE,COMPONENTSN,PREPARATIONNOTES,SHIPPINGNOTES,OTHERNOTES,RECIPIENT,EMAILNAMES,SHIPPINGDOC,CLOSEDATE,CLOSENAME,NEWBTN
FORMDATE
[empty string]
FORMSEQNUM
0
NCRNUMBER
N/A
NEWBTN
NEW_FORM
OTHERNOTES
N/A
PREPARATIONNOTES
Parts removed from cavity and packaged in a box all together (1 box) 6 cavity sipping box (orange color)
PROJECT
SNSPPU
PROJECTCOMMENT
[empty string]
PROJSCOPEVAL
[empty string]
RECIPIENT
John Mammosser Oak Ridge National Laboratory, 9500 Spallation Drive SNS Site, Building 8600 Oak Ridge, TN 37830-6460 Ph: 757.334.4810
REQUESTOR
DHAKAL
RTVNUMBER
N/A
SHIPPINGDOC
SNS PPU PIC.xlsx
SHIPPINGNOTES
Cavity shipment box need to be picked up from blue Crab

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/20220701/55fc9a4f/attachment-0001.html>