[Dev] WSO2 DAS 3.0.0 issue: failed to get records from table
Hi all. I´m facing a issue similar to this one: http://mail.wso2.org/mailarchive/dev/2015-August/054016.html I can see the data in my table and when I created the gadget I saw the data in the preview. but after stored the gadget I try to see the dashboard and this error appears in DAS console: [2015-10-31 18:35:47,642] ERROR {org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector} - failed to get records from table: 'TEMPERATURAS_FECHA_DESAGREGADA', Read timed o ut org.apache.axis2.AxisFault: Read timed out at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430) at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:199) at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:77) at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:451) at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:278) at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442) at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:430) at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:225) at org.apache.axis2.client.OperationClient.execute(OperationClient.java:149) at org.wso2.carbon.analytics.webservice.stub.AnalyticsWebServiceStub.getByRange(AnalyticsWebServiceStub.java:1762) at org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector.getRecordsByRange(AnalyticsWebServiceConnector.java:424) at org.wso2.carbon.analytics.jsservice.AnalyticsCachedWebServiceConnector.getRecordsByRange(AnalyticsCachedWebServiceConnector.java:101) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225) at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52) at org.jaggeryjs.rhino.portal.controllers.apis.c1._c_anonymous_1(/portal/controllers/apis/analytics.jag:194) at org.jaggeryjs.rhino.portal.controllers.apis.c1.call(/portal/controllers/apis/analytics.jag) at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) at org.jaggeryjs.rhino.portal.controllers.apis.c1._c_script_0(/portal/controllers/apis/analytics.jag:2) at org.jaggeryjs.rhino.portal.controllers.apis.c1.call(/portal/controllers/apis/analytics.jag) at org.jaggeryjs.rhino.portal.controllers.apis.c1.exec(/portal/controllers/apis/analytics.jag) at org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) at org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) at org.jaggeryjs.jaggery.core.manager.WebAppManager.executeScript(WebAppManager.java:308) at org.jaggeryjs.jaggery.core.manager.WebAppManager.include(WebAppManager.java:148) at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386) at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:63) at org.jaggeryjs.rhino.portal.routers.c2._c_anonymous_1(/portal/routers/apis.jag:22) at org.jaggeryjs.rhino.portal.routers.c2.call(/portal/routers/apis.jag) at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) at org.jaggeryjs.rhino.portal.routers.c2._c_script_0(/portal/routers/apis.jag:4) at org.jaggeryjs.rhino.portal.routers.c2.call(/portal/routers/apis.jag) at org.jaggeryjs.rhino.portal.routers.c2.exec(/portal/routers/apis.jag) at org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) at org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) at org.jaggeryjs.jaggery.core.manager.WebAppManager.executeScript(WebAppManager.java:308) at org.jaggeryjs.jaggery.core.manager.WebAppManager.include(WebAppManager.java:148) at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) at org.mozilla.javascript.FunctionObject.call(FunctionObj
Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table
Hi Jorge, Do you have an idea about how big the 'TEMPERATURAS_FECHA_DESAGREGADA' table is? the number of rows the table may be? rgds On Sun, Nov 1, 2015 at 4:15 AM, Jorge wrote: > Hi all. > I´m facing a issue similar to this one: > http://mail.wso2.org/mailarchive/dev/2015-August/054016.html > > I can see the data in my table and when I created the gadget I saw the > data in the preview. but after stored the gadget I try to see the dashboard > and this error appears in DAS console: > > > [2015-10-31 18:35:47,642] ERROR > {org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector} - > failed to get records from table: 'TEMPERATURAS_FECHA_DESAGREGADA', Read > timed o > ut > org.apache.axis2.AxisFault: Read timed out > at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430) > at > org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:199) > at > org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:77) > at > org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:451) > at > org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:278) > at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442) > at > org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:430) > at > org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:225) > at > org.apache.axis2.client.OperationClient.execute(OperationClient.java:149) > at > org.wso2.carbon.analytics.webservice.stub.AnalyticsWebServiceStub.getByRange(AnalyticsWebServiceStub.java:1762) > at > org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector.getRecordsByRange(AnalyticsWebServiceConnector.java:424) > at > org.wso2.carbon.analytics.jsservice.AnalyticsCachedWebServiceConnector.getRecordsByRange(AnalyticsCachedWebServiceConnector.java:101) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:601) > at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) > at > org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225) > at > org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52) > at > org.jaggeryjs.rhino.portal.controllers.apis.c1._c_anonymous_1(/portal/controllers/apis/analytics.jag:194) > at > org.jaggeryjs.rhino.portal.controllers.apis.c1.call(/portal/controllers/apis/analytics.jag) > at > org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) > at > org.jaggeryjs.rhino.portal.controllers.apis.c1._c_script_0(/portal/controllers/apis/analytics.jag:2) > at > org.jaggeryjs.rhino.portal.controllers.apis.c1.call(/portal/controllers/apis/analytics.jag) > at > org.jaggeryjs.rhino.portal.controllers.apis.c1.exec(/portal/controllers/apis/analytics.jag) > at > org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) > at > org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) > at > org.jaggeryjs.jaggery.core.manager.WebAppManager.executeScript(WebAppManager.java:308) > at > org.jaggeryjs.jaggery.core.manager.WebAppManager.include(WebAppManager.java:148) > at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:601) > at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) > at > org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386) > at > org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:63) > at > org.jaggeryjs.rhino.portal.routers.c2._c_anonymous_1(/portal/routers/apis.jag:22) > at > org.jaggeryjs.rhino.portal.routers.c2.call(/portal/routers/apis.jag) > at > org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) > at > org.jaggeryjs.rhino.portal.routers.c2._c_script_0(/portal/routers/apis.jag:4) > at > org.jaggeryjs.rhino.portal.routers.c2.call(/portal/routers/apis.jag) > at > org.jaggeryjs.rhino.portal.routers.c2.exec(/portal/routers/apis.jag) > at > org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) > at > org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) > at > org.jaggeryjs.jaggery.core.manager.WebAppManager.executeScript(WebAppManager.java:308) > at > org.jaggeryjs.jaggery.core.manager.WebAppManager.include(WebAppManager.j
Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table
rt", the sizing operation has stopped and the reported cache size is not accurate. If performance degradation is NOT an issue at the configured limit, raise the limit value using the CacheManager or Cache elements maxDepth attribute. For more information, see the Ehcache configuration documentation. {net.sf.ehcache.pool.sizeof.SizeOf} TID: [-1234] [] [2015-11-03 18:39:44,815] WARN {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 object references was reached while attempting to calculate the size of the object graph. This can be avoided by adding stop points with @IgnoreSizeOf annotations. Since the CacheManger or Cache elements maxDepthExceededBehavior is set to "abort", the sizing operation has stopped and the reported cache size is not accurate. If performance degradation is NOT an issue at the configured limit, raise the limit value using the CacheManager or Cache elements maxDepth attribute. For more information, see the Ehcache configuration documentation. {net.sf.ehcache.pool.sizeof.SizeOf} TID: [-1234] [] [2015-11-03 18:39:45,077] WARN {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 object references was reached while attempting to calculate the size of the object graph. This can be avoided by adding stop points with @IgnoreSizeOf annotations. Since the CacheManger or Cache elements maxDepthExceededBehavior is set to "abort", the sizing operation has stopped and the reported cache size is not accurate. If performance degradation is NOT an issue at the configured limit, raise the limit value using the CacheManager or Cache elements maxDepth attribute. For more information, see the Ehcache configuration documentation. {net.sf.ehcache.pool.sizeof.SizeOf} TID: [-1234] [] [2015-11-03 18:39:45,080] WARN {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 object references was reached while attempting to calculate the size of the object graph. This can be avoided by adding stop points with @IgnoreSizeOf annotations. Since the CacheManger or Cache elements maxDepthExceededBehavior is set to "abort", the sizing operation has stopped and the reported cache size is not accurate. If performance degradation is NOT an issue at the configured limit, raise the limit value using the CacheManager or Cache elements maxDepth attribute. For more information, see the Ehcache configuration documentation. {net.sf.ehcache.pool.sizeof.SizeOf} Thanks, Jorge De: Niranda Perera [mailto:nira...@wso2.com] Enviado el: sábado, 31 de octubre de 2015 23:49 Para: Jorge CC: WSO2 Developers' List Asunto: Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table Hi Jorge, Do you have an idea about how big the 'TEMPERATURAS_FECHA_DESAGREGADA' table is? the number of rows the table may be? rgds On Sun, Nov 1, 2015 at 4:15 AM, Jorge wrote: Hi all. I´m facing a issue similar to this one: http://mail.wso2.org/mailarchive/dev/2015-August/054016.html I can see the data in my table and when I created the gadget I saw the data in the preview. but after stored the gadget I try to see the dashboard and this error appears in DAS console: [2015-10-31 18:35:47,642] ERROR {org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector} - failed to get records from table: 'TEMPERATURAS_FECHA_DESAGREGADA', Read timed o ut org.apache.axis2.AxisFault: Read timed out at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430) at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:199) at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:77) at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:451) at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:278) at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442) at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:430) at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:225) at org.apache.axis2.client.OperationClient.execute(OperationClient.java:149) at org.wso2.carbon.analytics.webservice.stub.AnalyticsWebServiceStub.getByRange(AnalyticsWebServiceStub.java:1762) at org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector.getRecordsByRange(AnalyticsWebServiceConnector.java:424) at org.wso2.carbon.analytics.jsservice.AnalyticsCachedWebServiceConnector.getRecordsByRange(AnalyticsCachedWebServiceConnector.java:101) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.
Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table
.readLine(HttpParser.java:106) > at > org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116) > at > org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413) > at > org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973) > at > org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735) > at > org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098) > at > org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398) > at > org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) > at > org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) > at > org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.java:630) > at > org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:195) > ... 101 more > > > > The WARNs: > > TID: [-1234] [] [2015-11-03 18:39:44,189] WARN > {org.apache.shindig.gadgets.features.FeatureResourceLoader} - The > remote library from http://www.google-analytics.com/urchin.js cannot > be retrieved. {org.apache.shindig.gadgets.features.FeatureResourceLoader} > > TID: [-1234] [] [2015-11-03 18:39:44,192] WARN > {org.apache.shindig.gadgets.features.FeatureResourceLoader} - The > remote library from http://www.google.com/ig/lib/libanalytics.js > cannot be retrieved. > {org.apache.shindig.gadgets.features.FeatureResourceLoader} > > TID: [-1234] [] [2015-11-03 18:39:44,194] WARN > {org.apache.shindig.gadgets.features.FeatureResourceLoader} - The > remote library from http://www.google.com/ig/lib/libga.js cannot be > retrieved. {org.apache.shindig.gadgets.features.FeatureResourceLoader} > > TID: [-1234] [] [2015-11-03 18:39:44,808] WARN > {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 > object references was reached while attempting to calculate the size > of the object graph. This can be avoided by adding stop points with > @IgnoreSizeOf annotations. Since the CacheManger or Cache > elements maxDepthExceededBehavior is set to "abort", > the sizing operation has stopped and the reported cache size is not > accurate. If performance degradation is NOT an issue at the configured > limit, raise the limit value using the CacheManager or Cache > elements maxDepth attribute. For more information, see > the Ehcache configuration documentation. > {net.sf.ehcache.pool.sizeof.SizeOf} > > TID: [-1234] [] [2015-11-03 18:39:44,815] WARN > {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 > object references was reached while attempting to calculate the size > of the object graph. This can be avoided by adding stop points with > @IgnoreSizeOf annotations. Since the CacheManger or Cache > elements maxDepthExceededBehavior is set to "abort", > the sizing operation has stopped and the reported cache size is not > accurate. If performance degradation is NOT an issue at the configured > limit, raise the limit value using the CacheManager or Cache > elements maxDepth attribute. For more information, see > the Ehcache configuration documentation. > {net.sf.ehcache.pool.sizeof.SizeOf} > > TID: [-1234] [] [2015-11-03 18:39:45,077] WARN > {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 > object references was reached while attempting to calculate the size > of the object graph. This can be avoided by adding stop points with > @IgnoreSizeOf annotations. Since the CacheManger or Cache > elements maxDepthExceededBehavior is set to "abort", > the sizing operation has stopped and the reported cache size is not > accurate. If performance degradation is NOT an issue at the configured > limit, raise the limit value using the CacheManager or Cache > elements maxDepth attribute. For more information, see > the Ehcache configuration documentation. > {net.sf.ehcache.pool.sizeof.SizeOf} > > TID: [-1234] [] [2015-11-03 18:39:45,080] WARN > {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 > object references was reached while attempting to calculate the size > of the object graph. This can be avoided by adding stop points with > @IgnoreSizeOf annotations. Since the CacheManger or Cache > elements maxDepthExceededBehavior is set to "abort", > the sizing operation has stopped and the reported cache size is not > accurate. If performance degradation is NOT an issue at the configured > limit, raise the limit value using the CacheMan
Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table
y from http://www.google.com/ig/lib/libga.js cannot be >> retrieved. {org.apache.shindig.gadgets.features.FeatureResourceLoader} >> >> TID: [-1234] [] [2015-11-03 18:39:44,808] WARN >> {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 >> object references was reached while attempting to calculate the size >> of the object graph. This can be avoided by adding stop points with >> @IgnoreSizeOf annotations. Since the CacheManger or Cache >> elements maxDepthExceededBehavior is set to "abort", >> the sizing operation has stopped and the reported cache size is not >> accurate. If performance degradation is NOT an issue at the configured >> limit, raise the limit value using the CacheManager or Cache >> elements maxDepth attribute. For more information, see >> the Ehcache configuration documentation. >> {net.sf.ehcache.pool.sizeof.SizeOf} >> >> TID: [-1234] [] [2015-11-03 18:39:44,815] WARN >> {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 >> object references was reached while attempting to calculate the size >> of the object graph. This can be avoided by adding stop points with >> @IgnoreSizeOf annotations. Since the CacheManger or Cache >> elements maxDepthExceededBehavior is set to "abort", >> the sizing operation has stopped and the reported cache size is not >> accurate. If performance degradation is NOT an issue at the configured >> limit, raise the limit value using the CacheManager or Cache >> elements maxDepth attribute. For more information, see >> the Ehcache configuration documentation. >> {net.sf.ehcache.pool.sizeof.SizeOf} >> >> TID: [-1234] [] [2015-11-03 18:39:45,077] WARN >> {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 >> object references was reached while attempting to calculate the size >> of the object graph. This can be avoided by adding stop points with >> @IgnoreSizeOf annotations. Since the CacheManger or Cache >> elements maxDepthExceededBehavior is set to "abort", >> the sizing operation has stopped and the reported cache size is not >> accurate. If performance degradation is NOT an issue at the configured >> limit, raise the limit value using the CacheManager or Cache >> elements maxDepth attribute. For more information, see >> the Ehcache configuration documentation. >> {net.sf.ehcache.pool.sizeof.SizeOf} >> >> TID: [-1234] [] [2015-11-03 18:39:45,080] WARN >> {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 >> object references was reached while attempting to calculate the size >> of the object graph. This can be avoided by adding stop points with >> @IgnoreSizeOf annotations. Since the CacheManger or Cache >> elements maxDepthExceededBehavior is set to "abort", >> the sizing operation has stopped and the reported cache size is not >> accurate. If performance degradation is NOT an issue at the configured >> limit, raise the limit value using the CacheManager or Cache >> elements maxDepth attribute. For more information, see >> the Ehcache configuration documentation. >> {net.sf.ehcache.pool.sizeof.SizeOf} >> >> Thanks, >> Jorge >> >> De: Niranda Perera [mailto:nira...@wso2.com] >> Enviado el: sábado, 31 de octubre de 2015 23:49 >> Para: Jorge >> CC: WSO2 Developers' List >> Asunto: Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table >> >> Hi Jorge, >> >> Do you have an idea about how big the 'TEMPERATURAS_FECHA_DESAGREGADA' >> table is? the number of rows the table may be? >> >> rgds >> >> On Sun, Nov 1, 2015 at 4:15 AM, Jorge wrote: >> Hi all. >> I´m facing a issue similar to this one: >> http://mail.wso2.org/mailarchive/dev/2015-August/054016.html >> >> I can see the data in my table and when I created the gadget I saw the >> data in the preview. but after stored the gadget I try to see the >> dashboard and this error appears in DAS console: >> >> >> [2015-10-31 18:35:47,642] ERROR >> {org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector} - >> failed to get records from table: 'TEMPERATURAS_FECHA_DESAGREGADA', >> Read timed o >> ut >> org.apache.axis2.AxisFault: Read timed out >> at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430) >> at >> org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:199) >> at >> org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:77) >> at >> org.apache.axis2.transpor
Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table
Hi Nayomi. In my SO, windows8, I have not installed hadoop. The Hadoop binary installation is a requirement for DAS 3.0.0? Thanks for your answer, Jorge. -Mensaje original- De: Nayomi Dayarathne [mailto:nay...@wso2.com] Enviado el: lunes, 9 de noviembre de 2015 9:45 Para: Jorge CC: Niranda Perera ; WSO2 Developers' List Asunto: Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table Hi Jorge, I would like to add a comment about one of the errors[1] you have mentioned in your mail. [1] TID: [-1234] [] [2015-11-03 18:36:55,956] ERROR {org.apache.hadoop.util.Shell} - Failed to locate the winutils binary in the hadoop binary path {org.apache.hadoop.util.Shell} java.io.IOException: Could not locate executable null\bin\winutils.exe in the Hadoop binaries. Above error is related to Hadoop.The error says some files that required for hadoop to run on your OS are missing.According to what i have found out about this, if you are using binary distribution of Apache Hadoop 2.2.0 on windows environment, this issue arises. Please go through the below post[2] to find out more about this error. [2]http://blog.intelligencecomputing.io/big_data/13878/repost-error-util-shell-failed-to-locate-the-winutils-binary-in-the-hadoop-binary-path Regards, Nayomi Nayomi Dayarathne Software Engineer-QA Mobile : +94 (0) 775246619 nay...@wso2.com On Mon, Nov 9, 2015 at 6:57 PM, Jorge wrote: > Hi Niranda, any idea about this issue? > > Regards, >Jorge. > > 2015-11-03 19:43 GMT-05:00 Jorge : >> >> Hi Niranda, >> I try with this query: SELECT COUNT(temp) FROM >> temperaturasfechadesagregada >> >> And the result = 20596 >> >> Attached the log with the errors and warnings, the main issues: >> >> The errors: >> >> TID: [-1234] [] [2015-11-03 18:36:55,956] ERROR >> {org.apache.hadoop.util.Shell} - Failed to locate the winutils >> binary in the hadoop binary path {org.apache.hadoop.util.Shell} >> java.io.IOException: Could not locate executable >> null\bin\winutils.exe in the Hadoop binaries. >> >> TID: [-1234] [] [2015-11-03 18:40:15,960] INFO >> {org.apache.axis2.transport.http.HTTPSender} - Unable to sendViaPost >> to url[https://169.254.56.94:9443/services/AnalyticsWebService] >> {org.apache.axis2.transport.http.HTTPSender} >> java.net.SocketTimeoutException: Read timed out >> at java.net.SocketInputStream.socketRead0(Native Method) >> at java.net.SocketInputStream.read(SocketInputStream.java:150) >> at java.net.SocketInputStream.read(SocketInputStream.java:121) >> at sun.security.ssl.InputRecord.readFully(InputRecord.java:442) >> at sun.security.ssl.InputRecord.read(InputRecord.java:480) >> at >> sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:927) >> at >> sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:884) >> at sun.security.ssl.AppInputStream.read(AppInputStream.java:102) >> at java.io.BufferedInputStream.fill(BufferedInputStream.java:235) >> at java.io.BufferedInputStream.read(BufferedInputStream.java:254) >> at >> org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78) >> at >> org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106) >> at >> org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116) >> at >> org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413) >> at >> org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973) >> at >> org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735) >> at >> org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098) >> at >> org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398) >> at >> org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) >> at >> org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) >> at >> org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.java:630) >> at >> org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:195) >> at >> org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:77) >> at >> org.apache.axis2.transport.http.CommonsHTTPTransportSender
Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table
Hi Jorge, DAS does not require hadoop binary installation.But it's analytics framework depends on apache hadoop.Please go through the following link [1] for DAS installation on windows.So that you can make sure that the cause of the error is due to your configuration issues or not.Also, make sure you have downloaded the product without missing any files too. [1].https://docs.wso2.com/display/DAS300/Installing+on+Windows Thanks. Nayomi Dayarathne *Software Engineer-QA* Mobile : +94 (0) 775246619 <+94+(0)+775246619> *nay...@wso2.com * On Wed, Nov 11, 2015 at 7:56 PM, Jorge Infante wrote: > Hi Nayomi. > > In my SO, windows8, I have not installed hadoop. The Hadoop binary > installation is a requirement for DAS 3.0.0? > > Thanks for your answer, > Jorge. > > -Mensaje original- > De: Nayomi Dayarathne [mailto:nay...@wso2.com] > Enviado el: lunes, 9 de noviembre de 2015 9:45 > Para: Jorge > CC: Niranda Perera ; WSO2 Developers' List > > Asunto: Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table > > Hi Jorge, > > I would like to add a comment about one of the errors[1] you have > mentioned in your mail. > > [1] TID: [-1234] [] [2015-11-03 18:36:55,956] ERROR > {org.apache.hadoop.util.Shell} - Failed to locate the winutils binary in > the hadoop binary path {org.apache.hadoop.util.Shell} > java.io.IOException: Could not locate executable null\bin\winutils.exe in > the Hadoop binaries. > > Above error is related to Hadoop.The error says some files that required > for hadoop to run on your OS are missing.According to what i have found out > about this, if you are using binary distribution of Apache Hadoop 2.2.0 on > windows environment, this issue arises. > Please go through the below post[2] to find out more about this error. > > [2] > http://blog.intelligencecomputing.io/big_data/13878/repost-error-util-shell-failed-to-locate-the-winutils-binary-in-the-hadoop-binary-path > > > Regards, > Nayomi > Nayomi Dayarathne > Software Engineer-QA > Mobile : +94 (0) 775246619 > nay...@wso2.com > > > On Mon, Nov 9, 2015 at 6:57 PM, Jorge wrote: > > Hi Niranda, any idea about this issue? > > > > Regards, > >Jorge. > > > > 2015-11-03 19:43 GMT-05:00 Jorge : > >> > >> Hi Niranda, > >> I try with this query: SELECT COUNT(temp) FROM > >> temperaturasfechadesagregada > >> > >> And the result = 20596 > >> > >> Attached the log with the errors and warnings, the main issues: > >> > >> The errors: > >> > >> TID: [-1234] [] [2015-11-03 18:36:55,956] ERROR > >> {org.apache.hadoop.util.Shell} - Failed to locate the winutils > >> binary in the hadoop binary path {org.apache.hadoop.util.Shell} > >> java.io.IOException: Could not locate executable > >> null\bin\winutils.exe in the Hadoop binaries. > >> > >> TID: [-1234] [] [2015-11-03 18:40:15,960] INFO > >> {org.apache.axis2.transport.http.HTTPSender} - Unable to sendViaPost > >> to url[https://169.254.56.94:9443/services/AnalyticsWebService] > >> {org.apache.axis2.transport.http.HTTPSender} > >> java.net.SocketTimeoutException: Read timed out > >> at java.net.SocketInputStream.socketRead0(Native Method) > >> at java.net.SocketInputStream.read(SocketInputStream.java:150) > >> at java.net.SocketInputStream.read(SocketInputStream.java:121) > >> at sun.security.ssl.InputRecord.readFully(InputRecord.java:442) > >> at sun.security.ssl.InputRecord.read(InputRecord.java:480) > >> at > >> sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:927) > >> at > >> sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:884) > >> at sun.security.ssl.AppInputStream.read(AppInputStream.java:102) > >> at > java.io.BufferedInputStream.fill(BufferedInputStream.java:235) > >> at > java.io.BufferedInputStream.read(BufferedInputStream.java:254) > >> at > >> org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78) > >> at > >> org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106) > >> at > >> > org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116) > >> at > >> > org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413) > >> at > >> > org.apache.commons.h
Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table
Hi all, The installation guide seems bit outdated, we will update the documentation, and the public JIRA reported [1] to track this. @Jorge, actually you don't need hadoop or cygwin to run DAS in windows. Can you please elaborate your setup? What is your record store, is it RDBMS (by default H2 database) or HBase? If it's HBase then you may require to use cygwin because it used the hadoop libraries as explained in [2], otherwise it's not required to use cygwin. [1] https://wso2.org/jira/browse/DOCUMENTATION-2700 [2] https://hbase.apache.org/cygwin.html Thanks, Sinthuja. On Thu, Nov 12, 2015 at 11:12 AM, Nayomi Dayarathne wrote: > Hi Jorge, > > DAS does not require hadoop binary installation.But it's analytics > framework depends on apache hadoop.Please go through the following link [1] > for DAS installation on windows.So that you can make sure that the cause of > the error is due to your configuration issues or not.Also, make sure you > have downloaded the product without missing any files too. > > [1].https://docs.wso2.com/display/DAS300/Installing+on+Windows > > Thanks. > > > Nayomi Dayarathne > > *Software Engineer-QA* > Mobile : +94 (0) 775246619 <+94+(0)+775246619> > > *nay...@wso2.com * > > On Wed, Nov 11, 2015 at 7:56 PM, Jorge Infante > wrote: > >> Hi Nayomi. >> >> In my SO, windows8, I have not installed hadoop. The Hadoop binary >> installation is a requirement for DAS 3.0.0? >> >> Thanks for your answer, >> Jorge. >> >> -Mensaje original- >> De: Nayomi Dayarathne [mailto:nay...@wso2.com] >> Enviado el: lunes, 9 de noviembre de 2015 9:45 >> Para: Jorge >> CC: Niranda Perera ; WSO2 Developers' List < >> dev@wso2.org> >> Asunto: Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table >> >> Hi Jorge, >> >> I would like to add a comment about one of the errors[1] you have >> mentioned in your mail. >> >> [1] TID: [-1234] [] [2015-11-03 18:36:55,956] ERROR >> {org.apache.hadoop.util.Shell} - Failed to locate the winutils binary in >> the hadoop binary path {org.apache.hadoop.util.Shell} >> java.io.IOException: Could not locate executable null\bin\winutils.exe in >> the Hadoop binaries. >> >> Above error is related to Hadoop.The error says some files that required >> for hadoop to run on your OS are missing.According to what i have found out >> about this, if you are using binary distribution of Apache Hadoop 2.2.0 on >> windows environment, this issue arises. >> Please go through the below post[2] to find out more about this error. >> >> [2] >> http://blog.intelligencecomputing.io/big_data/13878/repost-error-util-shell-failed-to-locate-the-winutils-binary-in-the-hadoop-binary-path >> >> >> Regards, >> Nayomi >> Nayomi Dayarathne >> Software Engineer-QA >> Mobile : +94 (0) 775246619 >> nay...@wso2.com >> >> >> On Mon, Nov 9, 2015 at 6:57 PM, Jorge wrote: >> > Hi Niranda, any idea about this issue? >> > >> > Regards, >> >Jorge. >> > >> > 2015-11-03 19:43 GMT-05:00 Jorge : >> >> >> >> Hi Niranda, >> >> I try with this query: SELECT COUNT(temp) FROM >> >> temperaturasfechadesagregada >> >> >> >> And the result = 20596 >> >> >> >> Attached the log with the errors and warnings, the main issues: >> >> >> >> The errors: >> >> >> >> TID: [-1234] [] [2015-11-03 18:36:55,956] ERROR >> >> {org.apache.hadoop.util.Shell} - Failed to locate the winutils >> >> binary in the hadoop binary path {org.apache.hadoop.util.Shell} >> >> java.io.IOException: Could not locate executable >> >> null\bin\winutils.exe in the Hadoop binaries. >> >> >> >> TID: [-1234] [] [2015-11-03 18:40:15,960] INFO >> >> {org.apache.axis2.transport.http.HTTPSender} - Unable to sendViaPost >> >> to url[https://169.254.56.94:9443/services/AnalyticsWebService] >> >> {org.apache.axis2.transport.http.HTTPSender} >> >> java.net.SocketTimeoutException: Read timed out >> >> at java.net.SocketInputStream.socketRead0(Native Method) >> >> at java.net.SocketInputStream.read(SocketInputStream.java:150) >> >> at java.net.SocketInputStream.read(SocketInputStream.java:121) >> >> at sun.security.ssl.InputRecord.readFully(InputRecord.java:442) >> >> at sun.security.ssl.InputR
Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table
Hi Sinthuja, Thank you for this information. I will work on this jira. Best Regards Rukshani. On Thu, Nov 12, 2015 at 12:32 PM, Sinthuja Ragendran wrote: > Hi all, > > The installation guide seems bit outdated, we will update the > documentation, and the public JIRA reported [1] to track this. > > @Jorge, actually you don't need hadoop or cygwin to run DAS in windows. > Can you please elaborate your setup? What is your record store, is it RDBMS > (by default H2 database) or HBase? If it's HBase then you may require to > use cygwin because it used the hadoop libraries as explained in [2], > otherwise it's not required to use cygwin. > > > [1] https://wso2.org/jira/browse/DOCUMENTATION-2700 > > [2] https://hbase.apache.org/cygwin.html > > Thanks, > Sinthuja. > > On Thu, Nov 12, 2015 at 11:12 AM, Nayomi Dayarathne > wrote: > >> Hi Jorge, >> >> DAS does not require hadoop binary installation.But it's analytics >> framework depends on apache hadoop.Please go through the following link [1] >> for DAS installation on windows.So that you can make sure that the cause of >> the error is due to your configuration issues or not.Also, make sure you >> have downloaded the product without missing any files too. >> >> [1].https://docs.wso2.com/display/DAS300/Installing+on+Windows >> >> Thanks. >> >> >> Nayomi Dayarathne >> >> *Software Engineer-QA* >> Mobile : +94 (0) 775246619 <+94+(0)+775246619> >> >> *nay...@wso2.com * >> >> On Wed, Nov 11, 2015 at 7:56 PM, Jorge Infante >> wrote: >> >>> Hi Nayomi. >>> >>> In my SO, windows8, I have not installed hadoop. The Hadoop binary >>> installation is a requirement for DAS 3.0.0? >>> >>> Thanks for your answer, >>> Jorge. >>> >>> -Mensaje original- >>> De: Nayomi Dayarathne [mailto:nay...@wso2.com] >>> Enviado el: lunes, 9 de noviembre de 2015 9:45 >>> Para: Jorge >>> CC: Niranda Perera ; WSO2 Developers' List < >>> dev@wso2.org> >>> Asunto: Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table >>> >>> Hi Jorge, >>> >>> I would like to add a comment about one of the errors[1] you have >>> mentioned in your mail. >>> >>> [1] TID: [-1234] [] [2015-11-03 18:36:55,956] ERROR >>> {org.apache.hadoop.util.Shell} - Failed to locate the winutils binary in >>> the hadoop binary path {org.apache.hadoop.util.Shell} >>> java.io.IOException: Could not locate executable null\bin\winutils.exe >>> in the Hadoop binaries. >>> >>> Above error is related to Hadoop.The error says some files that required >>> for hadoop to run on your OS are missing.According to what i have found out >>> about this, if you are using binary distribution of Apache Hadoop 2.2.0 on >>> windows environment, this issue arises. >>> Please go through the below post[2] to find out more about this error. >>> >>> [2] >>> http://blog.intelligencecomputing.io/big_data/13878/repost-error-util-shell-failed-to-locate-the-winutils-binary-in-the-hadoop-binary-path >>> >>> >>> Regards, >>> Nayomi >>> Nayomi Dayarathne >>> Software Engineer-QA >>> Mobile : +94 (0) 775246619 >>> nay...@wso2.com >>> >>> >>> On Mon, Nov 9, 2015 at 6:57 PM, Jorge wrote: >>> > Hi Niranda, any idea about this issue? >>> > >>> > Regards, >>> >Jorge. >>> > >>> > 2015-11-03 19:43 GMT-05:00 Jorge : >>> >> >>> >> Hi Niranda, >>> >> I try with this query: SELECT COUNT(temp) FROM >>> >> temperaturasfechadesagregada >>> >> >>> >> And the result = 20596 >>> >> >>> >> Attached the log with the errors and warnings, the main issues: >>> >> >>> >> The errors: >>> >> >>> >> TID: [-1234] [] [2015-11-03 18:36:55,956] ERROR >>> >> {org.apache.hadoop.util.Shell} - Failed to locate the winutils >>> >> binary in the hadoop binary path {org.apache.hadoop.util.Shell} >>> >> java.io.IOException: Could not locate executable >>> >> null\bin\winutils.exe in the Hadoop binaries. >>> >> >>> >> TID: [-1234] [] [2015-11-03 18:40:15,960] INFO >>> >> {org.apache.axis2.transport.http.HTTPSender} - Unable to s
Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table
Hi all, Mi setup it´s the default, using H2, just for a DAS 3.0.0 demo...in previous snapshots or with BAM 2.5.0 this scenario work just fine, now I can not see the data in my graphs. So the hadoop error it´s something else. But the problem I´m facing it´s with the timeout: TID: [-1234] [] [2015-11-03 18:40:15,960] INFO {org.apache.axis2.transport.http.HTTPSender} - Unable to sendViaPost to url[https://169.254.56.94:9443/services/AnalyticsWebService] {org.apache.axis2.transport.http.HTTPSender} java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:150) at java.net.SocketInputStream.read(SocketInputStream.java:121) at sun.security.ssl.InputRecord.readFully(InputRecord.java:442) at sun.security.ssl.InputRecord.read(InputRecord.java:480) at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:927) at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl .java:884) [2015-10-31 18:35:47,642] ERROR {org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector} - failed to get records from table: 'TEMPERATURAS_FECHA_DESAGREGADA', Read timed o ut org.apache.axis2.AxisFault: Read timed out at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430) at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender .java:199) at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender .java:77) Any clue? Thanks, Jorge. 2015-11-12 2:02 GMT-05:00 Sinthuja Ragendran : > Hi all, > > The installation guide seems bit outdated, we will update the > documentation, and the public JIRA reported [1] to track this. > > @Jorge, actually you don't need hadoop or cygwin to run DAS in windows. > Can you please elaborate your setup? What is your record store, is it RDBMS > (by default H2 database) or HBase? If it's HBase then you may require to > use cygwin because it used the hadoop libraries as explained in [2], > otherwise it's not required to use cygwin. > > > [1] https://wso2.org/jira/browse/DOCUMENTATION-2700 > > [2] https://hbase.apache.org/cygwin.html > > Thanks, > Sinthuja. > > On Thu, Nov 12, 2015 at 11:12 AM, Nayomi Dayarathne > wrote: > >> Hi Jorge, >> >> DAS does not require hadoop binary installation.But it's analytics >> framework depends on apache hadoop.Please go through the following link [1] >> for DAS installation on windows.So that you can make sure that the cause of >> the error is due to your configuration issues or not.Also, make sure you >> have downloaded the product without missing any files too. >> >> [1].https://docs.wso2.com/display/DAS300/Installing+on+Windows >> >> Thanks. >> >> >> Nayomi Dayarathne >> >> *Software Engineer-QA* >> Mobile : +94 (0) 775246619 <+94+(0)+775246619> >> >> *nay...@wso2.com * >> >> On Wed, Nov 11, 2015 at 7:56 PM, Jorge Infante >> wrote: >> >>> Hi Nayomi. >>> >>> In my SO, windows8, I have not installed hadoop. The Hadoop binary >>> installation is a requirement for DAS 3.0.0? >>> >>> Thanks for your answer, >>> Jorge. >>> >>> -Mensaje original- >>> De: Nayomi Dayarathne [mailto:nay...@wso2.com] >>> Enviado el: lunes, 9 de noviembre de 2015 9:45 >>> Para: Jorge >>> CC: Niranda Perera ; WSO2 Developers' List < >>> dev@wso2.org> >>> Asunto: Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table >>> >>> Hi Jorge, >>> >>> I would like to add a comment about one of the errors[1] you have >>> mentioned in your mail. >>> >>> [1] TID: [-1234] [] [2015-11-03 18:36:55,956] ERROR >>> {org.apache.hadoop.util.Shell} - Failed to locate the winutils binary in >>> the hadoop binary path {org.apache.hadoop.util.Shell} >>> java.io.IOException: Could not locate executable null\bin\winutils.exe >>> in the Hadoop binaries. >>> >>> Above error is related to Hadoop.The error says some files that required >>> for hadoop to run on your OS are missing.According to what i have found out >>> about this, if you are using binary distribution of Apache Hadoop 2.2.0 on >>> windows environment, this issue arises. >>> Please go through the below post[2] to find out more about this error. >>> >>> [2] >>> http://blog.intelligencecomputing.io/big_data/13878/repost-error-util-shell-failed-to-locate-the-winutils-binary-in-the-hadoop-binary-path >>> >&g