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. Visit our Knowledge Base https://community.qlik.com/t5/Knowledge/tkb-p/qlik-support-knowledge-base and our Qlik Help portal https://help.qlik.com/