Open Business Intelligence

La red del Business Intelligence

Hola, necesito que me ayuden con este error, el hecho que quiero hacer una vista de analisis y me da el siguiente error:

Esta página no puede ser accedida directamente. Debe ser llamada desde otras paginas
JPivot has been replaced by Pentaho Analyzer.
It is provided as a convenience but will no longer be enhanced or offically supported by Pentaho.
Si alguien sabe por favor eplicarme

Visitas: 1437

Responde a esto

Respuestas a esta discusión

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.

 

Responder a debate

RSS

Distintivo

Cargando…

© 2020   Creado por Emilio.   Tecnología de

Emblemas  |  Reportar un problema  |  Términos de servicio