7 Replies Latest reply: Jan 4, 2017 4:52 AM by Tomas Sommergyll RSS

    SAP Konnektor Qlikview

    Ingo Gansen

      Hi,

      we are trying to extract SAP BW time dependent hierarchies with the SAP Extractor connector on QlikView.

      It doesn't work.

      It is fetching lines, but the Extractor is running and running. (log attached)

       

      Could anyone help?

        • Re: SAP Konnektor Qlikview
          Tomas Sommergyll

          Hi Ingo,

           

          Please upgrade to the latest version of the Qlik SAP Extractor Connector as bugs have been fixed that relate to this issue.

           

          Br,

          Tomas

          • Re: SAP Konnektor Qlikview
            Ingo Gansen

            I've updated to version 6.3.2.

            Same result. TRFC gets a timeout.

            When I switch to IDOC method it counts the expanded leaves to infinity. ! ! (see profitcenter extract)

             

            016-12-19 11:46:26     Disconnected SAP, Id: 2

            2016-12-19 11:46:29     Closing the endPointThread Id: 2

            2016-12-19 11:47:09     Closing SrvEndPoint: 2

            2016-12-19 11:47:09     Closing the receiverThread Id: 2

            2016-12-19 11:50:16     Connected to SAP, Id: 3

            2016-12-19 11:50:16     SAP Transport information - CurRel: 060302, current: E66K900072, transp date: 20161219, transp time: 101534, basis: 740, Id: 3

            2016-12-19 11:50:17     Retrieved gwserv: sapgw35, gwhost: cic14.sap.fra.dlh.de

            2016-12-19 11:50:17     [Service Record Info] Inserted record with SrvService-IP: 10.103.111.41, logical system: QTQVCEXTR1, Id: 3

            2016-12-19 11:50:17     Registered GWHOST: cic14.sap.fra.dlh.de

            2016-12-19 11:50:17     Registered GWSERV: sapgw35

            2016-12-19 11:50:17     Starting the SAP packet listener

            2016-12-19 11:50:17     Requesting a new SAP Data job: 8CSMOVH, logical system: QTQVCEXTR1, ASHOST: cic14.sap.fra.dlh.de, Id: 3

            2016-12-19 11:50:17     Hierarchy: MOVEMENTTYPE

            2016-12-19 11:50:17     [RFC_NOT_FOUND] - doing refresh of Server Connection

            2016-12-19 11:50:18     3 : Started job (INITRNR): REQU_QTQVCEXTR1_20161219105016

            2016-12-19 11:50:18     Received: 8CSMOVH, Id: 3, rows: 125, Total rows: 125

            2016-12-19 11:50:18     rqState 9: Reported complete by SAP, Id: 3

            2016-12-19 11:50:47     Sent Job finished update to SAP: 8CSMOVH, Id: 3

            2016-12-19 11:50:47     JOB STATUS: FINISHED, Total Rows: 113, Id: 3, Name: 8CSMOVH, Run Time: 31 seconds

            2016-12-19 11:50:47     Disconnected SAP, Id: 3

            2016-12-19 11:50:47     Closing the endPointThread Id: 3

            2016-12-19 11:53:08     Connected to SAP, Id: 4

            2016-12-19 11:53:08     SAP Transport information - CurRel: 060302, current: E66K900072, transp date: 20161219, transp time: 101534, basis: 740, Id: 4

            2016-12-19 11:53:10     Disconnected SAP, Id: 4

            2016-12-19 11:53:11     Connected to SAP, Id: 4

            2016-12-19 11:53:29     Closing SrvEndPoint: 3

            2016-12-19 11:53:29     Closing the receiverThread Id: 3

            2016-12-19 11:53:50     Disconnected SAP, Id: 4

            2016-12-19 11:53:58     Connected to SAP, Id: 5

            2016-12-19 11:53:58     SAP Transport information - CurRel: 060302, current: E66K900072, transp date: 20161219, transp time: 101534, basis: 740, Id: 5

            2016-12-19 11:53:58     Retrieved gwserv: sapgw35, gwhost: cic14.sap.fra.dlh.de

            2016-12-19 11:53:58     [Service Record Info] This Service is already registered, Id: 5

            2016-12-19 11:53:59     Requesting a new SAP Data job: 8CSSPCTH, logical system: QTQVCEXTR1, ASHOST: cic14.sap.fra.dlh.de, Id: 5

            2016-12-19 11:53:59     Hierarchy: PROFIT_CENTER

            2016-12-19 11:53:59     [RFC_NOT_FOUND] - doing refresh of Server Connection

            2016-12-19 11:53:59     5 : Started job (INITRNR): REQU_QTQVCEXTR1_20161219105358

            2016-12-19 11:53:59     Received: 8CSSPCTH, Id: 5, rows: 2163, Total rows: 2163

            2016-12-19 11:53:59     Received: 8CSSPCTH, Id: 5, rows: 1816, Total rows: 3979

            2016-12-19 11:53:59     Received: 8CSSPCTH, Id: 5, rows: 1309, Total rows: 5288

            2016-12-19 11:53:59     Received: 8CSSPCTH, Id: 5, rows: 2141, Total rows: 7429

            2016-12-19 11:53:59     rqState 9: Reported complete by SAP, Id: 5

            2016-12-19 11:54:29     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 11:55:00     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 11:55:31     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 11:56:02     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 11:56:33     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 11:57:04     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 11:57:35     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 11:58:06     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 11:58:37     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 11:59:08     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 11:59:39     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:00:10     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:00:41     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:01:12     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:01:43     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:02:14     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:02:45     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:03:16     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:03:47     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:04:18     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:04:49     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:05:20     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:05:51     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:06:22     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:06:53     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:07:24     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:07:55     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:08:26     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:08:57     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:09:28     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:09:59     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:10:30     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:11:01     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:11:32     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:12:03     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:12:34     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:13:05     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:13:36     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:14:07     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:14:38     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:15:09     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:15:40     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:16:11     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:16:42     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:17:13     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:17:44     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:18:15     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:18:46     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:19:17     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:19:48     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:20:19     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:20:50     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:21:21     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:21:52     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:22:23     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:22:54     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:23:25     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:23:56     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:24:27     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:24:58     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:25:29     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:26:00     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:26:31     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:27:02     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:27:33     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:28:04     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:28:35     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:29:06     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:29:37     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:30:08     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:30:39     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:31:10     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:31:41     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:32:12     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:32:43     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:33:14     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:33:45     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:34:16     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:34:47     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:35:18     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:35:49     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:36:20     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:36:51     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:37:22     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:37:53     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:38:24     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:38:55     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:39:26     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:39:57     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:40:28     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:40:59     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:41:30     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:42:01     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:42:32     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:43:03     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:43:34     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:44:05     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:44:36     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:45:07     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:45:38     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:46:09     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:46:40     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:47:11     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:47:42     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:48:13     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:48:44     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:49:15     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:49:46     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:50:17     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:50:48     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:51:19     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:51:50     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:52:21     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:52:52     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:53:23     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:53:54     NOT all Rows are received yet: 8CSSPCTH

            2016-12-19 12:54:00 Err Id: 5. Sent Job ABORTED update to SAP. Job cancelled. Timeout type: TimeoutData, Extractor: 8CSSPCTH

              • Re: SAP Konnektor Qlikview
                Tomas Sommergyll

                Hi,

                 

                Is it possible to attach the connector logs (2016-12-19 11:50  to  2016-12-19 12:54) as well?

                 

                Does the issue only happen to 8CSSPCTH ?

                How many rows do you expect from 8CSSPCTH ?

                 

                Thanks,

                Tomas

                  • Re: SAP Konnektor Qlikview
                    Ingo Gansen

                    Hi Thomas,

                     

                    for transactional data and master data it works.

                    It happens for every time dependent SAP BW hierarchy I have tested (3 for now). Non time dependent hierarchies work.

                    added the last log, which ran via task (4h)

                     

                     

                    2016-12-21 18:09:22     Connector: C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPEXTRConnector.dll Ver: 6.3.2+Build:02027.origin/release/6.3.2

                    2016-12-21 18:09:22     Using Server Host: localhost , Port: 8680

                    2016-12-21 18:09:22     Socket timeout parameter (s): 900

                    2016-12-21 18:09:22     Socket created OK

                    2016-12-21 18:09:22     DNS: getaddrinfo

                    2016-12-21 18:09:22     Connected to SAP (ASHOST): cic14.sap.fra.dlh.de

                    2016-12-21 18:09:22     Making new SAP Request

                    2016-12-21 18:09:22     EXTRACTOR = 8CSSPCTH

                    2016-12-21 18:09:22     UPDMODE = H

                    2016-12-21 18:09:22     TFRMETHOD = I

                    2016-12-21 18:09:22     HIERARCHY = PROFIT_CENTER

                    2016-12-21 18:09:22     HIERVERSION = 100

                    2016-12-21 18:09:22     HIERLANGUAGE = ENGLISH

                    2016-12-21 18:09:22     HIERTABLE = E1RSHND

                    2016-12-21 18:09:22     LOGSYS = QTQVCEXTR1

                    2016-12-21 18:09:22     EXTRACTOR 8CSSPCTH#UPDMODE H#TFRMETHOD I#HIERARCHY PROFIT_CENTER#HIERVERSION 100#HIERLANGUAGE ENGLISH#HIERTABLE E1RSHND#LOGSYS QTQVCEXTR1#

                    2016-12-21 18:09:22     TimeoutSAP     : 14400

                    2016-12-21 18:09:22     TimeoutInit    : 900

                    2016-12-21 18:09:22     TimeoutActivity: 7200

                    2016-12-21 18:09:22     TimeoutData    : 3600

                    2016-12-21 18:09:22     TCPBufSize     : 1024

                    2016-12-21 18:09:23     Received Hierarchy Meta Data

                    2016-12-21 18:09:23     Information from server: INFOMSG : Started job (INITRNR): REQU_QTQVCEXTR1_20161221170918

                    2016-12-21 18:09:23     Received: E1RSHND, Rows: 1839, Total Rows: 1839

                    2016-12-21 18:09:23     Information from server: INFOMSG : Received Item No. : 0000000004859175

                    2016-12-21 18:09:23     Received: E1RSHND, Rows: 1816, Total Rows: 3655

                    2016-12-21 18:09:23     Information from server: INFOMSG : Received Item No. : 0000000004859177

                    2016-12-21 18:09:23     Received: E1RSHND, Rows: 1557, Total Rows: 5212

                    2016-12-21 18:09:23     Information from server: INFOMSG : Received Item No. : 0000000004859179

                    2016-12-21 18:09:24     Received: E1RSHND, Rows: 1051, Total Rows: 6263

                    2016-12-21 18:09:24     Information from server: INFOMSG : Received Item No. : 0000000004859181

                    2016-12-21 18:09:53     JOB STATUS: FINISHED, Total Rows: 6263, Name: 8CSSPCTH

                    2016-12-21 22:11:28     Closing the Socket

                    2016-12-21 22:11:28     Socket created OK

                    2016-12-21 22:11:28     DNS: getaddrinfo

                    2016-12-21 22:11:28     Creating a INIT reconnect cmd, id: 34

                    2016-12-21 22:11:28 Err Connection timed out while waiting for SAP response

                    2016-12-21 22:11:30     Disconnected

                    2016-12-21 22:11:32     Closing the Socket