Re: Some hssfr4 spreadsheet programs crashing on ss_open().

I'll offer up my 2 cents here. I tried to install Zend on
one of our backup systems that already had HSSF installed
and it just cratered the whole thing. So Buck is on the right
track. I'm pretty sure the Zend install did it. Only way out is
to reinstall all the HSSF stuff and put it in a separate directory
you know is safe. I use this to be sure and it runs before all
of our HSSF jobs. Note the locations.

ADDENVVAR ENVVAR(CLASSPATH) +
VALUE('/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-20091214.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') +
LEVEL(*JOB) +
REPLACE(*YES)
ENDPGM

Bill Roehmer
Senior Pgmr/Analyst
The C.D. Hartnett Company

817 594-3813 ext. 1631


"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments
accompanying it) contain confidential information belonging to the sender.
The information is intended only for the use of the intended recipient.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution or the taking of any action in reliance
on the contents of the information is strictly prohibited. Any
unauthorized interception of this transmission is illegal under the law.
If you have received this transmission in error, please promptly notify
the sender by reply e-mail, and then destroy all copies of the
transmission."






From: John Rusling <jrusling@xxxxxxxxxxxxxxxxxxx>
To: "rpg400-l@xxxxxxxxxxxx" <rpg400-l@xxxxxxxxxxxx>
Date: 04/17/2015 09:13 AM
Subject: Some hssfr4 spreadsheet programs crashing on ss_open().
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



Our rpg spreadsdheet programs that use ss_ope4n() started crashing
recently.
We have not changed anything/settings on our system, nor put on
any ptfs lately.

A 3rd party vendor has, however, upgraded zend server and possibly apache
on our
iseries. It's worth mentioning that the 3rd party software also uses POI
to
populate spreadsheets. Also, we really do not know what all they did on
our iseries.

I've stepped thru the affected programs but that sheds no light on why
they are crashing.
'Unable to open workbook!'

Only programs that open a workbook are affected, the programs that create
new spreadsheets
are still running just fine.

The java error message i've pasted below.

Any help, tips or direction would be very much appreciated??

Thanks,

John


Java exception received when calling Java method.

Message ID . . . . . . : RNX0301 Severity . . . . . . . : 50
Message type . . . . . : Escape
Date sent . . . . . . : 04/17/15 Time sent . . . . . . : 09:05:23


Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure SS_OPEN in program POI36/HSSFR4 received

Java exception "java.lang.NoSuchMethodError:
org/apache/poi/poifs/filesystem/POIFSFileSystem.hasPOIFSHeader(Ljava/io"

when calling method "create" with signature
"(Ljava.io.InputStream;)Lorg.apache.poi.ss.usermodel.Workbook;" in class

"org.apache.poi.ss.usermodel.WorkbookFactory".
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').