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.
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 |
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
Hi
I've enabled the log file, but the log file shows no errors. Actually there is nothing in the log after "Load *"
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
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.
Hi
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.
Hi
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
Hi
The log does not conaint any thing after "load * ".
Hi,
Try by loading few records and introduce error mode.
Regards
ASHFAQ