Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am having problems reloading a document that reads data from an Oracle database, and creates a qvd-file. The document was running ok in Publisher until Thursday last week. When I try to run the task, it starts, but hangs just a couple of Seconds after the relaod has started. When i og to task manager, I can see qvconnect64 running. When I stop the task, or the task goes to timeout, qvconnect64 is still hanging, and I have to end the process manually. The same thing happens if I try to reload the document manually using QV desktop. But if I try multiple times with QV desktop, it will suddenly reload ok once, and then NeXT time it would run forever. I tried both ODBC and OLE DB, both with the same result.
Does any one have any idea to why this is happening? The document was reloading ok before. It's not even a large document, it reloads in under 1 minute when its working.
yo do need to check joins left joins i mean data model
try use distinct after all load statement
hope this helps
I just executed the sql in PL/SQL Developer, and it was ok.
What version are you running of QlikView Server?
I am running server 11.20 SR7 on server 2012 and desktop for win8 11.20 SR7
Hi Carolyn,
You must refine your query.
By using load * it will try to retrieve all possible values. It can take ages.
You must use load without the *
You should use something like:
Load
From
Where
with the appropriate query parameters you may want to use
Hi,
Your reply works for me.
Thanks.
Vinod