La red del Business Intelligence
Etiquetas:
Hola Jorge,
en primer lugar, el mensaje que comentas "JPivot has been replaced by Pentaho Analyzer....." es sólo un aviso para decir que JPivot no va a seguir siendo mantenido ni va a seguir evolucionando.
El error que te aparece "Esta página no puede ser accedida directamente. Debe ser llamada desde otras paginas" es un el error que muestra JPivot cunado algo ha ido mal, pero es necesario mirar el log de pentaho para ver los detalles del error. Posiblemente sea un error en el esquema de Mondrian.
Pega aquí el error del log y te intentaré ayudar.
Un saludo.
Mira este es el log
at java.lang.Thread.run(Thread.java:722)
09:58:12,076 ERROR [Logger] Error end:
09:58:12,077 ERROR [Logger] misc-MondrianModelComponent: MondrianModel.ERROR_000
1 - [es_82] getInitialQuery(): Connection is not valid: {DataSource=Conection_Pe
d, PoolNeeded=false, Provider=mondrian, Catalog=solution:/FRONTPAS/cuboChequeoOK
.xml}
09:58:12,078 ERROR [PivotViewComponent] 44967edb-6fa0-11e2-8aaa-abd8a80e9541:COM
PONENT:context-27291940-1360074491070:1360074490520.analysisview.xactionPivotVie
w.ERROR_0010 - Query generation failed
09:58:12,087 ERROR [SolutionEngine] 44967edb-6fa0-11e2-8aaa-abd8a80e9541:SOLUTIO
N-ENGINE:1360074490520.analysisview.xaction: Action Sequence execution failed, s
ee details below
| Error Time: martes 5 de febrero de 2013 09H58' VET
| Session ID: joe
| Instance Id: 44967edb-6fa0-11e2-8aaa-abd8a80e9541
| Action Sequence: 1360074490520.analysisview.xaction
| Execution Stack:
EXECUTING ACTION: Pivot View (PivotViewComponent)
| Action Class: PivotViewComponent
| Action Desc: Pivot View
| Loop Index (1-based): 0
Stack Trace:org.pentaho.platform.api.engine.ActionExecutionException: RuntimeCon
text.ERROR_0017 - [es_18] Activity failed to execute
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeCo
mponent(RuntimeContext.java:1325)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAc
tion(RuntimeContext.java:1262)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.performAc
tions(RuntimeContext.java:1161)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLo
op(RuntimeContext.java:1105)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSe
quence(RuntimeContext.java:987)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSe
quence(RuntimeContext.java:897)
at org.pentaho.platform.engine.services.solution.SolutionEngine.executeI
nternal(SolutionEngine.java:399)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(
SolutionEngine.java:317)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(
SolutionEngine.java:193)
at org.apache.jsp.jsp.Pivot_jsp.getRuntimeForQuery(Pivot_jsp.java:96)
at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:446)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
13)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilte
r(PentahoWebContextFilter.java:102)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doF
ilter(PentahoRequestContextFilter.java:84)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.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.doFilterHt
tp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.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.AnonymousProcessingF
ilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.RequestParameterAuthentication
Filter.doFilter(RequestParameterAuthenticationFilter.java:169)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFil
terHttp(BasicProcessingFilter.java:174)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.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(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(Logo
utFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilte
r.doFilter(HttpSessionReuseDetectionFilter.java:134)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at org.springframework.security.context.HttpSessionContextIntegrationFil
ter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at org.springframework.security.wrapper.SecurityContextHolderAwareReques
tFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterCha
inProxy.java:175)
at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterTo
BeanProxy.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(Sys
temStatusFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFi
lter(SetCharacterEncodingFilter.java:113)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:470)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:298)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:861)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
84)
at java.lang.Thread.run(Thread.java:722)
Gracias por la ayuda
Hola,
está claro que tienes algún tipò de problema con la conexión a base de datos.
Comrpueba las siguientes cosas:
- El nombre del JNDI es correcto (que no se te haya pasado ninguna letra).
- Que la conexión con base de datos se establece correctyamente. Comprueba que la conexión de nombre "Conection_Pe
d" funciona.
Esto es lo que debes comprobar en un principio.
Un saludo.
Bienvenido a
Open Business Intelligence
© 2024 Creado por Emilio. Tecnología de