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();