Topic
  • No replies
SystemAdmin
SystemAdmin
123 Posts

Pinned topic output values Excel limitation

‏2011-07-21T09:32:56Z |
Hi!

With DVS, provided you have a complex enough BOM class (in my example 26 fields), a collection with a few items in the output will lead to an error when looking at the output values excel of the DVS simulation report.

And indeed, based on the attached rule project (and generating a simulation template...), there would be 11 times 26 columns = 286 columns for the output value.

I understand this is a limitation of Excel 2003... but you hit it very quickly when working with collections.
Is there any way to customize how IlrFusionExcel2003OutputWriter is working?
For instance to span a scenario result over multiple lines? The documentation gives good guidance on scenario providers but it looks like this output part is not meant to be extended/customized.

Emmanuel



20-Jul-2011 09:12:15 ilog.rules.teamserver.web.servlets.IlrTestingDownloadServlet outputMode
SEVERE: You have reached the maximum number of columns allowed in an Excel sheet.
Throwable occurred: ilog.rules.teamserver.model.IlrTestingException: You have reached the maximum number of columns allowed in an Excel sheet.
at ilog.rules.teamserver.web.servlets.IlrTestingDownloadServlet$ExcelOutputDataFileBean.generateExcelFile(IlrTestingDownloadServlet.java:232)
at ilog.rules.teamserver.web.servlets.IlrTestingDownloadServlet.outputMode(IlrTestingDownloadServlet.java:155)
at ilog.rules.teamserver.web.servlets.IlrTestingDownloadServlet.service(IlrTestingDownloadServlet.java:76)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at ilog.rules.teamserver.web.servlets.filter.IlrRemoteSessionFilter.doFilterInternal(IlrRemoteSessionFilter.java:90)
at ilog.rules.teamserver.web.servlets.filter.IlrRemoteSessionFilter.doFilter(IlrRemoteSessionFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
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.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:56)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:406)
at org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:47)
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.valves.AccessLogValve.invoke(AccessLogValve.java:567)
at org.apache.geronimo.tomcat.valve.ThreadCleanerValve.invoke(ThreadCleanerValve.java:40)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:735)
Caused by: ilog.rules.res.IlrLocalizedException: You have reached the maximum number of columns allowed in an Excel sheet.
at ilog.rules.res.util.dw.IlrFusionExcel2003OutputWriter.AddObject(IlrFusionExcel2003OutputWriter.java:474)
at ilog.rules.res.util.dw.IlrFusionExcel2003OutputWriter.AddObject(IlrFusionExcel2003OutputWriter.java:419)
at ilog.rules.res.util.dw.IlrFusionExcel2003OutputWriter.AddObject(IlrFusionExcel2003OutputWriter.java:419)
at ilog.rules.res.util.dw.IlrFusionExcel2003OutputWriter.AddObject(IlrFusionExcel2003OutputWriter.java:419)
at ilog.rules.res.util.dw.IlrFusionExcel2003OutputWriter.write(IlrFusionExcel2003OutputWriter.java:618)
at ilog.rules.teamserver.web.servlets.IlrTestingDownloadServlet$ExcelOutputDataFileBean.generateExcelFile(IlrTestingDownloadServlet.java:228)
... 29 more
20-Jul-2011 09:12:30 ilog.rules.teamserver.web.servlets.IlrTestingDownloadServlet outputMode
SEVERE: You have reached the maximum number of columns allowed in an Excel sheet.
Throwable occurred: ilog.rules.teamserver.model.IlrTestingException: You have reached the maximum number of columns allowed in an Excel sheet.
at ilog.rules.teamserver.web.servlets.IlrTestingDownloadServlet$ExcelOutputDataFileBean.generateExcelFile(IlrTestingDownloadServlet.java:232)
at ilog.rules.teamserver.web.servlets.IlrTestingDownloadServlet.outputMode(IlrTestingDownloadServlet.java:155)
at ilog.rules.teamserver.web.servlets.IlrTestingDownloadServlet.service(IlrTestingDownloadServlet.java:76)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at ilog.rules.teamserver.web.servlets.filter.IlrRemoteSessionFilter.doFilterInternal(IlrRemoteSessionFilter.java:90)
at ilog.rules.teamserver.web.servlets.filter.IlrRemoteSessionFilter.doFilter(IlrRemoteSessionFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
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.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:56)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:406)
at org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:47)
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.valves.AccessLogValve.invoke(AccessLogValve.java:567)
at org.apache.geronimo.tomcat.valve.ThreadCleanerValve.invoke(ThreadCleanerValve.java:40)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:735)
Caused by: ilog.rules.res.IlrLocalizedException: You have reached the maximum number of columns allowed in an Excel sheet.
at ilog.rules.res.IlrLocalizedException.<init>(IlrLocalizedException.java:61)
at ilog.rules.res.util.dw.IlrFusionExcel2003OutputWriter.AddObject(IlrFusionExcel2003OutputWriter.java:406)
at ilog.rules.res.util.dw.IlrFusionExcel2003OutputWriter.AddObject(IlrFusionExcel2003OutputWriter.java:419)
at ilog.rules.res.util.dw.IlrFusionExcel2003OutputWriter.AddObject(IlrFusionExcel2003OutputWriter.java:419)
at ilog.rules.res.util.dw.IlrFusionExcel2003OutputWriter.AddObject(IlrFusionExcel2003OutputWriter.java:419)
at ilog.rules.res.util.dw.IlrFusionExcel2003OutputWriter.write(IlrFusionExcel2003OutputWriter.java:618)
at ilog.rules.teamserver.web.servlets.IlrTestingDownloadServlet$ExcelOutputDataFileBean.generateExcelFile(IlrTestingDownloadServlet.java:228)
... 29 more