2 Replies Latest reply: Nov 23, 2016 8:14 AM by Hakan Ronningberg RSS

    QTQVCEXTR1 no extractors found for logical system

    Thomas Fabian

      Hi experts

       

      We are using QlikView 11.2.

      SAP Connector 6.3 has been installed.

       

      All connector types to BW on HANA work fine, except the one for SAP Extractor.

       

      We have done the setting as described in the document, here for SAP BW, not for ERP:

      https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/6.1/Configuration/SAP-Extractor-connector-in-BW.htm

       

      Activating an extractor in BW /n/QTQVC/ACTIVATE generates the message below:

      qkli1.PNG

       

      In QlikView connecting with SAP BW and the Logical system QTQVCEXTR1 we don't get any extractors.

      qkli2.PNG

      At which place did we miss any customzing in BW?

       

      SM59 for QTQVCEXTR1 and testing the Connection results in a failure:

      qkli3.PNG

      SAP ECC/ERP:

      https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/6.1/Configuration/SAP-Extractor-Qlik-admin.htm

       

      Any ideas?

       

      Thanks

      Thomas

        • Re: QTQVCEXTR1 no extractors found for logical system
          Thomas Fabian

          partly resolved:

          I have deleted the logical system QTQVCEXTR1 and its corresponding RFC connection in SM59.

          Thereafter recreation of this system.

           

          Now the extractors are given in Qlik, but the data loading / execute script ends with an error:

           

          FAILED  Error:
          LOCATION    CPIC (TCP/IP) on local host with Unicode
          ERROR       hostname 'sapbwas04' unknown
          TIME        Tue Nov 22 13:59:52 2016
          RELEASE     720
          COMPONENT   NI (network interface)
          VERSION     40
          RC          -2
          MODULE      nixxhl.cpp
          LINE        183
          DETAIL      NiHLGetNodeAddr: hostname cached as unknown
          COUNTER     1

          SQL EXTRACTOR 80EPM_DS01
          TFRMETHOD T  
          UPDMODE F  

          LOGSYS QTQVCEXTR1

            • Re: QTQVCEXTR1 no extractors found for logical system
              Hakan Ronningberg

              Hi Thomas,

               

              Are you using release 6.3.1 or 6.3.2?

               

              The 'Test connection' in transaction SM59 is not going to give a positive result if no extraction is taking place at the time. So if that was the case the error is an expected outcome.

               

              At the bottom of the screen in transaction SM59, Gateway Host and Gateway service is displayed. Gateway Host and Gateway service are used when the Extractor connector registers the connection to SAP (before it can receive data). The entries are created when the Logical system is created or modified in transaction /n/QTQVC/EXTRACTOR_ADM. Please check if your entries are correct.

               

              Read more about this under the headline 'Modify' in the online help:

               

              Setting up Qlik Extractor administration ‒ Qlik Connectors

               

              Best regards,

              Hakan