org.jboss.resteasy.spi.UnhandledException: org.artificer.ui.client.shared.exceptions.ArtificerUiException: [jcc][t4][1092][11644][4.15.113] Conversión de datos no válida: Tipo incorrecto de la columna de resultados para la conversión solicitada. ERRORCODE=-4461, SQLSTATE=42815

  1. 0

    DB2 ERRORCODE=-4461, SQLSTATE=42815 clob field

    Stack Overflow | 1 year ago | user3560604
    org.jboss.resteasy.spi.UnhandledException: org.artificer.ui.client.shared.exceptions.ArtificerUiException: [jcc][t4][1092][11644][4.15.113] Conversión de datos no válida: Tipo incorrecto de la columna de resultados para la conversión solicitada. ERRORCODE=-4461, SQLSTATE=42815

    Root Cause Analysis

    1. org.artificer.ui.client.shared.exceptions.ArtificerUiException

      [jcc][t4][1092][11644][4.15.113] Conversión de datos no válida: Tipo incorrecto de la columna de resultados para la conversión solicitada. ERRORCODE=-4461, SQLSTATE=42815

      at org.artificer.ui.server.services.ArtifactSearchService.search()
    2. org.artificer.ui
      ArtifactSearchService$Proxy$_$$_WeldClientProxy.search
      1. org.artificer.ui.server.services.ArtifactSearchService.search(ArtifactSearchService.java:110)[classes:]
      2. org.artificer.ui.server.services.ArtifactSearchService$Proxy$_$$_WeldClientProxy.search(ArtifactSearchService$Proxy$_$$_WeldClientProxy.java)[classes:]
      2 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[rt.jar:1.7.0_55]
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[rt.jar:1.7.0_55]
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[rt.jar:1.7.0_55]
      4. java.lang.reflect.Method.invoke(Method.java:606)[rt.jar:1.7.0_55]
      4 frames
    4. RESTEasy JAX-RS Implementation
      HttpServletDispatcher.service
      1. org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      2. org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      3. org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      4. org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      5. org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:541)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      6. org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:523)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      7. org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:125)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      8. org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      9. org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      10. org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      10 frames
    5. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:847)[jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]
      1 frame
    6. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2 frames
    7. org.overlord.commons
      BusAuthenticationFilter.doFilter
      1. org.overlord.commons.gwt.server.filters.BusAuthenticationFilter.doFilter(BusAuthenticationFilter.java:61)[overlord-commons-gwt-2.0.17.Final.jar:2.0.17.Final]
      1 frame
    8. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2 frames
    9. org.overlord.commons
      HttpRequestThreadLocalFilter.doFilter
      1. org.overlord.commons.auth.filters.HttpRequestThreadLocalFilter.doFilter(HttpRequestThreadLocalFilter.java:58)[overlord-commons-auth-2.0.17.Final.jar:2.0.17.Final]
      1 frame
    10. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2 frames
    11. org.overlord.commons
      PostAuthenticationRedirectFilter.doFilter
      1. org.overlord.commons.gwt.server.filters.PostAuthenticationRedirectFilter.doFilter(PostAuthenticationRedirectFilter.java:48)[overlord-commons-gwt-2.0.17.Final.jar:2.0.17.Final]
      1 frame
    12. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2 frames
    13. org.overlord.commons
      PicketLinkAuthWrapperFilter.doFilter
      1. org.overlord.commons.auth.filters.PicketLinkAuthWrapperFilter.doFilter(PicketLinkAuthWrapperFilter.java:73)[overlord-commons-auth-2.0.17.Final.jar:2.0.17.Final]
      1 frame
    14. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2 frames
    15. org.artificer.ui
      LocaleFilter.doFilter
      1. org.artificer.ui.server.filters.LocaleFilter.doFilter(LocaleFilter.java:65)[classes:]
      1 frame
    16. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2 frames
    17. org.overlord.commons
      GWTCacheControlFilter.doFilter
      1. org.overlord.commons.gwt.server.filters.GWTCacheControlFilter.doFilter(GWTCacheControlFilter.java:76)[overlord-commons-gwt-2.0.17.Final.jar:2.0.17.Final]
      1 frame
    18. Glassfish Core
      StandardContextValve.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      4 frames
    19. JBoss Web
      SecurityContextAssociationValve.invoke
      1. org.jboss.as.web.session.ClusteredSessionValve.handleRequest(ClusteredSessionValve.java:134)[jboss-as-web-7.5.0.Final-redhat-17.jar:7.5.0.Final-redhat-17]
      2. org.jboss.as.web.session.ClusteredSessionValve.invoke(ClusteredSessionValve.java:99)[jboss-as-web-7.5.0.Final-redhat-17.jar:7.5.0.Final-redhat-17]
      3. org.jboss.as.web.session.JvmRouteValve.invoke(JvmRouteValve.java:92)[jboss-as-web-7.5.0.Final-redhat-17.jar:7.5.0.Final-redhat-17]
      4. org.jboss.as.web.session.LockingValve.invoke(LockingValve.java:64)[jboss-as-web-7.5.0.Final-redhat-17.jar:7.5.0.Final-redhat-17]
      5. org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)[jboss-as-web-7.5.0.Final-redhat-17.jar:7.5.0.Final-redhat-17]
      5 frames
    20. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      3. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      4. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      4 frames
    21. Grizzly HTTP
      JIoEndpoint$Worker.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      3 frames
    22. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:744)[rt.jar:1.7.0_55]
      1 frame