Connection is busy with results for another command Error
None of the solutions I've found for this have worked for me.
Sporadically we are receiving this error (more often than not). I was under the impression that Qlik load scripts are synchronous, but this is making me believe otherwise.
Here are some details:
1. We have tried running it as different users. The issue is not consistent - sometimes the error appears, sometimes the script loads successfully regardless of the user.
2. We tried doing a "Disconnect;" and then reconnecting to the database before the nefarious query, which allows the query to finish more frequently, but I imagine we risk losing data on the query we disconnected.
3. We tried different versions of the SQL driver and we still achieve the inconsistent results.
4. We've tried it from multiple machines, no change.
Note: if this suggestion helps to resolve the issue or answers your question, it will be appreciated if you select the "Accept as Solution" option. We encourage you to visit our Knowledge Base https://qliksupport.force.com/QS_CoveoSearch when trying to find a solution related and not limited to: errors, feature requests, product defects. You can also visit our Qlik Help portal https://help.qlik.com/