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

Strange thing is that this only started happening last week.

I am the only person that installs updates on that system and none have
been installed recently and not even an IPL.

It is hard to determine but it appears that it was happening every time
for this user.

When another programmer ran it there was no error but they had more
authority which is why I just change the user's authority as they needed
the reports urgently. Now I want to understand the error and fix the
cause.

Thanks

Don Brown

From: "Colin Williams" <colinwilliams007@xxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Date: 17/10/2019 04:30 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>

im wondering if you are getting that error because the temporary files
have
already been deleted?
but you said it works fine if you change the authority, which suggests the
temporary files are being setup with the wrong authority somehow?

Does it have this issue every time, or sometimes?

On Mon, 14 Oct 2019 at 23:39, Don Brown via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Calling from RPG - as per below code snippet.

*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
* SXSSF_dispose
*
* Dispose of temporary files backing this workbook on disk.
* Calling this method will render the workbook unusable.
*
* Returns TRUE is all temporary files were delete successfully
*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
D SXSSF_dispose PR N extproc(*java
D : SXSSF_Workbook_Class
D :'dispose')

*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
* Dispose of workbook files
* Only required for Streaming Workbooks (new_SXSSFWorkbook)
* Programs should do SXSSF_dispose() as last step
*
*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
p Dispose_Workbook...
p B Export
d Dispose_Workbook...
d PI
*
d* Passed : None
d* Returned: None

/free

// Dispose of workbook work files
SXSSF_dispose( workbook );

/end-free

p dispose_workbook...
p E

Don Brown

From: "Colin Williams" <colinwilliams007@xxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Date: 15/10/2019 08:24 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>

Are you calling directly from java or from RPG?

On Mon, 14 Oct 2019 at 12:08, Don Brown via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

The temporary files are generated by the java classes. I do not know

where

they are saved and as such not able to check in a debug session.

They are not log files.

Sent from my iPhone

On 14 Oct 2019, at 18:44, Colin Williams

<colinwilliams007@xxxxxxxxx>

wrote:

Are you able to debug it? Put a break point in your code and see

what

authority these temporary files have...

Are the temporary files log files?

On Mon, 14 Oct 2019, 00:26 Don Brown via MIDRANGE-L, <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

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

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.

______________________________________________________________________

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing

list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our

affiliate

link: https://amazon.midrange.com

______________________________________________________________________

This email has been scanned by the Symantec Email Security.cloud

service.

______________________________________________________________________

______________________________________________________________________

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.

______________________________________________________________________

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing

list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our

affiliate

link: https://amazon.midrange.com

______________________________________________________________________

This email has been scanned by the Symantec Email Security.cloud

service.

______________________________________________________________________

______________________________________________________________________

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.

______________________________________________________________________

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our

affiliate

link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our

affiliate

link: https://amazon.midrange.com

______________________________________________________________________

This email has been scanned by the Symantec Email Security.cloud

service.

______________________________________________________________________

______________________________________________________________________
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.
______________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud

service.

______________________________________________________________________

______________________________________________________________________
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

this email or attachments.
______________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com