Yeah, that was the issue. I have checked with him and fixed it. Thanks, Sinthuja
On Tue, May 7, 2013 at 5:28 PM, Kasun Weranga <[email protected]> wrote: > Please check whether you have created and using the datasource correctly. > Sanjeewa's issue was due to that, I checked with him. > > > On Tue, May 7, 2013 at 5:20 PM, Shavantha Weerasinghe > <[email protected]>wrote: > >> Hi All >> >> I just now faced the same exception while testing with ESB Stat2. and >> BAM2.3.0 >> regards, >> >> Shavantha Weerasinghe >> Senior Software Engineer QA >> *WSO2, Inc. >> *lean.enterprise.middleware. >> http://wso2.com >> http://wso2.org >> >> >> On Mon, Apr 29, 2013 at 7:20 PM, Sanjeewa Malalgoda <[email protected]>wrote: >> >>> Hi All, >>> I'm getting following error when we deploy api manager 1.4.0 >>> toolbox(Didn't add any changes) in BAM 2.3.0. But we do not get these >>> errors if we setup it with BAM 2.0.1. This happens when we execute hive >>> queries. Is this happens because new feature added recently?(due to data >>> source definition change or something) >>> >>> inside toolbox we defined data source as follows >>> 'wso2.carbon.datasource.name'='WSO2AM_STATS_DB' >>> >>> Thanks. >>> Sanjeewa. >>> >>> [2013-04-29 19:08:10,609] INFO >>> {org.apache.cassandra.service.GCInspector} - GC for PS MarkSweep: 378 ms >>> for 1 collections, 180383600 used; max is 954466304 >>> Hive history >>> file=/home/wso2/Deployment/bam2/wso2bam-2.3.0/tmp/hive/wso2-querylogs/hive_job_log_wso2_201304291908_1150344847.txt >>> OK >>> [2013-04-29 19:08:13,648] ERROR >>> {org.wso2.carbon.hadoop.hive.jdbc.storage.datasource.CarbonDataSourceFetcher} >>> - Error occurred while getting carbon data-source >>> java.lang.reflect.InvocationTargetException >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> org.wso2.carbon.hadoop.hive.jdbc.storage.datasource.CarbonDataSourceFetcher.getCarbonDataSource(CarbonDataSourceFetcher.java:24) >>> at >>> org.wso2.carbon.hadoop.hive.jdbc.storage.db.DBOperation.createTableIfNotExist(DBOperation.java:277) >>> at >>> org.wso2.carbon.hadoop.hive.jdbc.storage.JDBCStorageHandler.preCreateTable(JDBCStorageHandler.java:62) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:397) >>> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) >>> at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3479) >>> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:225) >>> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:133) >>> at >>> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57) >>> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) >>> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) >>> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) >>> at >>> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:201) >>> at >>> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187) >>> at >>> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:336) >>> at >>> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:231) >>> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >>> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) >>> at java.lang.Thread.run(Thread.java:619) >>> Caused by: java.lang.NullPointerException >>> at >>> org.wso2.carbon.hive.data.source.access.util.DataSourceAccessUtil.getDataSourceProperties(DataSourceAccessUtil.java:66) >>> ... 25 more >>> FAILED: Error in metadata: java.lang.NullPointerException >>> [2013-04-29 19:08:13,651] ERROR {org.apache.hadoop.hive.ql.exec.Task} - >>> FAILED: Error in metadata: java.lang.NullPointerException >>> org.apache.hadoop.hive.ql.metadata.HiveException: >>> java.lang.NullPointerException >>> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:546) >>> at >>> org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3479) >>> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:225) >>> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:133) >>> at >>> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57) >>> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) >>> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) >>> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) >>> at >>> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:201) >>> at >>> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187) >>> at >>> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:336) >>> at >>> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:231) >>> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >>> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) >>> at java.lang.Thread.run(Thread.java:619) >>> Caused by: java.lang.NullPointerException >>> at >>> org.wso2.carbon.hadoop.hive.jdbc.storage.db.DBOperation.createTableIfNotExist(DBOperation.java:279) >>> at >>> org.wso2.carbon.hadoop.hive.jdbc.storage.JDBCStorageHandler.preCreateTable(JDBCStorageHandler.java:62) >>> at >>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:397) >>> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) >>> ... 16 more >>> >>> FAILED: Execution Error, return code 1 from >>> org.apache.hadoop.hive.ql.exec.DDLTask >>> [2013-04-29 19:08:13,651] ERROR {org.apache.hadoop.hive.ql.Driver} - >>> FAILED: Execution Error, return code 1 from >>> org.apache.hadoop.hive.ql.exec.DDLTask >>> [2013-04-29 19:08:13,653] ERROR >>> {org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl} - Error >>> while executing Hive script. >>> Query returned non-zero code: 9, cause: FAILED: Execution Error, return >>> code 1 from org.apache.hadoop.hive.ql.exec.DDLTask >>> java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: >>> Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask >>> at >>> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189) >>> at >>> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:336) >>> at >>> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:231) >>> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >>> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) >>> at java.lang.Thread.run(Thread.java:619) >>> [2013-04-29 19:08:13,666] ERROR >>> {org.wso2.carbon.analytics.hive.ui.client.HiveExecutionClient} - Error >>> while executing Hive script.Query returned non-zero code: 9, cause: FAILED: >>> Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask >>> org.wso2.carbon.analytics.hive.stub.HiveExecutionServiceHiveExecutionException: >>> HiveExecutionServiceHiveExecutionException >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:513) >>> at java.lang.Class.newInstance0(Class.java:355) >>> at java.lang.Class.newInstance(Class.java:308) >>> at >>> org.wso2.carbon.analytics.hive.stub.HiveExecutionServiceStub.executeHiveScript(HiveExecutionServiceStub.java:215) >>> at >>> org.wso2.carbon.analytics.hive.ui.client.HiveExecutionClient.executeScript(HiveExecutionClient.java:66) >>> at >>> org.apache.jsp.hive_002dexplorer.queryresults_jsp._jspService(org.apache.jsp.hive_002dexplorer.queryresults_jsp:92) >>> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >>> at >>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:403) >>> at >>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:492) >>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:378) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >>> at org.wso2.carbon.ui.JspServlet.service(JspServlet.java:155) >>> at org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:80) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >>> at >>> org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPathServletAdaptor.java:37) >>> at >>> org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) >>> at >>> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128) >>> at >>> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >>> at >>> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >>> at >>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749) >>> at >>> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605) >>> at >>> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544) >>> at >>> org.eclipse.equinox.http.servlet.internal.RequestDispatcherAdaptor.include(RequestDispatcherAdaptor.java:37) >>> at >>> org.eclipse.equinox.http.helper.ContextPathServletAdaptor$RequestDispatcherAdaptor.include(ContextPathServletAdaptor.java:369) >>> at >>> org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:1015) >>> at >>> org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:700) >>> at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at org.apache.tiles.jsp.context.JspUtil.doInclude(JspUtil.java:87) >>> at >>> org.apache.tiles.jsp.context.JspTilesRequestContext.include(JspTilesRequestContext.java:88) >>> at >>> org.apache.tiles.jsp.context.JspTilesRequestContext.dispatch(JspTilesRequestContext.java:82) >>> at >>> org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:465) >>> at >>> org.apache.tiles.jsp.taglib.InsertAttributeTag.render(InsertAttributeTag.java:140) >>> at >>> org.apache.tiles.jsp.taglib.InsertAttributeTag.render(InsertAttributeTag.java:117) >>> at >>> org.apache.tiles.jsp.taglib.RenderTagSupport.execute(RenderTagSupport.java:171) >>> at >>> org.apache.tiles.jsp.taglib.RoleSecurityTagSupport.doEndTag(RoleSecurityTagSupport.java:75) >>> at >>> org.apache.tiles.jsp.taglib.ContainerTagSupport.doEndTag(ContainerTagSupport.java:80) >>> at >>> org.apache.jsp.admin.layout.template_jsp._jspx_meth_tiles_insertAttribute_7(org.apache.jsp.admin.layout.template_jsp:536) >>> at >>> org.apache.jsp.admin.layout.template_jsp._jspService(org.apache.jsp.admin.layout.template_jsp:286) >>> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >>> at >>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:403) >>> at >>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:492) >>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:378) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >>> at org.wso2.carbon.ui.JspServlet.service(JspServlet.java:155) >>> at org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:80) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >>> at >>> org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPathServletAdaptor.java:37) >>> at >>> org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) >>> at >>> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128) >>> at >>> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >>> at >>> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >>> at >>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749) >>> at >>> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487) >>> at >>> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412) >>> at >>> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339) >>> at >>> org.eclipse.equinox.http.servlet.internal.RequestDispatcherAdaptor.forward(RequestDispatcherAdaptor.java:30) >>> at >>> org.eclipse.equinox.http.helper.ContextPathServletAdaptor$RequestDispatcherAdaptor.forward(ContextPathServletAdaptor.java:362) >>> at >>> org.apache.tiles.servlet.context.ServletTilesRequestContext.forward(ServletTilesRequestContext.java:198) >>> at >>> org.apache.tiles.servlet.context.ServletTilesRequestContext.dispatch(ServletTilesRequestContext.java:185) >>> at >>> org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:419) >>> at >>> org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:370) >>> at org.wso2.carbon.ui.action.ActionHelper.render(ActionHelper.java:52) >>> at org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:101) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >>> at >>> org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPathServletAdaptor.java:37) >>> at >>> org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) >>> at >>> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128) >>> at >>> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >>> at >>> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >>> at >>> org.wso2.carbon.tomcat.ext.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:61) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >>> at >>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) >>> at >>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) >>> at >>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) >>> at >>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) >>> at >>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) >>> at >>> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:177) >>> at >>> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:161) >>> at >>> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) >>> at >>> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:57) >>> at >>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) >>> at >>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) >>> at >>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) >>> at >>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) >>> at >>> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) >>> at java.lang.Thread.run(Thread.java:619) >>> >>> >>> -- >>> *Sanjeewa Malalgoda* >>> WSO2 Inc. >>> Mobile : +14084122175 | +94713068779 >>> >>> <http://sanjeewamalalgoda.blogspot.com/>blog >>> :http://sanjeewamalalgoda.blogspot.com/<http://sanjeewamalalgoda.blogspot.com/> >>> >>> _______________________________________________ >>> Dev mailing list >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> > > > -- > *Kasun Weranga* > ** > Member, Management Committee - Data Technologies > Software Engineer > *WSO2, Inc. > *lean.enterprise.middleware. > mobile : +94 772314602 > <http://sanjeewamalalgoda.blogspot.com/>blog : > http://kasunweranga.blogspot.com/ > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Sinthuja Rajendran* Software Engineer <http://wso2.com/> WSO2, Inc.:http://wso2.com Blog: http://sinthu-rajan.blogspot.com/ Mobile: +94774273955
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
