Customer Portal

New connection to DB2 DV

Comments 2

  • Avatar
    mayamit
    0
    Comment actions Permalink

    Hello,

    I just created a new connection, trying to connect to DB2 server. I downloaded the appropriate driver from IBM and while trying to "Validate the connection", I get:
    "Cannot connect to server at http://localhost:59311/clover
    Connection to CloverDX Server failed
    Read timed out"

    Stack trace as follows:
    "ERROR: ''
    May 13, 2019 6:44:05 PM com.sun.xml.ws.transport.http.servlet.WSServletDelegate doGet
    SEVERE: caught throwable
    javax.xml.ws.WebServiceException: javax.xml.bind.MarshalException
    - with linked exception:
    [com.sun.istack.SAXException2: com.sun.istack.SAXException2
    org.eclipse.jetty.io.EofException
    javax.xml.transform.TransformerException: com.sun.istack.SAXException2
    org.eclipse.jetty.io.EofException]
    at com.sun.xml.ws.message.jaxb.JAXBMessage.writePayloadTo(JAXBMessage.java:424)
    at com.sun.xml.ws.message.AbstractMessageImpl.writeTo(AbstractMessageImpl.java:192)
    at com.sun.xml.ws.api.message.FilterMessageImpl.writeTo(FilterMessageImpl.java:168)
    at com.sun.xml.ws.api.message.MessageWrapper.writeTo(MessageWrapper.java:226)
    at com.sun.xml.ws.encoding.MtomCodec.encode(MtomCodec.java:188)
    at com.sun.xml.ws.encoding.SOAPBindingCodec.encode(SOAPBindingCodec.java:242)
    at com.sun.xml.ws.transport.http.HttpAdapter.encodePacket(HttpAdapter.java:636)
    at com.sun.xml.ws.transport.http.HttpAdapter.access$100(HttpAdapter.java:108)
    at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:878)
    at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:422)
    at com.sun.xml.ws.transport.http.servlet.ServletAdapter.invokeAsync(ServletAdapter.java:225)
    at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doGet(WSServletDelegate.java:161)
    at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doPost(WSServletDelegate.java:197)
    at com.sun.xml.ws.transport.http.servlet.WSServlet.doPost(WSServlet.java:81)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
    at com.cloveretl.server.filter.GzipInputFilter.doFilter(Main:143)
    at com.cloveretl.server.worker.commons.filter.HttpFilterBase.doFilter(Main:41)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at com.cloveretl.server.filter.GzipOutputFilter.doFilter(Main:764)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at com.cloveretl.server.filter.AuthenticationFilter.doFilter(Main:61)
    at com.cloveretl.server.worker.commons.filter.HttpFilterBase.doFilter(Main:41)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at com.cloveretl.server.filter.InitCheckFilter.doFilter(Main:54)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at com.cloveretl.server.filter.ClientTrackingFilter.doFilter(Main:47)
    at com.cloveretl.server.worker.commons.filter.HttpFilterBase.doFilter(Main:41)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1340)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1242)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
    at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:61)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
    at org.eclipse.jetty.server.Server.handle(Server.java:503)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
    at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
    at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
    at java.lang.Thread.run(Thread.java:745)
    Caused by: javax.xml.bind.MarshalException
    - with linked exception:
    [com.sun.istack.SAXException2: com.sun.istack.SAXException2
    org.eclipse.jetty.io.EofException
    javax.xml.transform.TransformerException: com.sun.istack.SAXException2
    org.eclipse.jetty.io.EofException]
    at com.sun.xml.bind.v2.runtime.MarshallerImpl.write(MarshallerImpl.java:331)
    at com.sun.xml.bind.v2.runtime.MarshallerImpl.marshal(MarshallerImpl.java:178)
    at com.sun.xml.ws.db.glassfish.MarshallerBridge.marshal(MarshallerBridge.java:86)
    at com.sun.xml.bind.api.Bridge.marshal(Bridge.java:145)
    at com.sun.xml.ws.message.jaxb.JAXBMessage.writePayloadTo(JAXBMessage.java:415)
    ... 63 more
    Caused by: com.sun.istack.SAXException2: com.sun.istack.SAXException2
    org.eclipse.jetty.io.EofException
    javax.xml.transform.TransformerException: com.sun.istack.SAXException2
    org.eclipse.jetty.io.EofException
    at com.sun.xml.bind.v2.runtime.XMLSerializer.reportError(XMLSerializer.java:247)
    at com.sun.xml.bind.v2.runtime.XMLSerializer.reportError(XMLSerializer.java:262)
    at com.sun.xml.bind.v2.runtime.XMLSerializer.writeDom(XMLSerializer.java:807)
    at com.sun.xml.bind.v2.runtime.property.ArrayReferenceNodeProperty.serializeListBody(ArrayReferenceNodeProperty.java:116)
    at com.sun.xml.bind.v2.runtime.property.ArrayERProperty.serializeBody(ArrayERProperty.java:159)
    at com.sun.xml.bind.v2.runtime.ClassBeanInfoImpl.serializeBody(ClassBeanInfoImpl.java:360)
    at com.sun.xml.bind.v2.runtime.XMLSerializer.childAsXsiType(XMLSerializer.java:696)
    at com.sun.xml.bind.v2.runtime.property.SingleElementNodeProperty.serializeBody(SingleElementNodeProperty.java:158)
    at com.sun.xml.bind.v2.runtime.ClassBeanInfoImpl.serializeBody(ClassBeanInfoImpl.java:360)
    at com.sun.xml.bind.v2.runtime.XMLSerializer.childAsSoleContent(XMLSerializer.java:593)
    at com.sun.xml.bind.v2.runtime.ClassBeanInfoImpl.serializeRoot(ClassBeanInfoImpl.java:341)
    at com.sun.xml.bind.v2.runtime.XMLSerializer.childAsRoot(XMLSerializer.java:494)
    at com.sun.xml.bind.v2.runtime.MarshallerImpl.write(MarshallerImpl.java:328)
    ... 67 more
    Caused by: javax.xml.transform.TransformerException: com.sun.istack.SAXException2
    org.eclipse.jetty.io.EofException
    at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:749)
    at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:351)
    at com.sun.xml.bind.v2.runtime.XMLSerializer.writeDom(XMLSerializer.java:805)
    ... 77 more
    Caused by: com.sun.istack.SAXException2
    org.eclipse.jetty.io.EofException
    at com.sun.xml.bind.v2.runtime.XMLSerializer.attribute(XMLSerializer.java:437)
    at com.sun.xml.bind.v2.runtime.ContentHandlerAdaptor.startElement(ContentHandlerAdaptor.java:134)
    at com.sun.org.apache.xml.internal.serializer.ToXMLSAXHandler.closeStartTag(ToXMLSAXHandler.java:208)
    at com.sun.org.apache.xml.internal.serializer.ToSAXHandler.flushPending(ToSAXHandler.java:281)
    at com.sun.org.apache.xml.internal.serializer.ToXMLSAXHandler.endElement(ToXMLSAXHandler.java:247)
    at com.sun.org.apache.xml.internal.serializer.ToXMLSAXHandler.endElement(ToXMLSAXHandler.java:559)
    at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:235)
    at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:230)
    at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:230)
    at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:230)
    at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:230)
    at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:94)
    at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transformIdentity(TransformerImpl.java:693)
    at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:737)
    ... 79 more
    Caused by: org.eclipse.jetty.io.EofException
    at org.eclipse.jetty.io.ChannelEndPoint.flush(ChannelEndPoint.java:286)
    at org.eclipse.jetty.io.WriteFlusher.flush(WriteFlusher.java:393)
    at org.eclipse.jetty.io.WriteFlusher.write(WriteFlusher.java:277)
    at org.eclipse.jetty.io.AbstractEndPoint.write(AbstractEndPoint.java:380)
    at org.eclipse.jetty.server.HttpConnection$SendCallback.process(HttpConnection.java:808)
    at org.eclipse.jetty.util.IteratingCallback.processing(IteratingCallback.java:241)
    at org.eclipse.jetty.util.IteratingCallback.iterate(IteratingCallback.java:224)
    at org.eclipse.jetty.server.HttpConnection.send(HttpConnection.java:538)
    at org.eclipse.jetty.server.HttpChannel.sendResponse(HttpChannel.java:836)
    at org.eclipse.jetty.server.HttpChannel.write(HttpChannel.java:887)
    at org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:239)
    at org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:215)
    at org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:514)
    at com.sun.xml.ws.transport.http.servlet.ServletConnectionImpl$1.write(ServletConnectionImpl.java:243)
    at com.sun.xml.bind.v2.runtime.output.UTF8XmlOutput.write(UTF8XmlOutput.java:411)
    at com.sun.xml.bind.v2.runtime.output.Encoded.write(Encoded.java:167)
    at com.sun.xml.bind.v2.runtime.output.UTF8XmlOutput.attribute(UTF8XmlOutput.java:266)
    at com.sun.xml.bind.v2.runtime.output.MTOMXmlOutput.attribute(MTOMXmlOutput.java:101)
    at com.sun.xml.bind.v2.runtime.XMLSerializer.attribute(XMLSerializer.java:435)
    ... 92 more
    Caused by: java.io.IOException: Broken pipe
    at sun.nio.ch.FileDispatcherImpl.writev0(Native Method)
    at sun.nio.ch.SocketDispatcher.writev(SocketDispatcher.java:51)
    at sun.nio.ch.IOUtil.write(IOUtil.java:148)
    at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:504)
    at org.eclipse.jetty.io.ChannelEndPoint.flush(ChannelEndPoint.java:266)
    ... 110 more
    "

    What could be the error?

    "mayamit"
  • Avatar
    Vladimir Barton
    0
    Comment actions Permalink
    Hello Mayamit,
    the error message indicates that the connection failed due to a read timeout. You can try increasing the Request timeout and Connect timeout in the CloverDX Designer by navigating to Window > Preferences > CloverDX > CloverDX Server Integration. The default value is 30 seconds for both timeouts so try increasing them to 300. If this does not help we would have to dig a little bit deeper into your use case so kindly provide me with additional information:

    • What is the version of CloverDX Designer that you are using?

    • Do you take advantage of the JDK that is bundled with the Designer or do you use a custom one? If the latter is the case, please provide me with the vendor and version of Java.

    • Could you provide me with more details about the driver that you downloaded? For instance, name, version, where you downloaded it from, etc.

    • Are you able to connect to the DB2 instance by using a 3rd party DB client, for example, Toad, DBeaver, etc. by using the very same driver?

    • Just so that we are both on the same page, you got the error message by clicking on the 'Validate connection' button in the DB connection configuration in the Designer. Is that correct? Is this a local project that we are dealing with (as opposed to CloverDX Server project)?

    • Try disabling your firewall and retry the connection validation. Is the result the same?

    Kind regards,

Please sign in to leave a comment.