Re: Error RNQ0202 HSSFR4 HSSF_GETSH

As an example, here's what my wrkenvvar classpath looks like for
3.6. It won't be the same as yours but the concept is the same and yours
should look similar depending on where you store the files:

Value . . . . . . . . . :
'/QIBM/UserData/Java400:/QIBM/USERDATA/POI/POI-3.6/
POI-3.6-20091214.JAR:/QIBM/USERDATA/POI/POI-3.6/POI-OOXML-3.6-20091214.JAR:/QIBM
/USERDATA/POI/POI-3.6/POI-OOXML-SCHEMAS-3.6-20091214.JAR:/QIBM/USERDATA/POI/POI-
3.6/POI-CONTRIB-3.6-20091214.JAR:/QIBM/USERDATA/POI/POI-3.6/POI-SCRATCHPAD-3.6-2
0091214.JAR:/QIBM/USERDATA/POI/POI-3.6/DOM4J-1.6.1.JAR:/QIBM/USERDATA/POI/POI-3.
6/JSR173_1.0_API.JAR:/QIBM/USERDATA/POI/POI-3.6/XBEAN.JAR:QIBM/Userdata/Java400/
Mail.jar'










From: broehmer@xxxxxxxxxxxxxxx
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 05/06/2016 11:32 AM
Subject: Re: Error RNQ0202 HSSFR4 HSSF_GETSH
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Just a thought:
1. your classpath for the JOB is not the same as your SYStem path.
Use WRKENVVAR and review both the job and the system. It will
reset after you sign off and the system environment statement will be
refreshed.
2. since you are using a CLP to change the environment classpath review it

after you
run it. Look for ":" for statement separations...if they are wrong the

path won't
be found.







From: pat <p.caroti@xxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Date: 05/06/2016 10:59 AM
Subject: Re: Error RNQ0202 HSSFR4 HSSF_GETSH
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Buck Calabro <kc2hiz@...> writes:

are my poi's ifs folder too old ?

If you are testing interactively, remember that once you start any JVM,
the JVM can not be stopped, restarted, or changed. That means if you
changed your environment, the JVM is using the old settings. If you
make any changes, sign off and back on so you get a new job and try

again.

I almost never test interactively - I SBMJOB all of my Java so that each
one lives in its own clean JVM.

Hi Thanks for you reply
i have either signoff and run sbmjob, but problem is not solved and its
always the same

any other idea ?

Thanks