AnsweredAssumed Answered

Error while importing code into CA API GW 9.2.3

Question asked by Ray2014 on Jun 23, 2017
Latest reply on Jun 26, 2017 by ChristopherClark

Hi, Anyone seeing issue while migrating code from source GW into a new 9.2.3 GW using GMU? 

 

Here is the error...

2017-06-23T01:42:11.377-0400 WARNING 428 org.hibernate.util.JDBCExceptionReporter: SQL Error: 1406, SQLState: 22001

2017-06-23T01:42:11.377-0400 SEVERE  428 org.hibernate.util.JDBCExceptionReporter: Data truncation: Data too long for column 'value' at row 1

2017-06-23T01:42:11.381-0400 SEVERE  428 org.apache.catalina.core.ContainerBase.[ssg].[dcmidvmgcc013].[/].[SoapMessageProcessingServlet]: Servlet.service() for servlet SoapMessageProcessingServlet threw exception

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'value' at row 1

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4094)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)

        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2444)

        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1997)

        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1468)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:188)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)

        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)

        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)

        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)

        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:656)

        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)

        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)

        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)

        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

        at com.sun.proxy.$Proxy174.save(Unknown Source)

        at com.l7tech.server.audit.AuditContextImpl.a(Unknown Source)

        at com.l7tech.server.audit.AuditContextImpl.a(Unknown Source)

        at com.l7tech.server.audit.AuditContextFactory.doWithNewAuditContext(Unknown Source)

        at com.l7tech.server.SoapMessageProcessingServlet.service(Unknown Source)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)

        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)

        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:342)

        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)

        at com.l7tech.server.transport.http.HttpNamespaceFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at com.l7tech.server.WsdlFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at com.l7tech.server.transport.http.ConnectionIdFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at com.l7tech.server.transport.http.InputTimeoutFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at com.l7tech.server.log.HybridDiagnosticContextServletFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:181)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

        at com.l7tech.server.tomcat.ResponseKillerValve.invoke(Unknown Source)

        at com.l7tech.server.tomcat.ConnectionIdValve.invoke(Unknown Source)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:295)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)

        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:396)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at java.lang.Thread.run(Thread.java:745)

2017-06-23T01:42:11.382-0400 SEVERE  428 org.apache.catalina.core.ContainerBase.[ssg].[dcmidvmgcc013].[/].[default]: Servlet.service() for servlet default threw exception

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'value' at row 1

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4094)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)

        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2444)

        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1997)

        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1468)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:188)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)

        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)

        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)

        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)

        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:656)

        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)

        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)

        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)

        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

        at com.sun.proxy.$Proxy174.save(Unknown Source)

        at com.l7tech.server.audit.AuditContextImpl.a(Unknown Source)

        at com.l7tech.server.audit.AuditContextImpl.a(Unknown Source)

        at com.l7tech.server.audit.AuditContextFactory.doWithNewAuditContext(Unknown Source)

        at com.l7tech.server.SoapMessageProcessingServlet.service(Unknown Source)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)

        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)

        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:342)

        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)

        at com.l7tech.server.transport.http.HttpNamespaceFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at com.l7tech.server.WsdlFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at com.l7tech.server.transport.http.ConnectionIdFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at com.l7tech.server.transport.http.InputTimeoutFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at com.l7tech.server.log.HybridDiagnosticContextServletFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:181)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

        at com.l7tech.server.tomcat.ResponseKillerValve.invoke(Unknown Source)

        at com.l7tech.server.tomcat.ConnectionIdValve.invoke(Unknown Source)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:295)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)

        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:396)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at java.lang.Thread.run(Thread.java:745)

2017-06-23T01:42:13.661-0400 INFO    37 com.l7tech.external.assertions.ratelimit.server.ServerRateLimitAssertion: Removing stale rate limiter PRESET(4cdd6b82d00ea1f5)

Outcomes