Uploaded image for project: 'Reporting Module'
  1. Reporting Module
  2. REPORT-608

Maximum number of cell styles was exceeded when running a large report with an XlsReportRenderer

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Must
    • Resolution: Fixed
    • Affects Version/s: Reporting 0.8.1
    • Fix Version/s: Reporting 0.8.2
    • Component/s: Report Renderers
    • Labels:
      None
    • Complexity:
      Undetermined

      Description

      java.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook
      at org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle(HSSFWorkbook.java:1120)
      at org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle(HSSFWorkbook.java:73)
      at org.openmrs.module.reporting.common.ExcelUtil.addStyle(ExcelUtil.java:145)
      at org.openmrs.module.reporting.common.ExcelUtil.setCellContents(ExcelUtil.java:93)
      at org.openmrs.module.reporting.common.ExcelBuilder.addCell(ExcelBuilder.java:96)
      at org.openmrs.module.reporting.common.ExcelBuilder.addCell(ExcelBuilder.java:58)
      at org.openmrs.module.reporting.report.renderer.XlsReportRenderer.render(XlsReportRenderer.java:81)
      at org.openmrs.module.reporting.report.service.ReportServiceImpl.runReport(ReportServiceImpl.java:453)
      at sun.reflect.GeneratedMethodAccessor3517.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
      at com.sun.proxy.$Proxy169.runReport(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor3517.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at com.sun.proxy.$Proxy170.runReport(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor3517.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
      at com.sun.proxy.$Proxy170.runReport(Unknown Source)
      at org.openmrs.module.reporting.report.task.RunQueuedReportsTask.execute(RunQueuedReportsTask.java:62)
      at org.openmrs.module.reporting.report.task.AbstractReportsTask.run(AbstractReportsTask.java:64)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
      at java.lang.Thread.run(Thread.java:662)

        Attachments

          Activity

            People

            • Assignee:
              mseaton Mike Seaton
              Reporter:
              mseaton Mike Seaton
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: