Error Analisys Report - NO DATABASE SELECTED

[Federico Carlos]

Buenas a todos

 

Les consulto lo siguiente:

En la Enterprise console generé la conexion, en el schema workbench genere el cubo, lo publiqué y desde la User Console veo el Data Source creado, pero cuando arrastro alguna de las Dimensiones o Medidas obtengo el siguiente error:

 

java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: No database selected
        at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:199)
    at com.pentaho.analyzer.content.a.c.a(SourceFile:222)
      at com.pentaho.analyzer.content.a.n.dD(SourceFile:201)
     at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:185)
     at sun.reflect.GeneratedMethodAccessor140.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220)
  at $Proxy28.createContent(Unknown Source)
  at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
  at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    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:77)
 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:84)
 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.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
   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.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
     at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
       at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
    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.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
        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.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
  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.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
       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.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:43)
       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:113)
  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:433)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   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:849)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
 at java.lang.Thread.run(Unknown Source)
Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: No database selected
    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:157)
    ... 72 more
Caused by: java.lang.RuntimeException: java.sql.SQLException: No database selected
 at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:277)
      at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:302)
        at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:362)
    at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:118)
 at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:89)
  at com.pentaho.analyzer.report.ReportRequestService$c.bl(SourceFile:250)
   at com.pentaho.analyzer.report.ReportRequestService$c.call(SourceFile:240)
 at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
   at java.util.concurrent.FutureTask.run(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      ... 1 more
Caused by: java.sql.SQLException: No database selected
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:3179)
 at com.mysql.jdbc.Statement.executeQuery(Statement.java:1207)
      at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
  at mondrian.rolap.SqlStatement.execute(SqlStatement.java:152)
      at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:230)
       at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:373)
    at mondrian.rolap.SqlTupleReader.readTuples(SqlTupleReader.java:519)
       at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:481)
      at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:469)
      at mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:146)
  at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMembersInLevel(RolapCubeHierarchy.java:708)
    at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:493)
    at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:479)
    at mondrian.rolap.RolapCube$RolapCubeSchemaReader.getLevelMembers(RolapCube.java:2722)
     at mondrian.olap.DelegatingSchemaReader.getLevelMembers(DelegatingSchemaReader.java:161)
   at mondrian.olap.Query$QuerySchemaReader.getLevelMembers(Query.java:1462)
  at mondrian.olap.fun.FunUtil.getNonEmptyLevelMembers(FunUtil.java:2096)
    at mondrian.olap.fun.FunUtil.levelMembers(FunUtil.java:2104)
       at mondrian.olap.fun.LevelMembersFunDef$1.evaluateMemberList(LevelMembersFunDef.java:43)
   at mondrian.calc.impl.AbstractMemberListCalc.evaluate(AbstractMemberListCalc.java:71)
      at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:853)
    at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98)
        at mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64)
    at mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122)
       at mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52)
      at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:853)
    at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98)
        at mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64)
    at mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122)
       at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:173)
     at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:71)
  at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:853)
    at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98)
        at mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64)
    at mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122)
       at mondrian.olap.fun.OrderFunDef$MemberCalcImpl.evaluateMemberList(OrderFunDef.java:199)
   at mondrian.calc.impl.AbstractMemberListCalc.evaluate(AbstractMemberListCalc.java:71)
      at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:853)
    at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:98)
        at mondrian.rolap.RolapNamedSetEvaluator.evaluateMemberIterable(RolapNamedSetEvaluator.java:64)
    at mondrian.mdx.NamedSetExpr$2.evaluateMemberIterable(NamedSetExpr.java:122)
       at mondrian.calc.impl.AbstractMemberIterCalc.evaluate(AbstractMemberIterCalc.java:52)
      at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:733)
    at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:576)
       at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:542)
    at mondrian.rolap.RolapResult.(RolapResult.java:274)
       at mondrian.rolap.RolapConnection.execute(RolapConnection.java:593)
        at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:268)

Alguien sabe a que puede deberse?
   ... 11 more