topic Re: Reload in debug not working (odbc error) in SR6 in QlikView

Reload in debug not working (odbc error) in SR6

anguila — Mon, 28 Apr 2014 08:18:40 GMT

Hi,

When I'm trying to reload in debug mode with a limited charge (i.e: 1000) in Qlikview Desktop SR6,SR5,SR4,SR3 I got this odbc error:

SQL # # f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft] [ODBC SQL Server Driver] Connection is busy with results for another hstmt

[SQL query here..]

But if I do a full reload (CTRL+R), it works perfectly.

This happens until the last upgrade from Qlikview Desktop SR3 to SR5.

Update: I downgraded to SR6 to SR2 and finally it worked in SR2.., but I want to be in SR6 for some bug fixes.

Any idea??

Thanks

Re: Reload in debug not working (odbc error) in SR6

Anonymous — Thu, 05 Jun 2014 17:56:33 GMT

Did u able to resolve this? i find same issue

Re: Reload in debug not working (odbc error) in SR6

anguila — Fri, 06 Jun 2014 08:00:17 GMT

As I said in the las update, the only option that worked for me was downgrade to QV Desktop SR2.

Re: Reload in debug not working (odbc error) in SR6

Anonymous — Mon, 09 Jun 2014 19:07:08 GMT

My case, it was different;

I asked to bring same field twice from table into qlikview in load and select. That is why, it has given this error. Once I removed, it worked fine.

Thanks

Re: Reload in debug not working (odbc error) in SR6

Sun, 29 Jun 2014 10:13:24 GMT

Hi David,

Any luck with the reload issue in debug mode, Recently i upgraded one of my client development env to SR6.

And getting same issue , when in debugging mode it throws same error, but on full reload it works fine.

I believe it must be a bug in this version.

Regards,

Vasim

Re: Reload in debug not working (odbc error) in SR6

Thu, 03 Jul 2014 07:46:39 GMT

Hi Vasim,

I had the same problems as you both had, but instead of downgrading i found a way to work around it.

this is my connection string now;

ODBC CONNECT32 TO ****(XUserId is *********, XPassword is ************);

SQL SELECT "code"

FROM "*****".dbo."Reg";

ODBC CONNECT32 TO *****(XUserId is ********, XPassword is ************);

SQL SELECT "Money", "code" as parts

FROM "****".dbo."Parts";

so whenever you want to run another query just add the connection string in front of it and the problem is solved.

So i guess the error is that it "forgets" how/where to connect to...

Anyway hope this helps.

Marcus

Re: Reload in debug not working (odbc error) in SR6

rnorris — Wed, 29 Dec 2021 11:05:34 GMT

Hi, just wanted to say, I had an issue where the Qlik Sense Debugger would fail every other reload, with what should have been a simple series of extracts from the same DB. Doing the above (repeating the "lib connect to" before each one) fixed the issue. Sometimes the debugger would say "Field not found" but sometimes would find it ok.

In case anyone is searching for the same problem and comes across this thread.