uk.org.ponder.util.UniversalRuntimeException: Error servicing SakaiRSF request --> Error invoking init method handle on bean rootHandlerBean --> You cannot have more than 255 columns in a given row (IV). Because Excel can't handle it

Sakai JIRA | Lovemore Nalube | 7 years ago
  1. 0

    Eval has: 42 responses, 467 total report eval items including repeated lecturer items. This error is throw when a user tries to export an eval report in excel: stack trace: org.sakaiproject.portal.api.PortalHandlerException: uk.org.ponder.util.UniversalRuntimeException: Error servicing SakaiRSF request --> Error invoking init method handle on bean rootHandlerBean --> You cannot have more than 255 columns in a given row (IV). Because Excel can't handle it at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:768) caused by: uk.org.ponder.util.UniversalRuntimeException: Error servicing SakaiRSF request --> Error invoking init method handle on bean rootHandlerBean --> You cannot have more than 255 columns in a given row (IV). Because Excel can't handle it at org.apache.poi.hssf.usermodel.HSSFCell.checkBounds(HSSFCell.java:908) at org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:168) at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:149) at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:133) at org.sakaiproject.evaluation.tool.reporting.XLSReportExporter.buildReport(XLSReportExporter.java:163) at org.sakaiproject.evaluation.tool.reporting.ReportExporterBean.export(ReportExporterBean.java:81) at org.sakaiproject.evaluation.tool.reporting.ReportHandlerHook.handle(ReportHandlerHook.java:57) at org.sakaiproject.evaluation.tool.utils.RootHandlerBeanOverride.handle(RootHandlerBeanOverride.java:28) at sun.reflect.GeneratedMethodAccessor7716.invoke(null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:23) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:17) at uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:77) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.createBean(RSACBeanLocatorImpl.java:553) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.access$000(RSACBeanLocatorImpl.java:75) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl$1.run(RSACBeanLocatorImpl.java:449) at org.sakaiproject.genericdao.hibernate.HibernateGenericDao.invokeTransactionalAccess(HibernateGenericDao.java:580) at sun.reflect.GeneratedMethodAccessor7691.invoke(null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy9.invokeTransactionalAccess(null:-1) at org.sakaiproject.evaluation.dao.EvalDaoInvokerImpl.invokeTransactionalAccess(EvalDaoInvokerImpl.java:34) at org.sakaiproject.evaluation.tool.wrapper.ModelAccessWrapperInvoker.invokeRunnable(ModelAccessWrapperInvoker.java:38) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.createBean(RSACBeanLocatorImpl.java:447) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.access$000(RSACBeanLocatorImpl.java:75) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl$1.run(RSACBeanLocatorImpl.java:449) at uk.org.ponder.rsac.RSACErrorBridge.invokeRunnable(RSACErrorBridge.java:38) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.createBean(RSACBeanLocatorImpl.java:447) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.getLocalBean(RSACBeanLocatorImpl.java:348) at uk.org.ponder.rsac.support.RSACBeanLocatorImpl.getBean(RSACBeanLocatorImpl.java:379) at uk.org.ponder.rsac.support.PerRequestInfo$1.locateBean(PerRequestInfo.java:49) at uk.ac.cam.caret.sakai.rsf.servlet.ReasonableSakaiServlet.service(ReasonableSakaiServlet.java:65) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:565) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:461) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:364) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:475) at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1216) at org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:188) at org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:93) at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:768) at javax.servlet.http.HttpServlet.service(HttpServlet.java:627) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:616) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:595)

    Sakai JIRA | 7 years ago | Lovemore Nalube
    uk.org.ponder.util.UniversalRuntimeException: Error servicing SakaiRSF request --> Error invoking init method handle on bean rootHandlerBean --> You cannot have more than 255 columns in a given row (IV). Because Excel can't handle it
  2. 0

    [EVALSYS-775] Excel report export cannot handle more than 255 rows - Sakai

    sakaiproject.org | 1 year ago
    uk.org.ponder.util.UniversalRuntimeException: Error servicing SakaiRSF request --> Error invoking init method handle on bean rootHandlerBean --> You cannot have more than 255 columns in a given row (IV). Because Excel can't handle it
  3. 0

    [EVALSYS-775] Excel report export cannot handle more than 255 rows - Sakai

    sakaiproject.org | 12 months ago
    uk.org.ponder.util.UniversalRuntimeException: Error servicing SakaiRSF request --> Error invoking init method handle on bean rootHandlerBean --> You cannot have more than 255 columns in a given row (IV). Because Excel can't handle it
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. uk.org.ponder.util.UniversalRuntimeException

      Error servicing SakaiRSF request --> Error invoking init method handle on bean rootHandlerBean --> You cannot have more than 255 columns in a given row (IV). Because Excel can't handle it

      at org.apache.poi.hssf.usermodel.HSSFCell.checkBounds()
    2. POI
      HSSFRow.createCell
      1. org.apache.poi.hssf.usermodel.HSSFCell.checkBounds(HSSFCell.java:908)
      2. org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:168)
      3. org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:149)
      4. org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:133)
      4 frames
    3. org.sakaiproject.evaluation
      RootHandlerBeanOverride.handle
      1. org.sakaiproject.evaluation.tool.reporting.XLSReportExporter.buildReport(XLSReportExporter.java:163)
      2. org.sakaiproject.evaluation.tool.reporting.ReportExporterBean.export(ReportExporterBean.java:81)
      3. org.sakaiproject.evaluation.tool.reporting.ReportHandlerHook.handle(ReportHandlerHook.java:57)
      4. org.sakaiproject.evaluation.tool.utils.RootHandlerBeanOverride.handle(RootHandlerBeanOverride.java:28)
      4 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor7716.invoke(null:-1)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:585)
      3 frames
    5. uk.org.ponder
      RSACBeanLocatorImpl$1.run
      1. uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:23)
      2. uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:17)
      3. uk.org.ponder.reflect.JDKReflectiveCache.invokeMethod(JDKReflectiveCache.java:77)
      4. uk.org.ponder.rsac.support.RSACBeanLocatorImpl.createBean(RSACBeanLocatorImpl.java:553)
      5. uk.org.ponder.rsac.support.RSACBeanLocatorImpl.access$000(RSACBeanLocatorImpl.java:75)
      6. uk.org.ponder.rsac.support.RSACBeanLocatorImpl$1.run(RSACBeanLocatorImpl.java:449)
      6 frames
    6. org.sakaiproject.genericdao
      HibernateGenericDao.invokeTransactionalAccess
      1. org.sakaiproject.genericdao.hibernate.HibernateGenericDao.invokeTransactionalAccess(HibernateGenericDao.java:580)
      1 frame
    7. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor7691.invoke(null:-1)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:585)
      3 frames
    8. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      3 frames
    9. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
      1 frame
    10. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    11. Unknown
      $Proxy9.invokeTransactionalAccess
      1. $Proxy9.invokeTransactionalAccess(null:-1)
      1 frame
    12. org.sakaiproject.evaluation
      ModelAccessWrapperInvoker.invokeRunnable
      1. org.sakaiproject.evaluation.dao.EvalDaoInvokerImpl.invokeTransactionalAccess(EvalDaoInvokerImpl.java:34)
      2. org.sakaiproject.evaluation.tool.wrapper.ModelAccessWrapperInvoker.invokeRunnable(ModelAccessWrapperInvoker.java:38)
      2 frames
    13. uk.org.ponder
      PerRequestInfo$1.locateBean
      1. uk.org.ponder.rsac.support.RSACBeanLocatorImpl.createBean(RSACBeanLocatorImpl.java:447)
      2. uk.org.ponder.rsac.support.RSACBeanLocatorImpl.access$000(RSACBeanLocatorImpl.java:75)
      3. uk.org.ponder.rsac.support.RSACBeanLocatorImpl$1.run(RSACBeanLocatorImpl.java:449)
      4. uk.org.ponder.rsac.RSACErrorBridge.invokeRunnable(RSACErrorBridge.java:38)
      5. uk.org.ponder.rsac.support.RSACBeanLocatorImpl.createBean(RSACBeanLocatorImpl.java:447)
      6. uk.org.ponder.rsac.support.RSACBeanLocatorImpl.getLocalBean(RSACBeanLocatorImpl.java:348)
      7. uk.org.ponder.rsac.support.RSACBeanLocatorImpl.getBean(RSACBeanLocatorImpl.java:379)
      8. uk.org.ponder.rsac.support.PerRequestInfo$1.locateBean(PerRequestInfo.java:49)
      8 frames
    14. uk.ac.cam
      ReasonableSakaiServlet.service
      1. uk.ac.cam.caret.sakai.rsf.servlet.ReasonableSakaiServlet.service(ReasonableSakaiServlet.java:65)
      1 frame
    15. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
      1 frame
    16. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    17. Sakai Component Manager
      RequestFilter.doFilter
      1. org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:565)
      1 frame
    18. Glassfish Core
      ApplicationDispatcher.forward
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      3. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
      4. org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:461)
      5. org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:364)
      6. org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
      6 frames
    19. org.sakaiproject.tool
      ActiveToolComponent$MyActiveTool.forward
      1. org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:475)
      1 frame
    20. sakai-portal-impl
      SkinnableCharonPortal.doGet
      1. org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1216)
      2. org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:188)
      3. org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:93)
      4. org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:768)
      4 frames
    21. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
      2 frames
    22. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    23. Sakai Component Manager
      RequestFilter.doFilter
      1. org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:616)
      1 frame
    24. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
      8 frames
    25. Embedded GlassFish Web
      ChannelSocket$SocketConnection.runIt
      1. org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
      2. org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
      3. org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
      4. org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
      5. org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
      5 frames
    26. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      1 frame
    27. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame