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



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


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.