Topic
  • 6 replies
  • Latest Post - ‏2018-12-13T00:13:55Z by Rapee
Rapee
Rapee
4 Posts

Pinned topic create excel POI/HSSF not working with AS400 V7R3

‏2018-12-09T18:24:54Z |

Hi,

 

I have been using Scott utility program to create excel. We did machine upgrade from V7R2 to V7R3 and all my programs that use this utility is blowing up. 

Below are the error messages. POI utility that I use is a very old version. It's the one that work for excel 97-2003 version.  

Need help desperately.

Java Virtual Machine is IBM Technology for Java.  PID(1041)               
 Symbol resolution failed for PASE for i module                            
   /usr/lib/libpthreads.a(shr_xpg5.o).                                     
 Symbol __setjmp (number 62) not exported from dependent PASE for i module 
   /usr/lib/libc.a(shr.o).                                                 
 Internal system error.  Error code is .                                   
 Error loading PASE for i program                                          
   /QOpenSys/QIBM/ProdData/JavaVM/jdk80/32bit/jre/lib/ppc/jvmStartPase.    
   See previous messages.                                                  
 Pointer not set for location referenced.                                  
 Pointer not set for location referenced.                                  
 Java exception received when calling Java method.                         

  • JonParis
    JonParis
    331 Posts

    Re: create excel POI/HSSF not working with AS400 V7R3

    ‏2018-12-09T18:50:12Z  

    You'll probably get a faster response on Scott's FTP list - access it from his web site.

  • Rapee
    Rapee
    4 Posts

    Re: create excel POI/HSSF not working with AS400 V7R3

    ‏2018-12-09T19:15:16Z  
    • JonParis
    • ‏2018-12-09T18:50:12Z

    You'll probably get a faster response on Scott's FTP list - access it from his web site.

    Thank you very much. Do you know what is a link to his website? 

     

    updated. I sent my question to ftpapi@lists.scottklement.com. I hope it's a right one.

    Updated on 2018-12-09T19:27:19Z at 2018-12-09T19:27:19Z by Rapee
  • JonParis
    JonParis
    331 Posts

    Re: create excel POI/HSSF not working with AS400 V7R3

    ‏2018-12-09T22:04:29Z  
    • Rapee
    • ‏2018-12-09T19:15:16Z

    Thank you very much. Do you know what is a link to his website? 

     

    updated. I sent my question to ftpapi@lists.scottklement.com. I hope it's a right one.

    Yes - that's the list.

     

    Scott's site is scott.klement.com

     

     

  • scott_klement
    scott_klement
    304 Posts

    Re: create excel POI/HSSF not working with AS400 V7R3

    ‏2018-12-11T21:27:43Z  
    • JonParis
    • ‏2018-12-09T22:04:29Z

    Yes - that's the list.

     

    Scott's site is scott.klement.com

     

     

    These errors have nothing to do with POI.  They are telling you that part of the Java environment is screwed up.  An IBM program called "jvmStartPase" is encountering an error that it can't find a routine in the pthreads library.  This is all IBM code part of the Java environment in PASE.

  • Rapee
    Rapee
    4 Posts

    Re: create excel POI/HSSF not working with AS400 V7R3

    ‏2018-12-12T17:52:41Z  

    These errors have nothing to do with POI.  They are telling you that part of the Java environment is screwed up.  An IBM program called "jvmStartPase" is encountering an error that it can't find a routine in the pthreads library.  This is all IBM code part of the Java environment in PASE.

    Hello Scott

    Thank you for reaching out, Can you please advise which direction I should head in to get some help on this. Any guidance would be greatly appreciated, We have been using your product for over 15 years and do not want to go in other directions. Should I contact IBM? I'm not familiar with Java to understand or even try to see what the issue is.

    We upgraded our machine from V7R2 to V7R3 and the new machine has. We went from Power 6 to Power 9.

    On the original Machine we had Java 6,7,8

    On the new machine we only have Java 7,8 ( 6 is no longer supported and cannot be installed)

    We were using your service program which used POI-2.5.1-Final-20040804.jar

    Any direction of help would be greatly appreciated. We have hundreds of clients waiting for their reports since Sunday.

    We can also hire your support services through Profound if its offered.

    Regards

    Rapee K.

     

     

  • Rapee
    Rapee
    4 Posts

    Re: create excel POI/HSSF not working with AS400 V7R3

    ‏2018-12-13T00:13:55Z  
    • Rapee
    • ‏2018-12-12T17:52:41Z

    Hello Scott

    Thank you for reaching out, Can you please advise which direction I should head in to get some help on this. Any guidance would be greatly appreciated, We have been using your product for over 15 years and do not want to go in other directions. Should I contact IBM? I'm not familiar with Java to understand or even try to see what the issue is.

    We upgraded our machine from V7R2 to V7R3 and the new machine has. We went from Power 6 to Power 9.

    On the original Machine we had Java 6,7,8

    On the new machine we only have Java 7,8 ( 6 is no longer supported and cannot be installed)

    We were using your service program which used POI-2.5.1-Final-20040804.jar

    Any direction of help would be greatly appreciated. We have hundreds of clients waiting for their reports since Sunday.

    We can also hire your support services through Profound if its offered.

    Regards

    Rapee K.

     

     

    Hello Scott

    We want to thank you for directing in the right direction, We contacted IBM and they had to reinstall Java.


    All Good Now. !!!!!