Script qvw just goes away

[#1]

Hi Everyone,

I have a script I've created that does loading operations...for the most part loading data from the database (through ODBC) and putting it into QVD files.

Quite often I see QV simply stop processing in the following manner:

SQL

10/2/2014 10:40:34 AM: 2047       select

10/2/2014 10:40:34 AM: 2048       col1

....

10/2/2014 10:40:34 AM: 2052       from

10/2/2014 10:40:34 AM: 2053       table1

10/2/2014 10:40:34 AM: 2054       inner join table2

10/2/2014 10:40:34 AM: 2055       on a = a

10/2/2014 10:40:34 AM: 2056          inner join table 2

10/2/2014 10:40:34 AM: 2057       on ot.object_id = oc.parent_id

10/2/2014 10:40:34 AM: 2058       where

10/2/2014 10:40:34 AM: 2059       c is null

10/2/2014 10:40:34 AM: 2060       a.col('ST','UT')

10/2/2014 10:40:34 AM: 2061       group by

10/2/2014 10:40:34 AM: 2062       col1 ...

10/2/2014 10:55:23 AM:           4 fields found: col1, col2, col3, col4

And then nothing. Sometime it runs (and it will return millions of rows), but sometimes QV just stops there. I'm tracking it using the logs and I'm not sure to see why or what it's doing. I've seen it happen with other SQL Statements, but there's no rhyme or reason.

Does anyone have any advice on where to look next?

[#2]

No, the database is remote and is being called via ODBC connection. Oracle.

[jerrysvensson]

I was talking about QlikView. Publisher and Server on same machine?

Developer, if you don't have Publisher,

[#4]

So I have a QV Server & WebServer and then I have desktop to open the documents and run them manually. Server comes with a scheduled reload that I use also. No Developer, no Publisher. 

[jerrysvensson]

OK

Desktop and Developer, same thing.

So your reloads runs (scheduled reload bat) on the same server as QlikView server resides on?

If your QlikView server is heavily used and you try to reload at the same time, there will be a less CPU for your reload. Could affect the loading process very much.

Can you try to reload during night when nobody is using QlikView Server?