RE: HSSFR4 ss_open not working when ran in batch -- RPG400-L

Thank you, Peter. You pointed me in the direction I needed. Even though debug was showing proper data in my parameters, the submission was submitting garbage (140 character file name instead of the desired 256).

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Peter Dow
Sent: Thursday, May 21, 2020 2:16 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: [EXTERNAL] Re: HSSFR4 ss_open not working when ran in batch

Hi Jason,

Now is when we ask if the path and file name are parameters, how the batch job was submitted, how the fields are defined, etc.

When you submit a job to batch with a simple "CALL MyPgm PARMS(x y z)", if x y and z are character fields, they are passed as char(32). Numeric fields are passed as packed decimal 15.5. The command processor has to make some assumptions because you don't have any way to define those parameters on a simple call.

That's why it's recommended that you create a command with the parameters defined, then submit a call where the command is "MyCmd
p1(x) p2(y) p3(z)"

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx> pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /

On 5/21/2020 11:58 AM, Jason Pennybacker wrote:

Silly me (should have known to provide second level) and this is really weird. The folder path and file name are the same interactively and via batch. However, in batch, it is cut off (see below). The variable that contains the path and file name are not cut off.

Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure SS_OPEN in program POI36/HSSFR4 received
Java exception "java.io.FileNotFoundException: /IT
Ops/Data_Updates/Mulehide_Products/Replacement_Cost/MHP Pricing E" when
calling method "<init>" with signature "(Ljava.lang.String;)V" in class
"java.io.FileInputStream".
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 RPG prototype for the method, or change the Java method, so
that the return type and parameter types match. You can determine the signatures for all the methods in class XYZ using command QSH CMD('javap -s XYZ').

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Scott Klement
Sent: Thursday, May 21, 2020 1:22 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: [EXTERNAL] Re: HSSFR4 ss_open not working when ran in batch

Hi Jason,

The RNX0301 error should have a lot more detail than you've provided. Can you provide the 2nd level text that you receive in the job log? The entire message will all data would be helpful. Within this detail should be information about the Java exception that's occurring. As it stands, all we know is that some sort of exception is occurring, we don't know what it is.

-SK

On 5/21/2020 11:38 AM, Jason Pennybacker wrote:

I have a program that reads and processes an xlsx spreadsheet on a V7R2 system. Works great interactively but gets an exception when ran in batch. All there is in the job log after starting the JVM is the below escape message.

Any ideas would be greatly appreciated.

Jason

---------------------------------------------------------------------
-
------------------------------------------------------------

RNX0301 Escape 50 05/21/20 09:04:07.916633 QRNXIE QSYS *STMT HSSFR4 POI36 *STMT
From module . . . . . . . . : QRNXMSG
From procedure . . . . . . : SignalException
Statement . . . . . . . . . : 21
To module . . . . . . . . . : HSSFR4
To procedure . . . . . . . : SS_OPEN
Statement . . . . . . . . . : 189900
Thread . . . . : 00000627
Message . . . . : Java exception received when calling Java method.

Program logic is:

SetJavaEnvironment();

ss_begin_object_group(100);

book = ss_open((%Trim(myFile));
If book = *null;

ReturnValue = UnableToOpenFile;

Else;

// do some stuff

EndIf;

ss_end_object_group();

--
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://scanmail.trustwave.com/?c=6618&d=7NPG3ganFYX-5KeGyZcULDnR_O53E
sYy9ACwvDw4xQ&u=https%3a%2f%2flists%2emidrange%2ecom%2fmailman%2flisti
nfo%2frpg400-l or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://scanmail.trustwave.com/?c=6618&d=7NPG3ganFYX-5KeGyZcULDnR_O53E
sYy9FLm7D1vng&u=https%3a%2f%2farchive%2emidrange%2ecom%2frpg400-l

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support
http://scanmail.trustwave.com/?c=6618&d=7NPG3ganFYX-5KeGyZcULDnR_O53Es
Yy9FLk628-yg&u=http%3a%2f%2fmidrange%2ecom by shopping at
http://scanmail.trustwave.com/?c=6618&d=7NPG3ganFYX-5KeGyZcULDnR_O53Es
Yy9FHgu2g9zQ&u=http%3a%2f%2famazon%2ecom with our affiliate link:
https://scanmail.trustwave.com/?c=6618&d=7NPG3ganFYX-5KeGyZcULDnR_O53E
sYy9AbjuDZjmg&u=https%3a%2f%2famazon%2emidrange%2ecom

--
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://scanmail.trustwave.com/?c=6618&d=7NPG3ganFYX-5KeGyZcULDnR_O53EsYy9ACwvDw4xQ&u=https%3a%2f%2flists%2emidrange%2ecom%2fmailman%2flistinfo%2frpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://scanmail.trustwave.com/?c=6618&d=7NPG3ganFYX-5KeGyZcULDnR_O53EsYy9FLm7D1vng&u=https%3a%2f%2farchive%2emidrange%2ecom%2frpg400-l

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support http://scanmail.trustwave.com/?c=6618&d=7NPG3ganFYX-5KeGyZcULDnR_O53EsYy9FLk628-yg&u=http%3a%2f%2fmidrange%2ecom by shopping at http://scanmail.trustwave.com/?c=6618&d=7NPG3ganFYX-5KeGyZcULDnR_O53EsYy9FHgu2g9zQ&u=http%3a%2f%2famazon%2ecom with our affiliate link: https://scanmail.trustwave.com/?c=6618&d=7NPG3ganFYX-5KeGyZcULDnR_O53EsYy9AbjuDZjmg&u=https%3a%2f%2famazon%2emidrange%2ecom