When using a xls document template a system error appears

Posted by Aede Hoekstra on 21-Apr-2015 08:57

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)

Rollbase - Forum
Posted by Pradeep Kagithalagudem on 23-Apr-2015 02:33

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
 
[collapse]
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
 
Reply by Aede Hoekstra

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

All Replies

Posted by Gian Torralba on 21-Apr-2015 10:20

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

Posted by Pradeep Kagithalagudem on 22-Apr-2015 02:01

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
 
[collapse]
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.

[/collapse]

Posted by Aede Hoekstra on 22-Apr-2015 02:17

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.

Posted by Aede Hoekstra on 22-Apr-2015 03:01

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.

Posted by Aede Hoekstra on 22-Apr-2015 04:44

Posted by Pradeep Kagithalagudem on 23-Apr-2015 02:33

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
 
[collapse]
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.

[/collapse]

Posted by Gian Torralba on 24-Apr-2015 07:14

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

Posted by Anoop Premachandran on 24-Apr-2015 07:52

Please downgrade the jxl library to 2.6.9

This thread is closed