Reload does not complete, just hangs after load *

[carolynkarl]

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.

[SunilChauhan]

yo do need to check joins left joins  i mean data model

try use distinct after all load statement

hope this helps

[carolynkarl]

I just executed the sql in PL/SQL Developer, and it was ok.

[#4]

What version are you running of QlikView Server?

[carolynkarl]

I am running server 11.20 SR7 on server 2012 and desktop for win8 11.20 SR7

[Anonymous]

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

[vinod22kv]

Hi,

Your reply works for me.

Thanks.

Vinod