QlikView error while creating QVD file

[#1]

i have a view in my database (Oracle) and I use this view to export data to a QVD file. I use QlikView for exporting to this QVD via a QVW file, and I want to automatically run it 2 times every day.

So I put it onto a server and I scheduled it to run 2 times every day. When I run the QVW script manually, it exports the correct QVD file. However, when it is scheduled, I have an error like this in the log file:

     QVX_UNEXPECTED_END_OF_DATA:
     Error: OLEDB read failed
     General Script Error
     Execution Failed
     Execution finished.

i tried to run for each column (in my view) one by one. My problem is in the WHERE clause:

     select ...
     from ...
     where ...
     and ACTUAL_DATE  >= to_date(sysdate, 'dd.MM.YYYY hh24:mi:ss')


I removed this "ACTUAL_DATE >= to_date(sysdate, 'dd.MM.YYYY hh24:mi:ss')" and it runs perfectly, but when I add this clause back, I get an error.

What could I do to solve this?

[Gabriel]

Hi,

Your date format is not aligned.

SET DateFormat='DD.MM.YYYY';

SET TimestampFormat='DD.MM.YYYY h:mm:ss[.fff]TT';

    and ACTUAL_DATE  >= to_date(sysdate, 'dd.MM.YYYY hh24:mi:ss')

[#3]

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='DD.MM.YYYY';

SET TimestampFormat='DD.MM.YYYY h:mm:ss[.fff]TT';

SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

OLEDB CONNECT TO [Provider=xxxxxx;UserID=xxxxxxxx;DataSource=xxxxxxx] (XPassword is xxxxxxxx);

TIMESHEETS:

load *;

SQL
SELECT *

FROM  TIMESHEETS_VIEW;
store VFACT_QLIKV_TIMESHEETS3 into   \\qvd\TIMESHEETS.qvd;

REQUESTS :

load *;

SQL
SELECT *
FROM  REQUEST_VIEW;
store REQUESTS into  \\qvd\REQUESTS.qvd;

drop tables REQUESTS, TIMESHEETS

[PrashantSangle]

Hi,

In provided script i did not found any Where clause

which cause for Unexpected End of Data.

Also there is incomplete store statement.

Regards