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

TABLEXLS error

Expand Messages
  • josephr26
    We are receiving the following error when running TABLEXLS: Additional Message Information Message ID . . . . . . : MCH4431 Severity . . . . . . . :
    Message 1 of 13 , Apr 18, 2013
    • 0 Attachment
      We are receiving the following error when running TABLEXLS:
      Additional Message Information

      Message ID . . . . . . : MCH4431 Severity . . . . . . . : 40
      Message type . . . . . : Escape
      Date sent . . . . . . : 04/18/13 Time sent . . . . . . : 10:11:24

      Message . . . . : Program signature violation.
      Cause . . . . . : The source program P5385 specifies a signature
      X'C8E2E2C6C3C7C9E7404040A5F14BF0F2' which is not supported by service
      program HSSFCGIX.
      Recovery . . . : The service program interface has changed. Re-bind source
      program P5385.






      Bottom
      Press Enter to continue.

      F3=Exit F6=Print F9=Display message details F12=Cancel
      F21=Select assistance level
    • Giovanni B. Perotti
      DLTPGM HSSFCGIDTA/P5385 Giovanni B. Perotti Da: Easy400Group@yahoogroups.com [mailto:Easy400Group@yahoogroups.com] Per conto di josephr26 Inviato: giovedì 18
      Message 2 of 13 , Apr 18, 2013
      • 0 Attachment

        DLTPGM HSSFCGIDTA/P5385

         

        Giovanni B. Perotti

         

        Da: Easy400Group@yahoogroups.com [mailto:Easy400Group@yahoogroups.com] Per conto di josephr26
        Inviato: giovedì 18 aprile 2013 19:44
        A: Easy400Group@yahoogroups.com
        Oggetto: [Easy400Group] TABLEXLS error

         

         

        We are receiving the following error when running TABLEXLS:
        Additional Message Information

        Message ID . . . . . . : MCH4431 Severity . . . . . . . : 40
        Message type . . . . . : Escape
        Date sent . . . . . . : 04/18/13 Time sent . . . . . . : 10:11:24

        Message . . . . : Program signature violation.
        Cause . . . . . : The source program P5385 specifies a signature
        X'C8E2E2C6C3C7C9E7404040A5F14BF0F2' which is not supported by service
        program HSSFCGIX.
        Recovery . . . : The service program interface has changed. Re-bind source
        program P5385.






        Bottom
        Press Enter to continue.

        F3=Exit F6=Print F9=Display message details F12=Cancel
        F21=Select assistance level

      • josephr26
        Thank you, Giovanni.
        Message 3 of 13 , Apr 18, 2013
        • 0 Attachment
          Thank you, Giovanni.

          --- In Easy400Group@yahoogroups.com, "Giovanni B. Perotti" <gb_perotti@...> wrote:
          >
          > DLTPGM HSSFCGIDTA/P5385
          >
          >
          >
          > Giovanni B. Perotti
          >
          >
          >
          > Da: Easy400Group@yahoogroups.com [mailto:Easy400Group@yahoogroups.com] Per
          > conto di josephr26
          > Inviato: giovedì 18 aprile 2013 19:44
          > A: Easy400Group@yahoogroups.com
          > Oggetto: [Easy400Group] TABLEXLS error
          >
          >
          >
          >
          >
          > We are receiving the following error when running TABLEXLS:
          > Additional Message Information
          >
          > Message ID . . . . . . : MCH4431 Severity . . . . . . . : 40
          > Message type . . . . . : Escape
          > Date sent . . . . . . : 04/18/13 Time sent . . . . . . : 10:11:24
          >
          > Message . . . . : Program signature violation.
          > Cause . . . . . : The source program P5385 specifies a signature
          > X'C8E2E2C6C3C7C9E7404040A5F14BF0F2' which is not supported by service
          > program HSSFCGIX.
          > Recovery . . . : The service program interface has changed. Re-bind source
          > program P5385.
          >
          >
          >
          >
          >
          >
          > Bottom
          > Press Enter to continue.
          >
          > F3=Exit F6=Print F9=Display message details F12=Cancel
          > F21=Select assistance level
          >
        • Luis_Rodriguez_98
          Hi, Trying to run TABLEXLS. Keep getting the following Java error: FATAL ERROR in native method: Wrong method ID used to invoke a Java method
          Message 4 of 13 , May 9 1:17 PM
          • 0 Attachment
            Hi,

            Trying to run TABLEXLS. Keep getting the following Java error:

            FATAL ERROR in native method: Wrong method ID used to invoke a Java method
            java.lang.Throwable

            DSPERRS gives:
            Program status for error dated 2013-05-09-15.29.26

            Procedure name: XLSXGEN
            Program containing procedure: XLSXGEN
            Module containing procedure: XLSXGEN
            RPG IV src statement: 00257200
            RPG IV routine: getPrint

            Enviroment variables are:
            QIBM_RPG_JAVA_PROPERTIES
            '-Djava.version=1.5;-Djava.awt.headless=true;-Dos400.awt.native=true;'

            CLASSPATH
            '/hssfcgi/java/dom4j/dom4j-1.6.1.jar:/hssfcgi/java/
            poi3.6/poi-ooxml-schemas-3.6-20091214.jar:/hssfcgi/java/poi3.6/poi-ooxml-3.6-200
            91214.jar:/hssfcgi/java/poi3.6/poi-3.6-20091214.jar:/hssfcgi/java/xlparse3.6/xlp
            arse.jar:/hssfcgi/java/xmlbeans/jsr173_1.0_api.jar:/hssfcgi/java/xmlbeans/xbean.
            jar'

            Table has only 25 rows...

            Any ideas?

            Thanks,

            Luis Rodriguez
          • Luis_Rodriguez_98
            Sorry, forgot the command I m using: TABLEXLS FROMFILE(mylib/myfile) TOXLS( /home/temp/myexcel.xlsx ) PRTHDR(*DFT *NO) PRTORIENT(*LANDSCAPE) PRTSCALE(75)
            Message 5 of 13 , May 9 1:23 PM
            • 0 Attachment
              Sorry, forgot the command I'm using:

              TABLEXLS FROMFILE(mylib/myfile)
              TOXLS('/home/temp/myexcel.xlsx')
              PRTHDR(*DFT *NO)
              PRTORIENT(*LANDSCAPE)
              PRTSCALE(75)
              HDGCOLOR(GOLD)
              DOWNLOAD(*NO)


              --- In Easy400Group@yahoogroups.com, "Luis_Rodriguez_98" <luis_rodriguez_98@...> wrote:
              >
              > Hi,
              >
              > Trying to run TABLEXLS. Keep getting the following Java error:
              >
              > FATAL ERROR in native method: Wrong method ID used to invoke a Java method
              > java.lang.Throwable
              >
              > DSPERRS gives:
              > Program status for error dated 2013-05-09-15.29.26
              >
              > Procedure name: XLSXGEN
              > Program containing procedure: XLSXGEN
              > Module containing procedure: XLSXGEN
              > RPG IV src statement: 00257200
              > RPG IV routine: getPrint
              >
              > Enviroment variables are:
              > QIBM_RPG_JAVA_PROPERTIES
              > '-Djava.version=1.5;-Djava.awt.headless=true;-Dos400.awt.native=true;'
              >
              > CLASSPATH
              > '/hssfcgi/java/dom4j/dom4j-1.6.1.jar:/hssfcgi/java/
              > poi3.6/poi-ooxml-schemas-3.6-20091214.jar:/hssfcgi/java/poi3.6/poi-ooxml-3.6-200
              > 91214.jar:/hssfcgi/java/poi3.6/poi-3.6-20091214.jar:/hssfcgi/java/xlparse3.6/xlp
              > arse.jar:/hssfcgi/java/xmlbeans/jsr173_1.0_api.jar:/hssfcgi/java/xmlbeans/xbean.
              > jar'
              >
              > Table has only 25 rows...
              >
              > Any ideas?
              >
              > Thanks,
              >
              > Luis Rodriguez
              >
            • Luis_Rodriguez_98
              Additional info: Found it just happens when trying to generate a .xlsx. A .xls in the output works ok. We are on V5R3. Thanks in advance, Luis
              Message 6 of 13 , May 9 1:41 PM
              • 0 Attachment
                Additional info:

                Found it just happens when trying to generate a .xlsx. A .xls in the output works ok.
                We are on V5R3.

                Thanks in advance,

                Luis
                --- In Easy400Group@yahoogroups.com, "Luis_Rodriguez_98" <luis_rodriguez_98@...> wrote:
                >
                > Sorry, forgot the command I'm using:
                >
                > TABLEXLS FROMFILE(mylib/myfile)
                > TOXLS('/home/temp/myexcel.xlsx')
                > PRTHDR(*DFT *NO)
                > PRTORIENT(*LANDSCAPE)
                > PRTSCALE(75)
                > HDGCOLOR(GOLD)
                > DOWNLOAD(*NO)
                >
                >
                > --- In Easy400Group@yahoogroups.com, "Luis_Rodriguez_98" <luis_rodriguez_98@> wrote:
                > >
                > > Hi,
                > >
                > > Trying to run TABLEXLS. Keep getting the following Java error:
                > >
                > > FATAL ERROR in native method: Wrong method ID used to invoke a Java method
                > > java.lang.Throwable
                > >
                > > DSPERRS gives:
                > > Program status for error dated 2013-05-09-15.29.26
                > >
                > > Procedure name: XLSXGEN
                > > Program containing procedure: XLSXGEN
                > > Module containing procedure: XLSXGEN
                > > RPG IV src statement: 00257200
                > > RPG IV routine: getPrint
                > >
                > > Enviroment variables are:
                > > QIBM_RPG_JAVA_PROPERTIES
                > > '-Djava.version=1.5;-Djava.awt.headless=true;-Dos400.awt.native=true;'
                > >
                > > CLASSPATH
                > > '/hssfcgi/java/dom4j/dom4j-1.6.1.jar:/hssfcgi/java/
                > > poi3.6/poi-ooxml-schemas-3.6-20091214.jar:/hssfcgi/java/poi3.6/poi-ooxml-3.6-200
                > > 91214.jar:/hssfcgi/java/poi3.6/poi-3.6-20091214.jar:/hssfcgi/java/xlparse3.6/xlp
                > > arse.jar:/hssfcgi/java/xmlbeans/jsr173_1.0_api.jar:/hssfcgi/java/xmlbeans/xbean.
                > > jar'
                > >
                > > Table has only 25 rows...
                > >
                > > Any ideas?
                > >
                > > Thanks,
                > >
                > > Luis Rodriguez
                > >
                >
              • Giovanni B. Perotti
                Extension .XLSX is not supported on V5R3. You need V5R4 or subsequent. Did you read HSSFCGI prerequisites? Get to page
                Message 7 of 13 , May 9 2:25 PM
                • 0 Attachment

                  Extension .XLSX is not supported on V5R3. You need V5R4 or subsequent.

                  Did you read HSSFCGI prerequisites?

                  Get to page http://www.easy400.net/hssfcgi/html/page1.htm#2

                  Thank you!

                   

                  Giovanni B. Perotti

                  www.easy400.net - Free WEB utilities for IBM System i 

                  Contribute to site Easy400.net: http://www.easy400.net/easy400p/contribute.html

                   

                   

                   

                  Da: Easy400Group@yahoogroups.com [mailto:Easy400Group@yahoogroups.com] Per conto di Luis_Rodriguez_98
                  Inviato: giovedì 9 maggio 2013 22:41
                  A: Easy400Group@yahoogroups.com
                  Oggetto: [Easy400Group] Re: TABLEXLS error

                   

                   


                  Additional info:

                  Found it just happens when trying to generate a .xlsx. A .xls in the output works ok.
                  We are on V5R3.

                  Thanks in advance,

                  Luis

                  --- In Easy400Group@yahoogroups.com, "Luis_Rodriguez_98" <luis_rodriguez_98@...> wrote:
                  >
                  > Sorry, forgot the command I'm using:
                  >
                  > TABLEXLS FROMFILE(mylib/myfile)
                  > TOXLS('/home/temp/myexcel.xlsx')
                  > PRTHDR(*DFT *NO)
                  > PRTORIENT(*LANDSCAPE)
                  > PRTSCALE(75)
                  > HDGCOLOR(GOLD)
                  > DOWNLOAD(*NO)
                  >
                  >
                  > --- In Easy400Group@yahoogroups.com, "Luis_Rodriguez_98" <luis_rodriguez_98@> wrote:
                  > >
                  > > Hi,
                  > >
                  > > Trying to run TABLEXLS. Keep getting the following Java error:
                  > >
                  > > FATAL ERROR in native method: Wrong method ID used to invoke a Java method
                  > > java.lang.Throwable
                  > >
                  > > DSPERRS gives:
                  > > Program status for error dated 2013-05-09-15.29.26
                  > >
                  > > Procedure name: XLSXGEN
                  > > Program containing procedure: XLSXGEN
                  > > Module containing procedure: XLSXGEN
                  > > RPG IV src statement: 00257200
                  > > RPG IV routine: getPrint
                  > >
                  > > Enviroment variables are:
                  > > QIBM_RPG_JAVA_PROPERTIES
                  > > '-Djava.version=1.5;-Djava.awt.headless=true;-Dos400.awt.native=true;'
                  > >
                  > > CLASSPATH
                  > > '/hssfcgi/java/dom4j/dom4j-1.6.1.jar:/hssfcgi/java/
                  > > poi3.6/poi-ooxml-schemas-3.6-20091214.jar:/hssfcgi/java/poi3.6/poi-ooxml-3.6-200
                  > > 91214.jar:/hssfcgi/java/poi3.6/poi-3.6-20091214.jar:/hssfcgi/java/xlparse3.6/xlp
                  > > arse.jar:/hssfcgi/java/xmlbeans/jsr173_1.0_api.jar:/hssfcgi/java/xmlbeans/xbean.
                  > > jar'
                  > >
                  > > Table has only 25 rows...
                  > >
                  > > Any ideas?
                  > >
                  > > Thanks,
                  > >
                  > > Luis Rodriguez
                  > >
                  >

                • Luis_Rodriguez_98
                  Giovanni, My apologies. I did not read the prerequisites the last time I updated the software. I know that .xlsx was allowed in an older version (we are
                  Message 8 of 13 , May 10 6:41 AM
                  • 0 Attachment
                    Giovanni,

                    My apologies. I did not read the prerequisites the last time I updated the software. I know that .xlsx was allowed in an older version (we are running Java 1.5 in our V5R3 box). In fact, about a year ago I sent you a mail regarding the use of *LANDSCAPE in .xlsx, so at least at the time I was generating that kind of Excel files.

                    Sigh... I know we should be more current in our OS version but, sometimes, we have to do what we can with the cards management deals us...

                    Thanks again for your help.

                    Regards,
                    Luis Rodriguez


                    --- In Easy400Group@yahoogroups.com, "Giovanni B. Perotti" <gb_perotti@...> wrote:
                    >
                    > Extension .XLSX is not supported on V5R3. You need V5R4 or subsequent.
                    >
                    > Did you read HSSFCGI prerequisites?
                    >
                    > Get to page http://www.easy400.net/hssfcgi/html/page1.htm#2
                    >
                    > Thank you!
                    >
                    >
                    >
                    > Giovanni B. Perotti
                    >
                    > <http://www.easy400.net/> www.easy400.net - Free WEB utilities for IBM
                    > System i
                    >
                    > Contribute to site Easy400.net:
                    > http://www.easy400.net/easy400p/contribute.html
                    >
                    >
                    >
                    >
                    >
                    >
                    >
                    > Da: Easy400Group@yahoogroups.com [mailto:Easy400Group@yahoogroups.com] Per
                    > conto di Luis_Rodriguez_98
                    > Inviato: giovedì 9 maggio 2013 22:41
                    > A: Easy400Group@yahoogroups.com
                    > Oggetto: [Easy400Group] Re: TABLEXLS error
                    >
                    >
                    >
                    >
                    >
                    >
                    > Additional info:
                    >
                    > Found it just happens when trying to generate a .xlsx. A .xls in the output
                    > works ok.
                    > We are on V5R3.
                    >
                    > Thanks in advance,
                    >
                    > Luis
                    > --- In Easy400Group@yahoogroups.com <mailto:Easy400Group%40yahoogroups.com>
                    > , "Luis_Rodriguez_98" <luis_rodriguez_98@> wrote:
                    > >
                    > > Sorry, forgot the command I'm using:
                    > >
                    > > TABLEXLS FROMFILE(mylib/myfile)
                    > > TOXLS('/home/temp/myexcel.xlsx')
                    > > PRTHDR(*DFT *NO)
                    > > PRTORIENT(*LANDSCAPE)
                    > > PRTSCALE(75)
                    > > HDGCOLOR(GOLD)
                    > > DOWNLOAD(*NO)
                    > >
                    > >
                    > > --- In Easy400Group@yahoogroups.com
                    > <mailto:Easy400Group%40yahoogroups.com> , "Luis_Rodriguez_98"
                    > <luis_rodriguez_98@> wrote:
                    > > >
                    > > > Hi,
                    > > >
                    > > > Trying to run TABLEXLS. Keep getting the following Java error:
                    > > >
                    > > > FATAL ERROR in native method: Wrong method ID used to invoke a Java
                    > method
                    > > > java.lang.Throwable
                    > > >
                    > > > DSPERRS gives:
                    > > > Program status for error dated 2013-05-09-15.29.26
                    > > >
                    > > > Procedure name: XLSXGEN
                    > > > Program containing procedure: XLSXGEN
                    > > > Module containing procedure: XLSXGEN
                    > > > RPG IV src statement: 00257200
                    > > > RPG IV routine: getPrint
                    > > >
                    > > > Enviroment variables are:
                    > > > QIBM_RPG_JAVA_PROPERTIES
                    > > > '-Djava.version=1.5;-Djava.awt.headless=true;-Dos400.awt.native=true;'
                    > > >
                    > > > CLASSPATH
                    > > > '/hssfcgi/java/dom4j/dom4j-1.6.1.jar:/hssfcgi/java/
                    > > >
                    > poi3.6/poi-ooxml-schemas-3.6-20091214.jar:/hssfcgi/java/poi3.6/poi-ooxml-3.6
                    > -200
                    > > >
                    > 91214.jar:/hssfcgi/java/poi3.6/poi-3.6-20091214.jar:/hssfcgi/java/xlparse3.6
                    > /xlp
                    > > >
                    > arse.jar:/hssfcgi/java/xmlbeans/jsr173_1.0_api.jar:/hssfcgi/java/xmlbeans/xb
                    > ean.
                    > > > jar'
                    > > >
                    > > > Table has only 25 rows...
                    > > >
                    > > > Any ideas?
                    > > >
                    > > > Thanks,
                    > > >
                    > > > Luis Rodriguez
                    > > >
                    > >
                    >
                  Your message has been successfully submitted and would be delivered to recipients shortly.