topic Re: Need for assistance in Qlikview SAP Extractor Setup in QlikView

Need for assistance in Qlikview SAP Extractor Setup

Tue, 24 Jan 2012 13:35:05 GMT

Dear all,

I'm am a beginner in the Qlikview handling and have a problem in our setup of the extractor from SAP. Our QV enviroment is QV 10 with connector 5.6 and our SAP system is ERP 4.7.

I have set up an Logical system, connected the outbound messages, activated the extract in SAP and when I will reload the script I have the follwing statement : Statement is: EXTRACTOR 2LIS_11_VAHDR UPDMODE C EXTRLANGUAGE E LOGSYS QTQVCEXTR1 since this is the first test.

The connector Log shows this:

2012-01-24 11:22:00 Progress Creation of function /QTQVC/EXTRACTION_STATUS returned after 00:00:00

2012-01-24 11:22:00 Progress Invoked /QTQVC/EXTRACTION_STATUS with MODE=I, returned STATUS=N

2012-01-24 11:22:00 Error Unable to register at GWSERV=sapgw20;GWHOST=172.27.0.191;PROGRAM_ID=QTQVCEXTR1 Key = RFC_COMMUNICATION_FAILURE (

LOCATION CPIC (TCP/IP) on local host with Unicode

ERROR service '?' unknown

TIME Tue Jan 24 11:22:00 201

RELEASE 711

COMPONENT NI (network interface)

VERSION 39

RC -3

DETAIL NiErrSet

COUNTER 2

)

2012-01-24 11:22:00 Progress Creation of function /QTQVC/EXTRACTION_STATUS returned after 00:00:00

2012-01-24 11:22:00 Error /QTQVC/EXTRACTION_STATUS failed after 00:00:00 Key = ERROR (ID:00 Type:E Number:001 Status record could not be found)

2012-01-24 11:22:00 Error ID:00 Type:E Number:001 Status record could not be found

Also when I view WE05 in SAP I can't find any Idoc's generated.

Thankful for any adwise where to fix the error.

Regards Magnus

Need for assistance in Qlikview SAP Extractor Setup

Wed, 25 Apr 2012 09:32:17 GMT

Hi Magnus,

Unfortunately I have no solution, but the same problem as you had. Did you find any solutions for the problem in the meantime?

In my case there is the following error message in the SAP System Log (transaction SM21):

Operating system call recv failed (error no. 10054)

The specified operating system call was returned with an error.

For communication calls (receive, send, etc) often the cause of errors

are network problems.

It could also be a configuration problem at operating system level.

(file cannot be opened, no space in the file system etc.).

Additional specifications for error number 10054

Name for errno number WSAECONNRESET

No documentation available for error WSAECONNRESET

Furthermore it's possible to connect from a local Client (with QlikView & SAP Connector installed) from within our network, but it's not possible directly from the QlikView Server.

Regards

Thomas

Need for assistance in Qlikview SAP Extractor Setup

suniljain — Wed, 25 Apr 2012 10:50:16 GMT

Please check authorization given SAP R/3. I think proper authorization is not given.

Re: Need for assistance in Qlikview SAP Extractor Setup

Wed, 25 Apr 2012 11:01:42 GMT

hi,

the same data load works from my client computer. it just don't work from our qlikview server. so I think it can hardly be a authorization problem within SAP. To be sure i switched on the authorization trace in SAP, but there are no entries afterwards. As a further step I tried with my own SAP user - the same.

any other ideas?

Re: Need for assistance in Qlikview SAP Extractor Setup

Wed, 25 Apr 2012 11:28:26 GMT

i think it is the RFC failure, check the RFC interface between your SAP Server and Qlikview Server and check the default port 3300 is in open state to access from your qlikview server.

Regards,

Prasath

Re: Need for assistance in Qlikview SAP Extractor Setup

suniljain — Wed, 25 Apr 2012 11:41:30 GMT

if this is the case then just check port 3300 of the sap r/3 server through telnet command in cmd prompt of qlikview server.

Need for assistance in Qlikview SAP Extractor Setup

Wed, 25 Apr 2012 11:43:03 GMT

Hi all,

Sunil: The QV user has SAP all

Prasath: I just noticed this in the connector manual and will check this but wouldn't the IDOC been generated still in SAP but but not sent to receving logical system ?

Regards ,

Magnus

Re: Need for assistance in Qlikview SAP Extractor Setup

Wed, 25 Apr 2012 11:43:42 GMT

Hi all,

Sunil - The QV user has SAP all

Prasath - I just noticed this in the connector manual and will check this but wouldn't the IDOC been generated still in SAP but but not sent to receving logical system ?

Regards ,

Magnus

Re: Need for assistance in Qlikview SAP Extractor Setup

Wed, 25 Apr 2012 11:52:13 GMT

I agree, it has to be a RFC or port/firewall problem. But how to check this? Do you have an advice?

If I check the RFC destsination in transaction SM59 with a connection test there is a bunch of errors:

Logon Connection Error

Error Details Error when opening an RFC connection (CPIC-CALL: 'ThSAPOCMINIT' : cmRc=2 thRc=67

Error Details ERROR: program QTQVCEXTR1 not registered

Error Details LOCATION: SAP-Gateway on host sapd33 / sapgw10

Error Details DETAIL: TP QTQVCEXTR1 not registered

Error Details COMPONENT: SAP-Gateway

Error Details COUNTER: 36335

Error Details MODULE: gwr3cpic.c

Error Details LINE: 1789

Error Details RETURN CODE: 679

Error Details SUBRC: 0

Error Details RELEASE: 720

Error Details TIME: Wed Apr 25 13:40:42 2012

Error Details VERSION: 2

But what does that means? Since the same data load with the very same RFC connection works from my client computer.

As for the port, it's mentioned in the manual:

If a Firewall exists between Connector an SAP system; port 33nn has to be open, where nn = System Number of the SAP system.

As our basis/netwoork team told me there is no additional firewall within our netwoork between SAP and QlikView Server. The only firewall is the Windows Server 2008 firewall on our QlikView Server, which we disabled for test reasons - but still the same problem.

Re: Need for assistance in Qlikview SAP Extractor Setup

Thu, 26 Apr 2012 04:20:41 GMT

Hi,

Please find the document attached for the user roles and check the user has the appropriate roles,

use telnet and ping 3300 is open or not from your qlikview server.

Regards,

P.Prasath

Re: Need for assistance in Qlikview SAP Extractor Setup

suniljain — Thu, 26 Apr 2012 14:21:08 GMT

Issue is that SAP Transport file is not properly transported in SAP R/3 environment.

please transport it in proper sequence.

Re: Need for assistance in Qlikview SAP Extractor Setup

Mon, 07 May 2012 06:15:41 GMT

Sorry for the delay.

In my case neither an authorization problem nor the SAP transports were responsible for the error. It was just that on our server on which qlikview is running there was no SAP Gui installed.

Therefore it worked on my client machine (with SAP Gui installed) and it didn't worked on directly on the server.

You can either install a sap gui on the server or just register the missing sap entries in the 'services' file in Windows/system32 on the server (compare to a machine with sap gui installed).

Thanks anyway for the suggestions.

Regards

Thomas

Re: Need for assistance in Qlikview SAP Extractor Setup

Mon, 25 Jun 2012 14:05:13 GMT

Thanks a lot. We installed an Gui at our machine and directly the extract worked as supposed!