Common Error: Connection is busy with results for another command

Martin11 — Sun, 15 Jan 2023 14:47:32 GMT

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

Re: Common Error: Connection is busy with results for another command

john_wang — Mon, 16 Jan 2023 08:13:57 GMT

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.

topic Re: Common Error: Connection is busy with results for another command in Qlik Replicate

Common Error: Connection is busy with results for another command

Re: Common Error: Connection is busy with results for another command