If you are running V7R3 or higher you can use the authority collection
services to figure out what authority is needed where. At V7R3 you can
track users, at V7R4 you can do it by object.
See:
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/rzarl/rzarlautco
l.htm
--
Jim Oberholtzer
Agile Technology Architects
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Don
Brown via MIDRANGE-L
Sent: Sunday, October 13, 2019 6:26 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Don Brown <DBrown@xxxxxxxxxx>
Subject: 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
midrange.com
