Layer7 API Management

  • 1.  Error while importing code into CA API GW 9.2.3

    Posted Jun 23, 2017 04:42 PM

    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)



  • 2.  Re: Error while importing code into CA API GW 9.2.3

    Posted Jun 26, 2017 10:01 AM

    Hello Ray2014 

     

    Thank you for your enquiry.  I can see you are already discussing this problem with a colleague of mine via a support case.  From reviewing the stack trace it could be an audit sink problem, do you have one configured?

     

    Regards

    Christopher Clark

    CA Support 



  • 3.  Re: Error while importing code into CA API GW 9.2.3
    Best Answer

    Posted Jun 26, 2017 10:04 AM

    Christopher,

    Correct, We had to disable Audit Sync to get beyond MySql problem for now. 



  • 4.  Re: Error while importing code into CA API GW 9.2.3

    Posted Jun 26, 2017 10:39 AM

    Hello Ray2014

     

    When you do the webex with Charles get the audit sink policy reviewed.  I suspect audits are storing the request and this GMU payload is too large for the database field size, but without reviewing it I can't confirm.    I've highlighted this thread on the case notes so the resolution can be documented. 

     

    Chris