Re: HSSFR4 utiities

After a PTF, sometimes people do an IPL.
Often after an IPL one has to do a MD '/QNTC/MyServer' to get to that
server for the first time after that IPL. Can you do a WRKLNK
'/QNTC/MyServer/*' and see the shares on that target?

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Mohammad Tanveer
Sent: Tuesday, July 23, 2019 5:34 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: HSSFR4 utiities

CAUTION: This email originated from outside of the organization. Do not
click links or open attachments unless you recognize the sender and know
the content is safe.


The only change happen on as/400 over the weekend was that a PTF was
applied but IBM says everything is fine with PTF.

On Tue, Jul 23, 2019 at 4:32 PM Mohammad Tanveer <surgum@xxxxxxxxx> wrote:

No because user can process the file again after few retries. Files are
on QNTC.

On Tue, Jul 23, 2019 at 2:39 PM Scott Klement
<rpg400-l@xxxxxxxxxxxxxxxx>
wrote:

The error message seems to be saying that the file isn't a valid
Excel workbook. (It references OLE2 stream, which would be a .XLS
file, or OOXML which would be .XLSX... it says it is neither of these
things.)

Could that be what is happening? A bad file?


On 7/23/2019 10:56 AM, Mohammad Tanveer wrote:

Scott/RPG team,

We have been using HSSFR4 utiities for a long time without any
problem

and

all of a sudden we see following errors intermittently meaning

sometime

it works sometimes it doesn't
...
Message ID . . . . . . : RNX0301
Date sent . . . . . . : 07/23/19 Time sent . . . . . . : 10:21:37

Message . . . . : Java exception received when calling Java method.

Cause . . . . . : RPG procedure SS_OPEN in program USERUL/HSSFR4

received

Java exception "java.lang.IllegalArgumentException: Your
InputStream was neither an OLE2 stream, nor an OOXML stream" when
calling method

"create"

with signature
"(Ljava.io.InputStream;)Lorg.apache.poi.ss.usermodel.Workbook;" in
class "org.apache.poi.ss.usermodel.WorkbookFactory".
Recovery . . . : Contact the person responsible for program
maintenance

t

determine the cause of the problem.
Technical description . . . . . . . . : If the exception indicates
that

th

Java class was not found, ensure the class for the method is in the

class

path. If the exception indicates that the Java method was not
found,

check

10:24:04 AM

Message ID . . . . . . : RNX0301
Date sent . . . . . . : 07/23/19 Time sent . . . . . . : 10:32:37

Message . . . . : Java exception received when calling Java method.

Cause . . . . . : RPG procedure SS_OPEN in program USERUL/HSSFR4

received

Java exception "java.io.IOException: System call error number 3004.■"

when

calling method "create" with signature
"(Ljava.io.InputStream;)Lorg.apache.poi.ss.usermodel.Workbook;" in
class "org.apache.poi.ss.usermodel.WorkbookFactory".
Recovery . . . : Contact the person responsible for program
maintenance

to

determine the cause of the problem.
Technical description . . . . . . . . : If the exception indicates
that

the

Java class was not found, ensure the class for the method is in the

class

path. If the exception indicates that the Java method was not
found,

check

the method name and signature. If the signature is not correct,
change

the

Regards

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post
a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-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 RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-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 RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-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