Re: POI error when calling dispose method in class org.apache.poi.xssf.streaming.SXSSFWorkbook

As a test I granted *ALLOBJ authority to this user and the problem with
running the 'dispose' method stopped.

So for some reason the temporary files being created by the JVM are not
able to be deleted by the user that submitted the job without additional
authority.

What I can't work out is why this has only started last week ?

Is this a JVM issue and therefore I could open a PMR or is this a java
class issue and outside IBM support ?

Thanks for any suggestions.

Don Brown




From: "Don Brown via MIDRANGE-L" <midrange-l@xxxxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: "Don Brown" <DBrown@xxxxxxxxxx>
Date: 14/10/2019 08:34 AM
Subject: Re: POI error when calling dispose method in class
org.apache.poi.xssf.streaming.SXSSFWorkbook
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>



Where does java store it's work files ?

We are using the streaming classes with POI as the resulting spreadsheets
can be quite large and this uses disk as opposed to memory for storage.

The problem is we have recently started receiving errors when cleaning up
the work files using the 'dispose' method.

The source for this method did not shed any light on where the files are
so I am presuming this is part of the JVM ?

This is what the dispose method does;

/**
* Dispose of temporary files backing this workbook on disk.
* Calling this method will render the workbook unusable.
* @return true if all temporary files were deleted successfully.
*/
public boolean dispose()
{
boolean success = true;
for (SXSSFSheet sheet : _sxFromXHash.keySet())
{
try {
success = sheet.dispose() && success;
} catch (IOException e) {
logger.log(POILogger.WARN, e);
success = false;
}
}
return success;
}



Don Brown




From: "Don Brown via MIDRANGE-L" <midrange-l@xxxxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: "Don Brown" <DBrown@xxxxxxxxxx>
Date: 11/10/2019 03:13 PM
Subject: POI error when calling dispose method in class
org.apache.poi.xssf.streaming.SXSSFWorkbook
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>



We have a process that is using the POI classes to create Excel
spreadsheets which has today started to end abnormally.

The specific error is when calling the java class
SXSSF_Workbook_Class:'dispose'

I have looked through the java dump files but nothing is jumping out at me


as to the reason.

This class as I understand it will clean up work files etcetera used in
the spreadsheet creation process.

I am hoping someone else may have come across this error ?

The error from the joblog includes;

MCH6801 Object domain or storage protection error for offset
X'0000000000000004' in object LVY_SUM
Cause . . . . . : A program tried to use a blocked instruction, access a



system domain object, or make invalid use of a protected page. The
violation
type is 4.

04-implicit process space for activation group-based heap storage.

X'800000000000000000000406C0000004' is a pointer to the storage for a
protection error or TESTPTA violation for a space pointer. Some violations



may be suppressed at low system security levels.

The Java Virtual Machine has ended.
Java Virtual Machine 1 has ended because of reason 2.

02- A Java program called the java.lang.System.exit method with a non zero


status code of 255.

Java exception received when calling Java method.
RPG procedure DISPOSE_WO in program XAPSW/XAPSRV005S
received Java exception "**UNKNOWN ERROR**" when calling method "dispose"

with signature "()Z" in class
"org.apache.poi.xssf.streaming.SXSSFWorkbook".

Thanks

Don Brown



______________________________________________________________________
This email has been scanned for computer viruses. Although MSD has taken
reasonable precautions to ensure no viruses are present in this email, MSD

cannot accept responsibility for any loss or damage arising from the use
of this email or attachments.
______________________________________________________________________