Unable to drill through data in JasperAnalysis

[suppachartt]

Hi All,

 

I tried to drill-through my data. But I got this error.

 

Cheers,

Suppachartt

Code:

java.lang.NegativeArraySizeException	at com.tonbeller.jpivot.mondrian.MondrianDrillThroughTableModel.getRow(MondrianDrillThroughTableModel.java:243)	at com.tonbeller.wcf.table.TableModelDecorator.getRow(TableModelDecorator.java:59)	at com.tonbeller.wcf.table.SortedTableModel.getRow(SortedTableModel.java:50)	at com.tonbeller.wcf.table.TableModelDecorator.getRow(TableModelDecorator.java:59)	at com.tonbeller.wcf.table.PagedTableModel.getRow(PagedTableModel.java:47)	at com.tonbeller.wcf.table.TableComponent.renderBody(TableComponent.java:468)	at com.tonbeller.wcf.table.TableComponent.render(TableComponent.java:332)	at com.tonbeller.wcf.component.NestableComponentSupport.render(NestableComponentSupport.java:39)	at com.tonbeller.wcf.table.EditableTableComponent.render(EditableTableComponent.java:135)	at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:141)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_wcf_005frender_005f7(viewOlap_jsp.java:3574)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fif_005f14(viewOlap_jsp.java:3529)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fotherwise_005f0(viewOlap_jsp.java:3497)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fchoose_005f0(viewOlap_jsp.java:3377)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fif_005f13(viewOlap_jsp.java:3343)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:482)	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:127)	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:56)	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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445)	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)	at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142)	at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247)	at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105)	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841)	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:141)	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:142)	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 com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:182)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:178)	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:178)	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:175)	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:263)	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)	at java.lang.Thread.run(Thread.java:619)  

[kkelleher]

Can you give some detail about your environment, like OS, app server, RDBMS?

 

Thanks,

 

Kristen

[suppachartt]

Hi Kristen,

 

Thanks for your reply. Here is my environment:

OS: Windows Server 2003

Web Server: Tomcat 6.0

RDBMS: Oracle 10g

BI: Jasper BI 3.5.1

 

Regards,

Suppachartt

[kkelleher]

Two more questions (though I have to say I think I may be stumped):

 

 - Professional or COmmunity Edition of JasperServer?

 - Java version?

 

Thanks,

 

Kristen

[swood]

I have not seen this before.

 

Can you share your schema?

 

Sherman

Jaspersoft

[jslagle]

We'll open a ticket, but I figured I'd post here that we're also having the issue:

Linux CentOS 5.3

JDK 1.6.10

Tomcat 6.0.18

Oracle 9i (tried a handful of jdbc drivers)

JasperServer/Analysis Pro 3.5.1

 

Query runs, then:

 

10:34:27,974 ERROR JSErrorPage_jsp,http-8080-2:360 -
java.lang.NegativeArraySizeException
        at com.tonbeller.jpivot.mondrian.MondrianDrillThroughTableModel.getRow(MondrianDrillThroughTableModel.java:243)
        at com.tonbeller.wcf.table.TableModelDecorator.getRow(TableModelDecorator.java:59)
        at com.tonbeller.wcf.table.SortedTableModel.getRow(SortedTableModel.java:50)
        at com.tonbeller.wcf.table.TableModelDecorator.getRow(TableModelDecorator.java:59)
        at com.tonbeller.wcf.table.PagedTableModel.getRow(PagedTableModel.java:47)
        at com.tonbeller.wcf.table.TableComponent.renderBody(TableComponent.java:468)
        at com.tonbeller.wcf.table.TableComponent.render(TableComponent.java:332)
 

[anuradhamehra01]

Hi,

 I am also facing the same error when I was trying to drill down the measures. Like I had build an analysis view with Country as row and on Column I have measures like  Device_Usage,Device_Down etc.

Now when I try to drill down country I am able to move down the hierarchy as Country -->>Region-->Store....

But when I click on the Measure values i.e Device_Usage at a particular country i get the same exception java.lang.NegativeArraySizeException

"

PFA the schema xml file.

I had a look at the demo xmls also but I was not able to make out where I am making a mistake.

Please let me know how can I solve this issue.

Thanks & Regards

Anuradha.

 

 

Code:

Post Edited by anuradhamehra01 at 10/26/2009 09:46

Post Edited by anuradhamehra01 at 10/26/2009 09:47

[carlones]

Hi!

 

I'm facing exactly the same error above, I tried to change the connection to XMLA but doesn't works either.

 

Thanks,

Carlos

[carlones]

Hi again!

 

I've tested JasperServer-Pro-3.5.1 and does the error. The version JasperServer-3.5, not trial, works fine. Is it a bug from JPilot?

 

Thanks!

Carlos

 

[swood]

I found out the problem. NUMBER columns in Oracle that have no precision and scale report a -ve number of decimal places. The workaround for now is to always set a precision and scale for these columns. This is fixed in the next release.

 

Sherman

Jaspersoft

[carlones]

I tried to set the precision of numeric values at PostgreSQL and does the same error.

How can I set this precision at cube definition?

 

Thanks!

Carlos

[swood]

You can't set it in the OLAP schema.

 

I have not tried the workaround on Postgres. The problem is at the JDBC level, where there is a -ve size for the nunber of decimal places.

 

What did you set for the precision of the numeric columns?

 

Sherman

Jaspersoft

[shankarpanda003]

Log Out the page button is not functioning properly when i am drilling through the Mondrian report (Foodmart Sample Analysis View).I have installed  JasperReports Server at cloud.It is working fine at cloud.But when i m accessing the report using the url in some other machine,i am facing problem.At cloud i have turned off the windows firewall,but still not able to logout from the page when drilling through Mondrian report.please help me.