SAP Extractor connector - connection closed

[danters182]

Hi there,

We were just setting up the SAP Extractor to a BW 7.31 environment, to load Cubes and ODS from a test and a live BW System.

Both systems are identically setup as the SAP extractor connector manual describes.

But still we face an issue by running the script with the connection to the live system. The same script works with an connection to the test system.

After running the script to live system, we see the the QTQVCEXTRACT user in the sm50 collecting the data and the job running in SM37.

At the same time on the Qlik-View side, we have an app-crash with the windows 2012 error message popup (QVconnect 11.20 SR9 has crashed). Processes in SAP keep running for several minutes until the connection lost is noticed.

In the QvSAP connector error log we found following entries:

2015-06-09 09:49:43	Received Meta Data, No of Fields: 7
2015-06-09 09:49:43	Information from server: INFOMSG : Started job: REQU_QTQVCEXTR1_20150609094941

2015-06-09 09:50:13 Err FAILED 8ZDSDEC Error: connection closed without message (CM_NO_DATA_RECEIVED)

2015-06-09 09:50:15

Disconnected

If we double check the connection in the SM59 with a connection test, we see that it is connected in test system but throws an unregistered programm error message in the live system:

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

ERROR: program QTQVCEXTR1 not registered

LOCATION: SAP-Gateway on host DZSAPBWSV11.geobra.net / sapgw13

DETAIL: TP QTQVCEXTR1 not registered

Actually we think, that normally the programm registeres itself by connecting to the live system, but something seems to be preventing it by doing so.

On Qlikview side we have a successful connection test by setting up the connector and we also recieve meta-data as shown in the the above logfile, but as soon as it starts loading data, the application crashes.

Has someone an idea what we are missing?

Thanks for your help, much apprechiated!

BR

Daniel

[danters182]

Some more Information from my side:

We were trying to load a simple Z-Table from the Live system to check if the connection is working at all.

So we setup a connection via the Sap-connector instead of the Sap-extractor-connector using the same extractor user as we did with the extractor connector.

The table was successfully loaded from the BW-Live system. Another try with the extractor connector failed afterwards.

We are using QVconnect 11.20 SR9 - do you think we should upgrade to SR11?

Thanks and best regards

Daniel

[Hakan_Ronningberg]

Hi Daniel,

Please check the document QlikView Connector for SAP - Tips and Tricks which can be found in the starting page of 'Connector for SAP', under the heading: ERROR  registration of tp <program id> from host <external host> not allowed

It might be the cause of the problem.

Also check the Service log on the server where the Service is running, found in the same path as the connector log.

Regards,

Hakan

[danters182]

Hi Hakan,

thanks for your hint, but unfortunatelly it did not solve the issue.

Our parameter gw/acl_mode is set to 0, which means the reg_info and sec_info file is not relevant because every programm is allowed to register.

We also ran an CPIC Trace on our live system which gives us again the notification that the programm ist not registered:

*****************************************************************************
*
*  LOCATION    SAP-Gateway on host XXX / sapgw13
*  ERROR       program QTQVCEXTR1 not registered
*
*  TIME        Wed Jun 10 10:38:45 2015
*  RELEASE     721
*  COMPONENT   SAP-Gateway
*  VERSION     2
*  RC          679
*  MODULE      gwr3cpic.c
*  LINE        1972
*  DETAIL      TP QTQVCEXTR1 not registered
*  COUNTER     935464
*
*****************************************************************************

Regards

Daniel

[Hakan_Ronningberg]

Hi Daniel,

A 'test connection' will not work if there is no ongoing Extraction job. The program is not registered then.

Can you attach the logs for Connector and Service found in C:\ProgramData\QlikTech\Custom Data\QvSAPConnector\Log. Format like QvSAPExtr_20150521_081613.txt and Server_20150525_121637.txt?

Thanks,

Hakan

[danters182]

Hi Hakan,

please find the logs attached.@

Thanks for your help!

Best regards

Daniel

[Hakan_Ronningberg]

Hi Daniel,

I believe this error is SAP related and not a connector problem. You can check if the Extraction job in SAP has finished OK in transaction SM37. Job name is 'BI' concatenated with the connector job name from the connector log, in your case BIREQU_QTQVCEXTR1_20150610160952.

You can also check the Transactional RFC in transaction SM58.

Regards,

Hakan

[danters182]

Hi Hakan,

Thanks for your effort.

We are actually a bit unsure from which side it comes.

All other RFC-Connections to and from SAP are working properly.

Our SAP-Basis says, everything is setup correctly on SAP side.

The job is actually started in SM37, running correctly (collecting data) and finishing without an error.

Only SM58 collects error RFCs saying "Error when opening an RFC connection (CPIC-CALL: '"

We will have another try updating the Connector and maybe setup the whole connection again.

Thanks so far, if you have any further ideas, please keep me posted.

Best regards

Daniel

[danters182]

Hi Hakan,

Update to QV_SAP_Connector Version 5.90 solved the issue.

Installed, restarted the service, had another try and it ran successfully.

Program is now also registered in SM59.

Thanks for your help and best regards

Daniel