I am using Pentaho Enterprise edition - evaluation version 5.0.2.1. I have formed an analyses datasource on top of Oracle DB 11g R2 and am using ojdbc6.jar for connectivity between biserver and oracle. This connection works fine as I have run through some interactive and basic reports from bi server to this oracle DB.

However this new analysis source which I have created does not work fine and it gives random error as below. The reason am calling it as random error is, when i select a dimension and a measure it works fine and gives result. When I gets on to add another dimension, it gives the error as shown below. I thought the problem could be with the dimension which am trying to do analytics, however it is not the case, because the one which worked does not work if i close and re-open the window and do the same steps again. Network connectivity is proper while carrying out the test case. Error log is pasted below in bold text, please provide assistance

java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: ORA-12592: TNS:bad packet


at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:213)

at com.pentaho.analyzer.content.controller.j.a(SourceFile:170)

at com.pentaho.analyzer.content.controller.b.b(SourceFile:189)

at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:123)

at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:229)

at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:156)

at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:58)

at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:37)

at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:306)

at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1479)

at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)

at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)

at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)

at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)

at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)

at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:111)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:116)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:161)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:83)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)

at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)

at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)

at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:88)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:265)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)

at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)

at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:72)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:66)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

at java.lang.Thread.run(Unknown Source)

Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: ORA-12592: TNS:bad packet


at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)

at java.util.concurrent.FutureTask.get(Unknown Source)

at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:171)

... 71 more

Caused by: java.lang.RuntimeException: java.sql.SQLException: ORA-12592: TNS:bad packet


at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:288)

at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:296)

at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:120)

at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:92)

at com.pentaho.analyzer.report.ReportRequestService$2.a(SourceFile:274)

at com.pentaho.analyzer.report.ReportRequestService$2.call(SourceFile:267)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

... 1 more

Caused by: java.sql.SQLException: ORA-12592: TNS:bad packet


at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)

at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)

at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)

at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)

at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

at mondrian.rolap.SqlStatement.execute(SqlStatement.java:200)

at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:334)

at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:395)

at mondrian.rolap.SqlTupleReader.readTuples(SqlTupleReader.java:560)

at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:250)

at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:190)

at mondrian.olap.fun.NonEmptyCrossJoinFunDef$1.evaluateList(NonEmptyCrossJoinFunDef.java:80)

at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)

at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:989)

at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98)

at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66)

at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)

at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:109)

at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)

at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:989)

at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98)

at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66)

at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)

at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:201)

at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)

at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:989)

at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98)

at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66)

at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)

at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:875)

at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:700)

at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:656)

at mondrian.rolap.RolapResult.<init>(RolapResult.java:288)

at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:671)

at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)

at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622)

at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621)