When using a xls document template a system error appears - Forum - Rollbase - Progress Community

When using a xls document template a system error appears

 Forum

When using a xls document template a system error appears

This question is answered

I have a very simple xls file using a template but when using the preview button I get a system error.

I'm on a private cloud version 3.1.4, and the jxl.jar file is on the tomcat.

Any ideas?

Error from main.log:

[2015-04-21 15:21:23,186] ===> Error in thread http-bio-8080-exec-316 at 04/21/2015 03:21 PM
[2015-04-21 15:21:23,186] java.lang.ArrayIndexOutOfBoundsException
	at java.lang.System.arraycopy(Native Method)
	at jxl.biff.StringHelper.getBytes(StringHelper.java:127)
	at jxl.write.biff.WriteAccessRecord.<init>(WriteAccessRecord.java:59)
	at jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:726)
	at com.rb.core.services.template.impl.XLSParser.parseXLS(XLSParser.java:124)
	at com.rb.core.services.template.impl.XLSParser.parse(XLSParser.java:43)
	at com.rb.core.services.template.a499.process(a499.java:66)
	at com.rb.core.logics.servlet.TemplateServlet.doGet(TemplateServlet.java:105)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:744)

Verified Answer
  • Hi,
     
    Jxl version 2.6.12 is having this problem. Please downgrade the jxl to version 2.6.9 to resolve this problem.
     
    Thanks and Regards
    Pradeep
     
    From: Aede Hoekstra [mailto:bounce-aehoekstravanmeijelnl@community.progress.com]
    Sent: Wednesday, April 22, 2015 3:15 PM
    To: TU.Rollbase@community.progress.com
    Subject: RE: [Technical Users - Rollbase] When using a xls document template a system error appears
     

    Flag this post as spam/abuse.

All Replies
  • Hello,

    What directory did you put the .jar file? The document states that it should be put in the Progress\Rollbase\Pas_Instance\common\ directory. Do a restart afterwards it might help.

    Thank you,
    Gian
  • Hi,
     
    Can you please provide the application xml and template file. We will try to reproduce at our end and will see if we can do some work around by fixing the template file.
     
    Thanks and Regards,
    Pradeep
     
    From: Gian Torralba [mailto:bounce-gtorralb@community.progress.com]
    Sent: Tuesday, April 21, 2015 8:52 PM
    To: TU.Rollbase@community.progress.com
    Subject: RE: [Technical Users - Rollbase] When using a xls document template a system error appears
     
    Reply by Gian Torralba
    Hello,

    What directory did you put the .jar file? The document states that it should be put in the Progress\Rollbase\Pas_Instance\common\ directory. Do a restart afterwards it might help.

    Thank you,
    Gian
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

  • Hi Gian,

    The file is currently placed in the /tomcat7/lib directory. (I'm on linux)

    This is the same location as for the other third party software we're using.

  • Hi Pradeep,

    I can provide you with the xls template, but it only contains three fields of an object and a header.

    You can try to reproduce this in the following way:

    1. Go to an object definition

    2. Create a "New Document Template"

    3. Upload an xls with a template field of the object.

    4. Save the template

    5. Open the template and press the "Preview" button

    6. Select a object instance in the overview

    Result the error appears.

    Note: if I save the xls as csv, the preview works fine.

  • Hi,
     
    Jxl version 2.6.12 is having this problem. Please downgrade the jxl to version 2.6.9 to resolve this problem.
     
    Thanks and Regards
    Pradeep
     
    From: Aede Hoekstra [mailto:bounce-aehoekstravanmeijelnl@community.progress.com]
    Sent: Wednesday, April 22, 2015 3:15 PM
    To: TU.Rollbase@community.progress.com
    Subject: RE: [Technical Users - Rollbase] When using a xls document template a system error appears
     

    Flag this post as spam/abuse.

  • Hello,

    Are you talking about the issue on the Preview functionality only? Can you still save the document template and do an XLS import? Am I correct?

    Thank you,
    Gian
  • Please downgrade the jxl library to 2.6.9