[Pansophy] FW: Error: Event handler exception.

Fri Jul 21 12:37:34 EDT 2023

The error on your shipping form is this:

"."COMPONENTTYPE" (actual: 72, maximum: 64)

What is your Component Type?

Valerie

From: adapps at jlab.org <adapps at jlab.org>
Sent: Friday, July 21, 2023 11:30 AM
To: Valerie Bookwalter <bookwalt at jlab.org>; Megan McDonald <megan at jlab.org>; Mike Dickey <mdickey at jlab.org>; Allen Samuels <samuels at jlab.org>; Matthew Menia <menia at jlab.org>
Subject: Error: Event handler exception.

An error occurred: HUQUE
http://pansophy.jlab.org/pansophy/Facilities/SRFOPS_ShippingFormProcess.cfm?
Time: 7/21/23 11:30 AM
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: 72, 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: 72, 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: 72, maximum: 64)
TEMPLATE
actual: 72, 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: 72, 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: 72, 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: 72, 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: 72, 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: 72, maximum: 64)
TEMPLATE
actual: 72, 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 ('55', sysdate, 'HUQUE', 'AUPPS', '', '316LN blanks to be taken the the machine shop, to be picked up by the vendor', 'OTHER', '', 'OD 100mm x 15mm LG 316LN Rods (X10), OD 160mm x 26mm LG 316LN Rods (X10)', 'N/A', 'https://misportal.jlab.org/railsForms/shipping_authorizations/158966/edit', 'N/A', 'N/A', 'N/A', '', '', 'Use two separate boxes, one for each size. Label the boxes with the rod size', 'N/A', 'Adam Panholzer - 7578651234', 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 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: 72, 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: 72, maximum: 64)
TEMPLATE
actual: 72, maximum
TYPE
CFML
Type
Database
queryError
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 72, 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: 72, 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: 72, 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: 72, maximum: 64)
TEMPLATE
actual: 72, 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: 72, 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: 72, 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: 72, 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: 72, 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: 72, maximum: 64)
TEMPLATE
actual: 72, 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 ('55', sysdate, 'HUQUE', 'AUPPS', '', '316LN blanks to be taken the the machine shop, to be picked up by the vendor', 'OTHER', '', 'OD 100mm x 15mm LG 316LN Rods (X10), OD 160mm x 26mm LG 316LN Rods (X10)', 'N/A', 'https://misportal.jlab.org/railsForms/shipping_authorizations/158966/edit', 'N/A', 'N/A', 'N/A', '', '', 'Use two separate boxes, one for each size. Label the boxes with the rod size', 'N/A', 'Adam Panholzer - 7578651234', 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 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: 72, 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: 72, maximum: 64)
TEMPLATE
actual: 72, maximum
TYPE
CFML
Type
Database
queryError
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "ADAPPS"."SRFOPS_SHIPPINGFORM"."COMPONENTTYPE" (actual: 72, 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: 72, 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: 72, maximum: 64)
TEMPLATE
actual: 72, maximum
TYPE
CFML
Type
Database
name
onRequest

Form - struct
AUTHNUMBER
https://misportal.jlab.org/railsForms/shipping_authorizations/158966/edit
CLOSEDATE
[empty string]
CLOSENAME
HUQUE
COMPONENT
OTHER
COMPONENTSN
N/A
COMPONENTTYPE
OD 100mm x 15mm LG 316LN Rods (X10), OD 160mm x 26mm LG 316LN Rods (X10)
DESCRIPTION
316LN blanks to be taken the the machine shop, to be picked up by the vendor
FIELDNAMES
PROJSCOPEVAL,FORMSEQNUM,FORMDATE,REQUESTOR,PROJECT,PROJECTCOMMENT,DESCRIPTION,AUTHNUMBER,RTVNUMBER,NCRNUMBER,COMPONENT,COMPONENTTYPE,COMPONENTSN,PREPARATIONNOTES,SHIPPINGNOTES,OTHERNOTES,RECIPIENT,SHIPPINGDOC,CLOSEDATE,CLOSENAME,NEWBTN
FORMDATE
[empty string]
FORMSEQNUM
0
NCRNUMBER
N/A
NEWBTN
NEW_FORM
OTHERNOTES
Use two separate boxes, one for each size. Label the boxes with the rod size
PREPARATIONNOTES
N/A
PROJECT
AUPPS
PROJECTCOMMENT
[empty string]
PROJSCOPEVAL
[empty string]
RECIPIENT
Adam Panholzer - 7578651234
REQUESTOR
HUQUE
RTVNUMBER
N/A
SHIPPINGDOC
[empty string]
SHIPPINGNOTES
N/A

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/20230721/619849eb/attachment-0001.html>