topic Re: Qlik SAP SQL Connector in Connectivity & Data Prep

Qlik SAP SQL Connector

andrescc — Fri, 02 Apr 2021 08:28:41 GMT

Hi,

Please I need some help. We are using SAP SQL Connector, but I get error no 10054. The test connection its fine, but when I execute the script sometimes works and sometimes I get this:

Se ha producido el siguiente error:

QVX_UNEXPECTED_END_OF_DATA:

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

ERROR connection to partner '172.27.12.72:3333' broken

TIME Wed Feb 13 11:15:57 2019

RELEASE 721

COMPONENT NI (network interface)

VERSION 40

RC -6

MODULE nixxi.cpp

LINE 5082

DETAIL NiIRead: P=xxxxxxxxxx:3333; L=xxxxxxxxx:59635

SYSTEM CALL recv

ERRNO 10054

ERRNO TEXT WSAECONNRESET: Connection reset by peer

COUNTER 5

Please help, I've tried many things, but the error still there

SAP SQL Connector version 7.0.1

Re: Qlik SAP SQL Connector

Jay_Brown — Wed, 13 Mar 2019 20:46:58 GMT

Hello Andres,

As this is working intermittently I would first verify that the correct transport (and only those) are installed for the SAP version and connector you are using. It's possible you could be experiencing intermittent connectivity due to transport conflict. Please verify this per the help pages:

https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/Connectors_SAP/Installation/Installing-the-transports.htm

Otherwise, are these servers in a local topology? Same datacenter? What type of link? If you suspect the connection is getting interrupted, you may want to try to segment the data into smaller sets and/or reload the data from QVDs.

I hope that helps,

Jay

Re: Qlik SAP SQL Connector

LanBiteam — Mon, 28 Sep 2020 11:12:10 GMT

Hello Jay,

since we are facing the same problem after we upgrade SAP Connector to 7.0.3. I hope to check with you, how could we tell if this is a problem caused by Transport Conflict?

I have already checked the Release Version and SAP Basis Version and we tried to load only very small amount of Data (50000 lines). I could not see problem and the error log in SAP always exist.

Thanks a lot in advance.

Lan Cao

Re: Qlik SAP SQL Connector

LanBiteam — Mon, 28 Sep 2020 12:02:57 GMT

Hi Andrescc.

If you have solved the problem? Can you please share how was your problem?

Thanks a lot,

Lan

Re: Qlik SAP SQL Connector

JensWiesner — Fri, 28 Jan 2022 09:18:10 GMT

Hello Lan,

have you solved the problem?

After SAP Basis Update we have the Problem.

I also updated the connector to solve the problem.

Thanks

Jens