topic Identical Script - Version 9 runs okay 10 does not in QlikView

Identical Script - Version 9 runs okay 10 does not

pkelly — Fri, 28 Jan 2011 13:05:59 GMT

I am in the midst of rewriting our QlikView Scripts / Reports for the new financial year.

This is due to a change in our analysis structure / to make the look and feel of all of our reports the same.

On our server, we have version 9 of QlikView.

On my development PC I recently upgraded to QlikView 10.

I have a script which runs okay on QlikView 9 (QlikView 10 version save on to the server which hosts QlikView 9) but,

on my PC where I am running QlikView 10 I get the following error message...

SQL##f - SqlState: S1000, ErrorCode: 4294947171, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Number of open cursors exceeds limit (7612)
SQL SELECT
Code,
"Code-Desc",
value1
FROM PUB."cde_codes"
WHERE Prefix = 'DR-THICKNESS'

Any ideas?

Identical Script - Version 9 runs okay 10 does not

saxjonas — Fri, 28 Jan 2011 14:02:47 GMT

At first I thought this was a non-Qlikview 10 related problem but it got me thinking!

Is the script big? How many LOAD statements are there from this database?

The difference from qlikview 9 to 10 is that,from what I've heard, Qlikview 10 is multi-threading the LOAD statements if possible.

The error message is generated by the SQL server because it runs out of cursors (There's a limit to amount of simultaneous connections I'm guessing) because QV10 is running too many connections at once to the database.

Solution? Either increase the cursor limit on the SQL server or find a way for Qlikview 10 to single thread.

Again, this are just hunches but it seems possible.

Identical Script - Version 9 runs okay 10 does not

pkelly — Fri, 28 Jan 2011 14:17:54 GMT

Thanks for the response Jonas.

The data source is a Progress database hosted on a Unix Server - wouldn't know where to start on simultaneous connections and to be honest I wouldn't change anything on the Unix box as it is our main trading system.

Both QlikView 9 and 10 are pulling from the same data source so it may be the multi-threading as this script has a lot of mini queries to form a single table at the end.

Will look about to see if i can see anything on single threading.

Identical Script - Version 9 runs okay 10 does not

pkelly — Mon, 31 Jan 2011 10:56:10 GMT

Installed QV10 SR1 (was on IR) and issue has disappeared...