Loading ...
Sorry, an error occurred while loading the content.
 

Error while running XLPARSE2/XLSCONVERT

Expand Messages
  • ewart.desouza@sandvik.com
    Hello all, I get the following error message while running the above command after installing XLPARSE2. Object XLSCOLS01 in library QTEMP not found. Object
    Message 1 of 64 , Aug 1, 2011
      Hello all,

      I get the following error message while running the above command after installing XLPARSE2.

      Object XLSCOLS01 in library QTEMP not found.                              
      Object XLSCOLS01 in QTEMP type *FILE created.                            
      1 objects duplicated.                                                    
      Member XLSCOLS file XLSCOLS in QTEMP cleared.                            
      JVM properties were loaded from a properties file.                        
      Java Virtual Machine is IBM Technology for Java.  PID(127862)            
      JVM properties were loaded from a properties file.                        
      Java exception received when calling Java method.                        
      Error occcured while parsing spreadsheet after cell (0,0) in *Unknown*.  
      Parsing of spreadsheet failed. See joblog for messages                    
      Function check. CPF9897 unmonitored by XLSCONVERT at statement 0000000798,
        instruction X'0000'.                                                    
      The call to *LIBL/XLSCONV_6 ended in error (C G D F).                    
      The call to *LIBL/XLSCONV_6 ended in error (C G D F).                    



                              Additional Message Information                        
                                                                                   
      Message ID . . . . . . :   RNX0301                                            
      Date sent  . . . . . . :   11/08/01      Time sent  . . . . . . :   15:35:48  
                                                                                   
      Message . . . . :   Java exception received when calling Java method.        
                                                                                   
      Cause . . . . . :   RPG procedure XLPARSE_WO in program XLPARSE2/XLPARSER4    
        received Java exception "java.lang.NoSuchMethodError:                      
        org/apache/poi/hssf/record/BOFRecord.getType()I" when calling method        
        "parse201003" with signature "([B)V" in class                              
        "com.iseriesnetwork.clubtech.xlparse.ParseSheet".                          
      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  

      Note: I ran the STRREXPRC SRCMBR(INSTALL) SRCFILE(XLPARSE2/QREXSRC) from my user id that is not QSECOFR. The RSTLIB however was done with a QSECOFR profile.

      We are on V6R1.

      Thanks & best regards
      Ewart

      This e-mail is confidential and it is intended only for the addressees. Any review, dissemination, distribution, or copying of this message by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error, kindly notify us immediately by telephone or e-mail and delete the message from your system. The sender does not accept liability for any errors or omissions in the contents of this message which may arise as a result of the e-mail transmission.

    • Giovanni B. Perotti
      Look at the installation instructions!!! http://www.easy400.net/xlparse2/html/page1.htm#3 * Remove any POI-related and any XLPARSE-related objects from
      Message 64 of 64 , Aug 1, 2011

        Look at the installation instructions!!!

            http://www.easy400.net/xlparse2/html/page1.htm#3

         

        ·  Remove any POI-related and any XLPARSE-related objects from /QIBM/UserData/Java400/ext. Adding such Java objects to this directory is a bad practice and should be discontinued.

         

        Giovanni

         

         


        Da: Easy400Group@yahoogroups.com [mailto: Easy400Group@yahoogroups.com ] Per conto di ewart.desouza@...
        Inviato: lunedì 1 agosto 2011 12:16
        A: Easy400Group@yahoogroups.com
        Oggetto: [Easy400Group] Error while running XLPARSE2/XLSCONVERT

         

         

        Hello all,

        I get the following error message while running the above command after installing XLPARSE2.

        Object XLSCOLS01 in library QTEMP not found.                              
        Object XLSCOLS01 in QTEMP type *FILE created.                            
        1 objects duplicated.                                                    
        Member XLSCOLS file XLSCOLS in QTEMP cleared.                            
        JVM properties were loaded from a properties file.                        
        Java Virtual Machine is IBM Technology for Java.  PID(127862)            
        JVM properties were loaded from a properties file.                        
        Java exception received when calling Java method.                        
        Error occcured while parsing spreadsheet after cell (0,0) in *Unknown*.  
        Parsing of spreadsheet failed. See joblog for messages                    
        Function check. CPF9897 unmonitored by XLSCONVERT at statement 0000000798,
          instruction X'0000'.                                                    
        The call to *LIBL/XLSCONV_6 ended in error (C G D F).                    
        The call to *LIBL/XLSCONV_6 ended in error (C G D F).                    



                                Additional Message Information                        
                                                                                     
        Message ID . . . . . . :   RNX0301                                            
        Date sent  . . . . . . :   11/08/01      Time sent  . . . . . . :   15:35:48  
                                                                                     
        Message . . . . :   Java exception received when calling Java method.        
                                                                                     
        Cause . . . . . :   RPG procedure XLPARSE_WO in program XLPARSE2/XLPARSER4    
          received Java exception "java.lang.NoSuchMethodError:                      
          org/apache/poi/hssf/record/BOFRecord.getType()I" when calling method        
          "parse201003" with signature "([B)V" in class                              
          "com.iseriesnetwork.clubtech.xlparse.ParseSheet".                          
        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  

        Note: I ran the STRREXPRC SRCMBR(INSTALL) SRCFILE(XLPARSE2/QREXSRC) from my user id that is not QSECOFR. The RSTLIB however was done with a QSECOFR profile.

        We are on V6R1.

        Thanks & best regards
        Ewart

        This e-mail is confidential and it is intended only for the addressees. Any review, dissemination, distribution, or copying of this message by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error, kindly notify us immediately by telephone or e-mail and delete the message from your system. The sender does not accept liability for any errors or omissions in the contents of this message which may arise as a result of the e-mail transmission.

      Your message has been successfully submitted and would be delivered to recipients shortly.