Common Error: Connection is busy with results for another command

[Martin11]

We often see this error message in our Qlik Replicate Solution for different tables:

----------------------------------------------

Failed to get table dbo.attrep_changes7478D612548493BC

RetCode: SQL_ERROR SqlState: HY000NativeError: 0

Message: [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command

Failed to send table 'SAPECC.RESB' (162) events to changes table

----------------------------------------------

Is there a configuration that we could tweak to prevent this ?

It seems the table mentioned is not updated and needs to be reloaded when this happens.

Thanks

Martin

[john_wang]

Hello @Martin11 ,

We need additional information to understand the issue, however as a start I'm guessing it's SQL Server Target side issue, so far would you please add an "additional ODBC connection properties"  in target endpoint to see if the problem solved (take note there is a semicolon ";" in the end of the string):

MultipleActiveResultSets=True;

For example:

Hope it helps.

Regards,

John.