topic Re: Reload does not complete, just hangs after load * in QlikView

Reload does not complete, just hangs after load *

carolynkarl — Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: Reload does not complete, just hangs after load *

its_anandrjs — Wed, 02 Jul 2014 08:19:00 GMT

Check the document log files for error or add the error mode statement in the load script at the begining

set ErrorMode=0;

For more check the error mode list to add it manually due to some reasons the QV application hangs see this modes also.

0	No error
1	General error
2	Syntax error
3	General ODBC error
4	General OLE DB error
5	General custom database error
6	General XML error
7	General HTML error
8	File not found
9	Database not found
10	Table not found
11	Field not found
12	File has wrong format
13	BIFF error
14	BIFF error encrypted
15	BIFF error unsupported version
16	Semantic error

Re: Reload does not complete, just hangs after load *

ashfaq_haseeb — Wed, 02 Jul 2014 08:26:04 GMT

Hi,

Apart from what Anand have suggested.

Try to enable log file of document and see what does it shows.

Open your Qlikview document --> Document properties --> General tab --> Generate log file.

Regards

ASHFAQ

Re: Reload does not complete, just hangs after load *

carolynkarl — Wed, 02 Jul 2014 08:28:08 GMT

I've enabled the log file, but the log file shows no errors. Actually there is nothing in the log after "Load *"

Re: Reload does not complete, just hangs after load *

ashfaq_haseeb — Wed, 02 Jul 2014 08:33:51 GMT

Hi,

Look at the below location for your task.

C:\ProgramData\QlikTech\DistributionService\1\Log

Can you tell what does this log says.

did you find any error code?

Regards

ASHFAQ

Re: Reload does not complete, just hangs after load *

its_anandrjs — Wed, 02 Jul 2014 08:33:54 GMT

Try to introduce the error mode in application and then reload app and check it is hangs or not and then check the error logs what written there.

Re: Reload does not complete, just hangs after load *

Anonymous — Wed, 02 Jul 2014 08:49:52 GMT

this happened to me earlier. I had many tables which have many common columns, My data was such and then I just qualify *, that's it. It worked. If ur issue is similar then u can use this solution

HTH

Ravi N.

Re: Reload does not complete, just hangs after load *

carolynkarl — Thu, 03 Jul 2014 11:20:19 GMT

I tried this, since I am basically creating three identical tables with different where-statements. This did not solve my problem.

I've also upgraded both server and desktop to QlikView 11.20 SR7

Re: Reload does not complete, just hangs after load *

carolynkarl — Thu, 03 Jul 2014 11:21:27 GMT

The log does not conaint any thing after "load * ".

Re: Reload does not complete, just hangs after load *

ashfaq_haseeb — Thu, 03 Jul 2014 11:25:29 GMT

Hi,

Try by loading few records and introduce error mode.

Regards

ASHFAQ

Re: Reload does not complete, just hangs after load *

SunilChauhan — Thu, 03 Jul 2014 11:25:39 GMT

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

try use distinct after all load statement

hope this helps

Re: Reload does not complete, just hangs after load *

carolynkarl — Thu, 03 Jul 2014 11:29:26 GMT

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

Re: Reload does not complete, just hangs after load *

Thu, 03 Jul 2014 11:34:43 GMT

What version are you running of QlikView Server?

Re: Reload does not complete, just hangs after load *

carolynkarl — Thu, 03 Jul 2014 11:36:37 GMT

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

Re: Reload does not complete, just hangs after load *

Anonymous — Sat, 12 Jul 2014 21:35:54 GMT

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

Re: Reload does not complete, just hangs after load *

vinod22kv — Thu, 19 Jul 2018 07:47:38 GMT

Hi,

Your reply works for me.

Thanks.

Vinod