MultipleActiveResultSets on HANA SDA

[sandeepkarnati]

Hello Team,

we defined a MSSQL DB as source on HANA SDA connections.
connection is working fine and we were able to extract the data from MSSQL DB on to HANA.

for Some querys and randomly extract is failing with error "

internal error: search table error: internal error: Error opening the cursor for the remote database [Microsoft][ODBC Driver x.x.x.x for SQL]

Connection is busy with results for another command for query "

currently we are using the MSSQL ODBC driver version 17.

as per the SAP note "0002584052" https://launchpad.support.sap.com/#/notes/0002584052 is asking to enable the MultipleActiveResultSets=True"

could you please let me know how to enable this parameter and where

to define the connection in SDA ,our odbc.ini file connection format is as below
[DBNAME]
Server=MSSQl DB host name,1433
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.2.so.0.1
Database=DBANME

[SeungjoonLee · Accepted solution]

Hello Sandeep,

As described in the Microsoft document (Using Multiple Active Result Sets (MARS) in SQL Server Native Client) which is linked in the SAP Note 2584052, Mars_Connection=yes can be used in odbc.ini file according to Microsoft.

However, please kindly understand that as this is a parameter from Microsoft ODBC driver, SAP cannot guarantee this feature and its stability.

I would highly recommend to use Safe Mode (SAP Note 2602761 - Enabling the Safe Mode for ODBC Connections for Smart Data Access) for testing this feature to avoid any potential issues such as an indexserver crash.

Best,
Seungjoon

[sandeepkarnati · Accepted solution]

Hello Lee,

Thank you for the Update.

i made necessary changes to odbc.ini file as below,but issue still persist.

[DB NAME]

Server=host IP,1433

Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-x.y.z.so.9.2

Database=DBName

MultipleActiveResultSets=True

[SeungjoonLee · Accepted solution]

Hello Sandeep,

As I wrote and as written in the Microsoft document, Mars_Connection=yes should be used instead of MultipleActiveResultSets=True. It seems that my screenshot was broken. So, I just uploaded it again in my previous answer.

[DB NAME]

Server=host IP,1433

Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-x.y.z.so.9.2

Database=DBName

Mars_Connection=yes

[sandeepkarnati · Accepted solution]

Hello Lee,

Thank you for quick turnaround.

i added the string Mars_Connection=yes in the connection definition in odbc.ini file.

it woked!!!

Thank you

[davidgund]

Hello together,

we have currently the same problem with the driver Version 18.

[Microsoft][ODBC Driver 18 for SQL Server]Connection is busy with results for another ...

As already describe we have added MARS to our ODBC.ini File:

But it had no effect, we still have the error when loading data. Has someone an idear?

Best regards

David