× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. October 2019

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


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 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.
______________________________________________________________________
--
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.
______________________________________________________________________

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.