10 Replies Latest reply: Feb 2, 2016 4:35 AM by Markus Blum RSS

    No rows for hierarchy 0FUNCT_LOC_HIER

    Markus Blum

      Dear experts!

       

      I have a question concerning the extraxt of the hierarchy 0FUNCT_LOC_HIER:

       

      I'm using the Extractor Connector to load this data from the SAP (no BW).

       

      Result of extracting data ist always:

       

           0 lines fetched

           0FUNCT_LOC_HIER << ExpandedLeaves 0 lines fetched

       

      The log file "QvSAPExtr" contains "2016-01-20 15:22:08     Received: E1RSHND, Rows: 0, Total Rows: 0"

      So I get no data for this. This is really strange because  the "Server" log contains this:

       

           2016-01-20 15:22:07     Requesting a new SAP Data job: 0FUNCT_LOC_HIER, Logical Sys: QVEXTRX999, ASHOST: 192.12.155.10, Id: 253

           2016-01-20 15:22:07     Hierarchy: TPLH

           2016-01-20 15:22:08     253 : Started job: REQU_QVEXTRX999_20160120152206

           2016-01-20 15:22:08     Received: 0FUNCT_LOC_HIER, Id: 253, rows: 206, Total rows: 206

           2016-01-20 15:22:11     rqState 9: Reported complete by SAP, id: 253

       

      ->so there is some Data...

       

      I'm using the generated script:

       

      HIERARCHY(NODEID,PARENTID,NODENAME,,NODENAME,HIERARCHY)
      LOAD
      NODEID,
      INFOOBJECT,
      NODENAME,
      TLEVEL,
      LINK,
      PARENTID,
      CHILDID,
      NEXTID,
      DATEFROM,
      DATETO,
      INTERVL;
      SQL EXTRACTOR 0FUNCT_LOC_HIER
      UPDMODE H  
      // Hierarchy extractor
      TFRMETHOD T   // tRFC transfer method
      HIERARCHY TPLH
      HIERLANGUAGE German
      HIERTABLE E1RSHND
      LOGSYS QVEXTRX999
      ;

       

      Can someone help me?

       

      Thanks!

        • Re: No rows for hierarchy 0FUNCT_LOC_HIER
          Tomas Sommergyll

          Hi Markus,

           

          The curious value could occur because the resulting rows from SAP contains both "data" and "text". If you uncomment the part in the script that retrieves the text information, I believe the result will be 206 rows of text and 0 data rows.

           

          Br,

          Tomas

            • Re: No rows for hierarchy 0FUNCT_LOC_HIER
              Markus Blum

              Hi Thomas,

               

              Thank you, but unfortunately for the text the same result is coming .

               

                   2016-01-21 14:07:01     EXTRACTOR 0FUNCT_LOC_HIER#UPDMODE H#TFRMETHOD T#HIERARCHY     TPLH#HIERLANGUAGE GERMAN#HIERTABLE E1RSHFT#LOGSYS QVEXTRX999#

                  2016-01-21 14:07:01     EXTRACTOR = 0FUNCT_LOC_HIER

                  2016-01-21 14:07:01     UPDMODE = H

                  2016-01-21 14:07:01     TFRMETHOD = T

                  2016-01-21 14:07:01     HIERARCHY = TPLH

                  2016-01-21 14:07:01     HIERLANGUAGE = GERMAN

                  2016-01-21 14:07:01     HIERTABLE = E1RSHFT

                  2016-01-21 14:07:01     LOGSYS = QVEXTRX999

                  2016-01-21 14:07:01     TimeoutSAP      :14400

                  2016-01-21 14:07:01     TimeoutInit     :900

                  2016-01-21 14:07:01     TimeoutActivity :7200

                  2016-01-21 14:07:01     TimeoutData     :3600

                  2016-01-21 14:07:01     Received Hierarchy Meta Data

                  2016-01-21 14:07:02     Information from server: INFOMSG : Started job: REQU_QVEXTRX999_20160121140701

                  2016-01-21 14:07:02     Received: E1RSHFT, Rows: 0, Total Rows: 0

                  2016-01-21 14:07:02     Disconnected

                  END AT:

                  2016-01-21 14:07:02

                  Total run time: 00h 00m 02s

               

              -->0 rows in QV but 206 rows in server log:

                   2016-01-21 14:07:02     Received: 0FUNCT_LOC_HIER, Id: 10, rows: 206, Total rows: 206

               

              The script for this:

              LOAD
              INFOOBJECT,
              NODENAME,
              TXTSH;
              SQL EXTRACTOR 0FUNCT_LOC_HIER
              UPDMODE H  
              // Hierarchy extractor
              TFRMETHOD T   // tRFC transfer method
              HIERARCHY TPLH
              HIERLANGUAGE German
              HIERTABLE E1RSHFT
              LOGSYS QVEXTRA131
              ;

               

              ...Any other ideas...? Thanks.

              • Re: No rows for hierarchy 0FUNCT_LOC_HIER
                Markus Blum

                Hi Tomas

                 

                We are running V 5.80 SR4, 2211 vs. SAP Basis 7.31.

                 

                Markus

                  • Re: No rows for hierarchy 0FUNCT_LOC_HIER
                    Tomas Sommergyll

                    Please download the latest version of the connectors from the Qlik Website. If the issue persists, please reach out to the Qlik Support with a link to this thread (as mentioned above )

                     

                    (Edit: Have you tried calling the hierarchy using the idoc method?)

                     

                    Best regards,

                    Tomas

                      • Re: No rows for hierarchy 0FUNCT_LOC_HIER
                        Markus Blum

                        Hi Tomas,

                         

                        Thanks. I think we will do connector update later this year.

                         

                        IDoc is not possible because it is not allowed in DataSource ("only PSA"). May be we will switch this in source system an try the IDoc way later.

                         

                        If there are news for this issue I will reply on this thread.

                         

                        Meanwhile we extended the 0FUNCT_LOC_ATTR with the relevant hierarchy field TPLMA from the IFLOT table. This workaround works .

                         

                        Regards,

                        Markus

                  • Re: No rows for hierarchy 0FUNCT_LOC_HIER
                    Tobias Vogt

                    Hi,

                     

                    maybe some points you might check:

                    Has the DataSource been activated in SBIW?

                    Do you get some records with ExtractorChecker RSA3?

                    Maybe the language should be D instead of german?

                    Check /QTQVC/STATUS table, maybe a former request has status S and should be deleted.

                    If there has been some version changes, will you get the same results for a new logical system?

                     

                    I hope there might be some usefull hints to fix your problem.

                     

                    Have you already extracted any other data via extractor connector from this system?

                     

                    Regards,

                     

                    Tobias