Re: HSSFR4 ss_open not working when ran in batch

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

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