Skip to Content
0
Dec 12, 2022 at 09:05 AM

Error opening the cursor for the remote db MS ODBC Driver 17 SQL TCP Provider Error code 0x68

113 Views

Hi

We have setup/configured our B4HANA system connection to MS SQL DB Source system via SDA as per the steps in the Blog "SAP BW4HANA DS connation (MS SQL DB) Source system via SDA" and our process chains are working as expected but the only challenge we have is that every now and then or intermittently, the process chains (parallel extraction) fails with the error below, which can be seen in SLG1, SM21 and in the B4HANA Cockpit (also see the attached screenshot):

internal error: Error opening the cursor for the remote database [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x68 for query ...

Message no. RS_EXCEPTION000

error-screenshot.png

Has anyone experienced the similar intermittent error before and how to go about resolving?

Hana version is 2.00.052.00.1599235305 (fa/hana2sp05)

OS version is SUSE Linux Enterprise Server 15 SP1

ODBC version is 17.10.1.1

thanks

Lerato

Attachments