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



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=pcfG3tnTkVZswGuGzUQxgbqtZ0zUq6kmtp3-6KLo6A&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=pcfG3tnTkVZswGuGzUQxgbqtZ0zUq6kmts-ouKO_sw&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=pcfG3tnTkVZswGuGzUQxgbqtZ0zUq6kmts-qv_Hu5w&u=http%3a%2f%2fmidrange%2ecom by shopping at http://scanmail.trustwave.com/?c=6618&d=pcfG3tnTkVZswGuGzUQxgbqtZ0zUq6kmtsyu7_bt4A&u=http%3a%2f%2famazon%2ecom with our affiliate link: https://scanmail.trustwave.com/?c=6618&d=pcfG3tnTkVZswGuGzUQxgbqtZ0zUq6kmtput7Kiztw&u=https%3a%2f%2famazon%2emidrange%2ecom


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.