Jump to content
We've recently updated our Privacy Statement, available here ×

Error showing source data in Analysis View


carminez

Recommended Posts

When I click on a Measure value in an Analysis View, I am getting the following error when it tries to show the Source Data.

Is there something special that needs to be done in the Schema to have this work, or is there something wrong with the Schema?

JS 3.1 Professional, the database is MSSQL 2005 and I'm using the jTDS driver.

This is the MDX that is the source for the Analysis View when I'm trying to click on the Measure value:

select NON EMPTY {[Measures].[Rooms], [Measures].[Room Nights]} ON COLUMNS,
  NON EMPTY Hierarchize(Union(Crossjoin({[Chain.Chain].[All Chains].[Mandarin Oriental]}, {[Hotel.Hotel].[All Hotels]}), Crossjoin({[Chain.Chain].[All Chains].[Mandarin Oriental]}, [Hotel.Hotel].[All Hotels].Children))) ON ROWS
from [Reservations]
where [Arrival Date].[All Dates].[2008]

 

Code:
com.jaspersoft.ji.ja.JasperAnalysisException: Internal error: assert failed	at mondrian.resource.MondrianResource$_Def0.ex_aroundBody1$advice(MondrianResource.java:197)	at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1)	at mondrian.olap.Util.newInternal(Util.java:1076)	at mondrian.olap.Util.assertTrue(Util.java:1057)	at mondrian.rolap.RolapLevel$RegularLevelReader.constrainRequest(RolapLevel.java:528)	at mondrian.rolap.RolapAggregationManager.makeRequest(RolapAggregationManager.java:82)	at mondrian.rolap.RolapCell.getDrillThroughSQL(RolapCell.java:64)	at com.tonbeller.jpivot.mondrian.MondrianDrillThrough.drillThrough(MondrianDrillThrough.java:103)	at com.tonbeller.jpivot.mondrian.MondrianDrillThrough.drillThrough(MondrianDrillThrough.java:92)	at com.tonbeller.jpivot.table.navi.DrillThroughUI.drillThrough(DrillThroughUI.java:266)	at com.tonbeller.jpivot.table.navi.DrillThroughUI$DrillThroughHandler.request(DrillThroughUI.java:223)	at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167)	at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167)	at com.tonbeller.wcf.component.ComponentSupport.request(ComponentSupport.java:110)	at com.tonbeller.jpivot.table.TableComponent.request(TableComponent.java:241)	at com.tonbeller.wcf.controller.WcfController.request(WcfController.java:71)	at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:121)	at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)	at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:281)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)	at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:107)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)	at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)	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.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:286)	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:857)	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565)	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509)	at java.lang.Thread.run(Unknown Source)  
Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...