topic Re: Script hangs up on OLEDB Connet to SQL Server in QlikView

Script hangs up on OLEDB Connet to SQL Server

Tue, 08 Jan 2013 21:59:35 GMT

HI,

My script permenantly hangs around 50% to 75% of the time when trying to connet with a SQL Server Database.

When debugging with a limited load the script always completes with no issues.

The test connection always works with no issue.

This is becoming very frustrating.

Is there a setting I need to change?

Regards,

Tim

Re: Script hangs up on OLEDB Connet to SQL Server

flipside — Wed, 09 Jan 2013 09:22:15 GMT

Hi Tim,

There's no obvious settings in QV that I can think of.

Are you querying a database that other users or processes access? If so, check for Table/Page/Row locks on your database source.

If you are querying a view, maybe convert this into a stored procedure or better still have a process SQL side that creates a table on a schedule that only your QV load process uses.

flipside

Re: Script hangs up on OLEDB Connet to SQL Server

Thu, 10 Jan 2013 18:28:14 GMT

Hi,

Thank you.

Is there a way to handle locks from the QlikView script?

Additional information:

I am noticing that I will kick off a script and the progress does not print to the "Script Execution Progress" Box. Progress does get inserted into the log.

In the cases, where nothing shows in the Script Execution Progress box, then the prgoess stops at the connect statement.

When the Script Execution Progress box does get updated with the progress the OLEDB connect works!

I beleive this could be a memory issue but I have plenty of RAM on my computer...

Re: Script hangs up on OLEDB Connet to SQL Server

flipside — Thu, 10 Jan 2013 22:01:16 GMT

Locks are purely SQL side, they occur when two or more processes try to access the same data at the same time. They cannot be controlled from QV. You could try using WITH NOLOCK hints on your SQL code.

If the script doesn't get past the connect statement I suspect it may be something else anyway - you need to check from the SQL side if the request is being received.

flipside