9 Replies Latest reply: Nov 29, 2013 4:31 AM by prasad Somashekar RSS

    QlikView SAP Extractor Connector Problem

    prasad Somashekar

      When we are trying to connect using Sap Extractor Connector, we are having one problem as below: We are using QvSapExtrConnector.dll(64) .  RFC_GET_SYSTEM_INFO failed after 00:00:00 Key = Authority_Not_avilable(ID: SR Type:E SM 59 Administration).   Unable to register at GWSERT=XXXX: Key = RFC_Communication Failure. If any one has faced this problem, please adivise on this. ???

        • Re: QlikView SAP Extractor Connector Problem
          s j


          its authorization issue in SAP environment. Please check that whether you assigned proper role to user id and you exported transport properly.

            • Re: QlikView SAP Extractor Connector Problem
              prasad Somashekar


              Thanks Sunil, I will verify with Basis Team regarding the transport and authorisation. Will update the status...

                • Re: QlikView SAP Extractor Connector Problem
                  prasad Somashekar

                  Hi Sunil,

                  We worked to check roles and authorisation for the user. After rerunning again, it ran for some time and below error poped up. we have folled the sap Connector Manual. but still unable to extract the data using the extractor. Thanks! in advance...

                   

                  2013-08-27 15:33:00 Progress Connected to SAP with C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPEXTRConnector.dll 5.7 SR1, 10958

                  2013-08-27 15:33:00 Progress Log: 1

                  2013-08-27 15:33:00 Progress Logpath:

                  2013-08-27 15:33:00 Progress LogFile: QvSAPEXTRConnector

                  2013-08-27 15:33:00 Progress TimeoutIDoc: 7200 seconds

                  2013-08-27 15:33:00 Progress TimeoutSap: 14400 seconds

                  2013-08-27 15:33:00 Progress TimeoutInit: 900 seconds

                  2013-08-27 15:33:00 Progress TimeoutActivity: 3600 seconds

                  2013-08-27 15:33:00 Progress Creation of function /QTQVC/CHECK_RELEASE returned after 00:00:00

                  2013-08-27 15:33:00 Progress SAP Transport information: version: E6DK900375; date: 20130109; time: 112715; SAP basis: 731;

                  2013-08-27 15:33:00 Progress Connected

                  2013-08-27 15:33:00 Progress Statement is: EXTRACTOR 0FI_GL_10 UPDMODE C EXTRLANGUAGE E LOGSYS QTQVCEXTR1

                  2013-08-27 15:33:00 Progress EXTRACTOR = 0FI_GL_10

                  2013-08-27 15:33:00 Progress UPDMODE = C

                  2013-08-27 15:33:00 Progress LOGSYS = QTQVCEXTR1

                  2013-08-27 15:33:00 Progress EXTRLANGUAGE = E

                  2013-08-27 15:33:00 Progress Criteria =

                  2013-08-27 15:33:00 Progress Creation of function RFC_GET_SYSTEM_INFO returned after 00:00:00

                  2013-08-27 15:33:00 Progress Creation of function /QTQVC/EXTRACTION_STATUS returned after 00:00:00

                  2013-08-27 15:33:00 Progress Invoked /QTQVC/EXTRACTION_STATUS with MODE=I, returned STATUS=N

                  2013-08-27 15:33:00 Progress Successfully registered at GWSERV=sapgw00;GWHOST=sgusapap1rh;PROGRAM_ID=QTQVCEXTR1

                  2013-08-27 15:33:05 Progress Creation of function /QTQVC/GET_ACTIVATED_EXTRACTOR returned after 00:00:00

                  2013-08-27 15:33:06 Progress Creation of function /QTQVC/CREATE_REQUEST_IDOC returned after 00:00:00

                  2013-08-27 15:33:06 Progress INITRNR=

                  2013-08-27 15:33:06 Error Job already running

                  2013-08-27 15:33:06 Error No INITRNR received. Failed to start job.

                  2013-08-27 15:34:06 Progress Creation of function /QTQVC/CREATE_REQUEST_IDOC returned after 00:00:00

                  2013-08-27 15:34:06 Progress INITRNR=

                    • Re: QlikView SAP Extractor Connector Problem
                      s j

                      Please check the sequence of transports you followed . it should be in same sequence as mentioned in manual .  Still its not able to built RFC connection with SAP Environment. I will suggest you to send transport requests once again in SAP R/3.

                        • Re: QlikView SAP Extractor Connector Problem
                          prasad Somashekar

                          Thanks for the Solution, We redid the whole process from the Manual you sent. We are getiing a new error as below. No INITRNR received. Failed to start Job. Please advise on this. Thanks!

                           

                           

                          2013-08-29 09:07:04 Progress Connected to SAP with C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPEXTRConnector.dll 5.7 SR1, 10958

                          2013-08-29 09:07:04 Progress Log: 1

                          2013-08-29 09:07:04 Progress Logpath:

                          2013-08-29 09:07:04 Progress LogFile: QvSAPEXTRConnector

                          2013-08-29 09:07:04 Progress TimeoutIDoc: 7200 seconds

                          2013-08-29 09:07:04 Progress TimeoutSap: 14400 seconds

                          2013-08-29 09:07:04 Progress TimeoutInit: 900 seconds

                          2013-08-29 09:07:04 Progress TimeoutActivity: 3600 seconds

                          2013-08-29 09:07:04 Progress Creation of function /QTQVC/CHECK_RELEASE returned after 00:00:00

                          2013-08-29 09:07:04 Progress SAP Transport information: version: E6DK900375; date: 20130828; time: 181915; SAP basis: 731;

                          2013-08-29 09:07:04 Progress Connected

                          2013-08-29 09:07:04 Progress Statement is: EXTRACTOR 0FI_GL_10 UPDMODE F EXTRLANGUAGE E LOGSYS QTQVCEXTR1

                          2013-08-29 09:07:04 Progress EXTRACTOR = 0FI_GL_10

                          2013-08-29 09:07:04 Progress UPDMODE = F

                          2013-08-29 09:07:04 Progress LOGSYS = QTQVCEXTR1

                          2013-08-29 09:07:04 Progress EXTRLANGUAGE = E

                          2013-08-29 09:07:04 Progress Criteria =

                          2013-08-29 09:07:04 Progress Creation of function RFC_GET_SYSTEM_INFO returned after 00:00:00

                          2013-08-29 09:07:04 Progress Successfully registered at GWSERV=sapgw00;GWHOST=sgusapap1rh;PROGRAM_ID=QTQVCEXTR1

                          2013-08-29 09:07:09 Progress Creation of function /QTQVC/GET_ACTIVATED_EXTRACTOR returned after 00:00:00

                          2013-08-29 09:07:10 Progress INITRNR=

                          2013-08-29 09:07:10 Error Job already running

                          2013-08-29 09:07:10 Error No INITRNR received. Failed to start job.

                          2013-08-29 09:08:10 Progress Creation of function /QTQVC/CREATE_REQUEST_IDOC returned after 00:00:00

                          2013-08-29 09:08:10 Progress INITRNR=

                          2013-08-29 09:08:10 Error Job already running

                          2013-08-29 09:08:10 Error No INITRNR received. Failed to start job.

                          2013-08-29 09:09:10 Progress Creation of function /QTQVC/CREATE_REQUEST_IDOC returned after 00:00:00

                          2013-08-29 09:09:10 Progress INITRNR=

                          2013-08-29 09:09:10 Error Job already running

                          2013-08-29 09:09:10 Error No INITRNR received. Failed to start job.

                          2013-08-29 09:10:10 Progress Creation of function /QTQVC/CREATE_REQUEST_IDOC returned after 00:00:00

                          2013-08-29 09:10:10 Progress INITRNR=

                          2013-08-29 09:10:10 Error Job already running

                          2013-08-29 09:10:10 Error No INITRNR received. Failed to start job.

                          2013-08-29 09:11:10 Progress Creation of function /QTQVC/CREATE_REQUEST_IDOC returned after 00:00:00

                          2013-08-29 09:11:10 Progress INITRNR=

                          2013-08-29 09:11:10 Error Job already running

                          2013-08-29 09:11:10 Error No INITRNR received. Failed to start job.

                          2013-08-29 09:12:10 Progress Creation of function /QTQVC/CREATE_REQUEST_IDOC returned after 00:00:00

                          2013-08-29 09:12:10 Progress INITRNR=

                          2013-08-29 09:12:10 Error Job already running

                          2013-08-29 09:12:10 Error No INITRNR received. Failed to start job.

                          2013-08-29 09:13:10 Progress Creation of function /QTQVC/CREATE_REQUEST_IDOC returned after 00:00:00

                          2013-08-29 09:13:10 Progress INITRNR=

                          2013-08-29 09:13:10 Error Job already running

                          2013-08-29 09:13:10 Error No INITRNR received. Failed to start job.

                           

                  • Re: QlikView SAP Extractor Connector Problem
                    prasad Somashekar

                    Hi Sunil,

                    This issue is resolved after working with Sap Support. Below is the Resolution ....

                     

                     

                     

                    Symptom

                     

                     

                    A RFC connection fails when an external program /
                    application tries to register a program in the gateway with the error message:

                     

                     

                    LOCATION  SAP-Gateway on host <hostname> /
                    sapgw<nr>

                    ERROR    registration of tp <program id> from host
                    <external host>  not allowed

                     

                     

                    meaning that the gateway is not allowing the program
                    ID <program id> to be registered from the host <external host>

                     

                     

                    Cause

                     

                     

                    There are two possible reasons:

                     

                     

                     

                      • Parameter  "gw/acl_mode = 1" and
                             not reginfo file has been set. This is the default value for NEW
                             INSTALLATIONS for Netweaver  7.0x since December 2012 (including
                             7.20) and for  Netweaver 7.3X since August 2012.

                     

                      • There is a reginfo file that doesn't allow the
                             registration of that external program

                     

                    Resolution

                     

                    Update the "reg_info" file from the SAP gateway
                    that appears in the error message ("SAP-Gateway on host <hostname> /
                    sapgw<nr>") creating a line that allows this registration.

                    The location of the "reg_info" file is specified by parameter
                    "gw/reg_info" and should contain lines like:

                     

                    #VERSION=2

                      P TP=<program ID> HOST=<external host>
                    CANCEL=internal,<external host> ACCESS=*

                      ...

                    # the following lines should be the LAST lines in the reginfo

                    #

                    P TP=* HOST=<LIST> CANCEL=<LIST> ACCESS=<LIST>

                    P TP=* HOST=local

                     

                    Following recommendations from SAP Note 1408081
                    :  Basic settings for reg_info and sec_info

                    and settings  for ACCESS clausule from SAP Note 1592493 : GW: Problems
                    during reginfo configuration

                     

                    Then, reload the new settings via transaction SMGW

                     

                     

                     

                    And try to register the program again.

                     

                    Regards,

                    Prasad