topic Re: SAP Connector Issue in Connectivity & Data Prep

SAP Connector Issue

bhsharm5 — Wed, 13 Jan 2021 13:48:33 GMT

Hi,

I am using Qlik SAP Connector (7.0.3) to fetch data from SAP BW system. The connector has stopped working recently with the attached error while trying to fetch data from BEx Query.

"Could not load file or assembly 'sapnco_utils.dll' or one of its dependencies. is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)"

The connector has stopped working after we installed ServiceNow ODBC drivers in the server (not sure if it has caused something, or it's just a coincidence).

Can anyone please help!

Regards,

Bhaskar

Re: SAP Connector Issue

Flo_Kopp — Mon, 02 May 2022 14:41:13 GMT

Hey there,

did you manage to fix it? I have the same issue here on a brand new Server right after installing the SAP Connector (8.0.1)

Re: SAP Connector Issue

Tomas_Sommergyll — Tue, 03 May 2022 08:33:29 GMT

Hi,

The Qlik SAP Connectors using sapnco.dll and sapnco_utils.dll need to have the runtime library ("Microsoft Visual C++ 2010 Service Pack 1 Redistributable Package MFC Security Update") installed.

The runtime library can be downloaded from the Microsoft web site.

(The runtime library will be included in the next release of the Qlik SAP Connectors. For ver 8.0.1, it needs to be downloaded manually)

Regards,

Tomas

Re: SAP Connector Issue

Flo_Kopp — Tue, 03 May 2022 14:34:30 GMT

thanks a lot. that fixed my issue!

Re: SAP Connector Issue

Emmanuelle__Bustos — Fri, 06 May 2022 19:26:01 GMT

Tahnk you!

Re: SAP Connector Issue

iliyansomlev — Fri, 27 May 2022 14:16:56 GMT

Thank you, this solved the issue for me, as well.

Re: SAP Connector Issue

Tomas_Sommergyll — Tue, 07 Feb 2023 11:48:13 GMT

Hi,

In my previous post, I mentioned that the runtime libraries would be included in the next release of the Qlik SAP Connectors package.

However, starting from version 8.0.2, the runtime libraries i.e. sapnco.dll, sapnco_utils.dll as well as the SAP NW RFC SDK files need to be downloaded from the SAP Support Portal with an S-user ID, see the Qlik online help here ("Downloading and installing the SAP Libraries" - section):
https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/Connectors_SAP/Installation/Installing-the-connectors.htm

Regards,
Tomas