Hello Scott...
We finally managed to get it figured out after opening up a PMR with IBM
and going through the various log files (it was a long weekend).
The issue was arising because of a null value that was being passed in a
worksheet command...
SheetAGR = ss_NewSheet(xlsbook: 'AGR Items');
The program being built can potentially have several tabs depending on
various conditions that might arise. In one case, a conflict arose from
some bad user data that caused one sheet not to be created, but then the
program tried to populate a row value to the worksheet, resulting in a
null value being passed to the row command. That caused the program to
die at that moment with a JVM dump.
The biggest issue here was not that the program dumped, but how it dumped.
Because it immediately dropped out of the main RPGLE program, we had no
idea where in the code it was failing, so trying to debug was a major
pain. Even tossing into the debug didn't help because it wouldn't stop at
the point of failure to show "here's where I'm failing"...it just went
straight into a JVM dump and that was it. Got around it by setting the
standard IO options for STDOUT and STDERR and then parsing the output
there, plus the job display dumps. Once we found that we had enough data
to identify where the process was failing (generally) and approximately
when.
Have a good day.
Blake Moorcroft
Analyst/Programmer - Corporate
Farrow Group - Russell A. Farrow Limited
2001 Huron Church Road, PO Box 333, Windsor, Ontario N9A 2L6
Bus: 519-966-3003 ext. 566
blake.moorcroft@xxxxxxxxxx
From: Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Cc: Blake.Moorcroft@xxxxxxxxxx
Date: 05/10/2012 09:23 PM
Subject: Re: [WDSCI-L] XLSX development from RPGLE
Hi Blake,
I'm replying to the RPG list, since your question does not appear to be
related to WDSC/RDi/RDP. I've CCed you just in case you're not
subscribed to that list, but if you are subscribed, it'd help me out if
you'd send replies there.
I'm not familiar with the teraspace issues you describe. Can you
provide the actual text of the message? Or maybe some instructions on
how to reproduce the problem?
Thanks!
On 10/5/2012 11:51 AM, Blake.Moorcroft@xxxxxxxxxx wrote:
Hello all...
I'm wondering if anyone has taken the opportunity to build an Excel 2010
(xlsx extension) file using POI, as explained by Scott Klement.
We've been doing work with building spreadsheets directly and when doing
conventional "xls" files we don't have any problems. But when trying to
do the "xlsx" versions, we keep getting "terraspace" issues...I'm
guessing
some kind of method call with a null value but because the JVM drops out
of the calling program immediately, all I get is a core dump which is
next
to impossible to analyze. We've done all the regular checks to verify
classpath values and having the latest POI objects, but still no joy.
I'm
hoping someone else has tried this and run into similar problems so that
I
can get some pointers on what to look for or adjustments to make.
Have a good day.
Celebrating a Century of Excellence and once again named one of Canada's
50 Best Managed Companies!
This electronic message contains information from Russell A. Farrow
Limited, Russell A. Farrow (U.S.) Inc., canadaplus.com or RAF Express
Inc., that may be confidential or privileged. The information in this
electronic message is only for the use of the intended recipient.
Inappropriate disclosure, copying, distribution or other use of the
contents of this electronic message is strictly prohibited. If you have
received this electronic transmission in error, please notify the sender
immediately by return e-mail. Thank you.
midrange.com
