1 Reply Latest reply on Oct 14, 2014 3:14 PM by Ramesh Reddy

    TEIID1602 Could not produce a successful OData response

    Greg MacKinnon Newbie

      I get this exception with doing a GET for a resource. This is Teiid 8.7.  Any suggestions would be appreciated.

       

      Thanks and Best Regards,

      Greg

       

       

      ava.lang.Boolean, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.math.BigDecimal, class java.lang.String, class java.lang.Stri

      ng, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.math.BigDecimal, class java

      .lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, clas

      s java.lang.String, class java.lang.Boolean, class java.lang.Boolean, class java.lang.Boolean, class java.lang.Boolean, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.St

      ring, class java.lang.Boolean, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.String] batch size 128 of type PROCESSOR^M

      13 Oct 2014 22:07:28,292 DEBUG [org.teiid.PROCESSOR] (http-/0.0.0.0:8080-1) hDPZOneobLNx Created intermediate sort buffer 18022^M

      13 Oct 2014 22:07:28,293 DEBUG [org.teiid.BUFFER_MGR] (http-/0.0.0.0:8080-1) hDPZOneobLNx Removing TupleBuffer: 18021^M

      13 Oct 2014 22:07:28,295 DEBUG [org.teiid.PROCESSOR] (http-/0.0.0.0:8080-1) hDPZOneobLNx hDPZOneobLNx.0 Using cache hint /*+ cache(ttl:300000 scope:USER) */ ^M

      13 Oct 2014 22:07:28,297 DEBUG [org.teiid.PROCESSOR] (http-/0.0.0.0:8080-1) hDPZOneobLNx [RequestWorkItem.sendResultsIfNeeded] requestID: hDPZOneobLNx.0 resultsID: 18022 done: true^M

      13 Oct 2014 22:07:28,298 FINE  [org.teiid.jdbc] (http-/0.0.0.0:8080-1) null Successfully executed a query /*+ cache(ttl:300000 scope:USER) */ SELECT g0.VOLUME, g0.CCUU, g0.DEVTYPE, g0.MODEL, g0.PCTALLO, g0.FRAG

      INDX, g0.EXTENTS, g0.EAV, g0.DEVCAP, g0.CYLSALLO, g0.CYLSFREE, g0.TRKSFREE, g0.LFREXTBY, g0.TRKSACT, g0.CYLSCONT, g0.TRKSCONT, g0.VENDOR, g0.CUTYPE, g0.CUMODEL, g0.TRKCAP, g0.BYTECAP, g0.BYTSUSED, g0.FREBYTES,

      g0.SMSIND, g0.SMSST, g0.SGNAME, g0.MOUNTSTA, g0.MNTSTAT, g0.ONLINE, g0.RESERVES, g0.BOXED, g0.OPENCNT, g0.CACHED, g0.TRKCACH, g0.DUPLEX, g0.FWRITE, g0.DIRFBIT, g0.VTOCSTAT, g0.VIRSFREE, g0.DSCBFREE, g0.DSCBUSED

      , g0.DSCBTOT, g0.DSCBPCT, g0.CCUUX, g0.SHR, g0.TINDEX, g0.TEXTNT, g0.TCYLS, g0.TTRKS, g0.TMCYLS, g0.TMTRKS, g0.TVTRKM, g0.TVTRKS, g0.VOLSER, g0.SSID, g0.SERIAL, g0.ESCON, g0.CFW, g0.DFW, g0.CACHE, g0.MFG, g0.MF

      GTYPE, g0.DEVICE, g0.ECNTL, g0.DCNTL, g0.CYLS, g0.CHPID1, g0.CHPID2, g0.CHPID3, g0.CHPID4, g0.CHPID5, g0.CHPID6, g0.CHPID7, g0.CHPID8, g0.EXCLUDED, g0.RAIDTYPE, g0.REMOTREP, g0.LOGCUNIT, g0.LOGUNIT, g0.MONSID,

      g0.MONSUBS, g0.MONCPU, g0.MONREL, g0.UNIQSYSP, g0.UNIQLPAR, g0.UNIQSUBS, g0.DEFRACT, g0.DEFRDEF, g0.THRSACT, g0.BYPASSED, g0.PHYDV, g0.SUBFM, g0.UCBCX, g0.VOLFLD1, g0.THRSDEF, g0.VOL, g0.CUU, g0.UNIT, g0.CHANI,

      g0.UNIQHASL, g0.UNIQHASG FROM storagevols.VOLUMES AS g0 ORDER BY g0.UNIQHASG and obtained results^M

      13 Oct 2014 22:07:28,301 DEBUG [org.teiid.PROCESSOR] (http-/0.0.0.0:8080-1) hDPZOneobLNx closeQuery for requestID=hDPZOneobLNx.0^M

      13 Oct 2014 22:07:28,302 DEBUG [org.teiid.PROCESSOR] (http-/0.0.0.0:8080-1) hDPZOneobLNx Restarting processing using the calling thread hDPZOneobLNx.0^M

      13 Oct 2014 22:07:28,304 DEBUG [org.teiid.PROCESSOR] (http-/0.0.0.0:8080-1) hDPZOneobLNx Request Thread hDPZOneobLNx.0 with state PROCESSING^M

      13 Oct 2014 22:07:28,305 DEBUG [org.teiid.PROCESSOR] (http-/0.0.0.0:8080-1) hDPZOneobLNx QueryProcessor: closing processor^M

      13 Oct 2014 22:07:28,307 DEBUG [org.teiid.PROCESSOR] (http-/0.0.0.0:8080-1) hDPZOneobLNx Removing tuplesource for the request hDPZOneobLNx.0^M

      13 Oct 2014 22:07:28,308 DEBUG [org.teiid.COMMAND_LOG] (http-/0.0.0.0:8080-1) hDPZOneobLNx      END USER COMMAND:       endTime=2014-10-13 22:07:28.308 requestID=hDPZOneobLNx.0        txID=null       sessionID=

      hDPZOneobLNx  principal=wittgenstein@teiid-security   vdbName=chorusapi       vdbVersion=1    finalRowCount=1^M

      13 Oct 2014 22:07:28,310 FINE  [org.teiid.jdbc] (http-/0.0.0.0:8080-1) null Statement closed successfully.^M

      13 Oct 2014 22:07:28,312 DEBUG [org.teiid.SECURITY] (http-/0.0.0.0:8080-1) hDPZOneobLNx closeSession hDPZOneobLNx^M

      13 Oct 2014 22:07:28,313 DEBUG [org.teiid.TXN_LOG] (http-/0.0.0.0:8080-1) hDPZOneobLNx before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@1a9aeb7f(hDPZOneobLNx,false)^M

      13 Oct 2014 22:07:28,315 DEBUG [org.teiid.TXN_LOG] (http-/0.0.0.0:8080-1) hDPZOneobLNx after cancelTransactions : null^M

      13 Oct 2014 22:07:28,317 FINE  [org.teiid.jdbc] (http-/0.0.0.0:8080-1) null Connection successfully closed.^M

      13 Oct 2014 22:07:28,318 WARN  [org.teiid.ODATA] (http-/0.0.0.0:8080-1) null TEIID16012 Could not produce a sucessful OData response.  Returning status ServerErrorException with message Internal Server Error.:

      org.odata4j.exceptions.ServerErrorException^M

              at org.teiid.odata.LocalClient.executeSQL(LocalClient.java:255) [classes:]^M

              at org.teiid.odata.TeiidProducer.getNavProperty(TeiidProducer.java:90) [classes:]^M

              at org.teiid.odata.TeiidProducer.getEntities(TeiidProducer.java:79) [classes:]^M

              at org.odata4j.producer.resources.EntitiesRequestResource.getEntitiesImpl(EntitiesRequestResource.java:371) [odata4j-core-0.8.0-SNAPSHOT-redhat-redhat.jar:]^M

              at org.odata4j.producer.resources.EntitiesRequestResource.getEntities(EntitiesRequestResource.java:266) [odata4j-core-0.8.0-SNAPSHOT-redhat-redhat.jar:]^M

              at sun.reflect.GeneratedMethodAccessor156.invoke(Unknown Source) [:1.7.0_03]^M

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]^M

              at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]^M

              at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167) [resteasy-jaxrs-2.3.6.Final.jar:]^M

              at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) [resteasy-jaxrs-2.3.6.Final.jar:]^M

              at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) [resteasy-jaxrs-2.3.6.Final.jar:]^M

              at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) [resteasy-jaxrs-2.3.6.Final.jar:]^M

              at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542) [resteasy-jaxrs-2.3.6.Final.jar:]^M

              at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524) [resteasy-jaxrs-2.3.6.Final.jar:]^M

              at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126) [resteasy-jaxrs-2.3.6.Final.jar:]^M

              at org.teiid.odata.ODataServletContainerDispatcher.service(ODataServletContainerDispatcher.java:118) [classes:]^M

              at org.teiid.odata.ODataServlet.service(ODataServlet.java:61) [classes:]^M

              at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.6.Final.jar:]^M

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]^M

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.2.0.Final.jar:7.2.0.Final]^M

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final.jar:7.2.0.Final]^M

              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.0.Final.jar:7.2.0.Final]^M

              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.0.Final.jar:7.2.0.Final]^M

              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) [jbossweb-7.2.0.Final.jar:7.2.0.Final]^M

              at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]^M

              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.0.Final.jar:7.2.0.Final]^M

              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.0.Final.jar:7.2.0.Final]^M

              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.0.Final.jar:7.2.0.Final]^M

              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.0.Final.jar:7.2.0.Final]^M

              at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.0.Final.jar:7.2.0.Final]^M