Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

QlikView error while creating QVD file

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?

Tags (2)
22 Replies

Re: QlikView error while creating QVD file

It sounds like an issue with missing access rights to the database and/or your (network)-storage from the user under which your server runs.

- Marcus

Re: QlikView error while creating QVD file

Proceeding where Marcus left off, you could run the script again but with an alternate WHERE cause, e.g. if this:

WHERE ACTUAL_DATE >= '01.01.2014';

runs without any errors, you know that it's sysdate that's causing trouble.

Peter

Re: QlikView error while creating QVD file

Could you share the whole load statement from your script ?

Gabriel
Valued Contributor II

Re: QlikView error while creating QVD file

Hi,

In your WHERE clause, your date format might be wrong.

Try date as 'YYY-MM-DD'

MVP
MVP

Re: QlikView error while creating QVD file

I would try these

1)

and ACTUAL_DATE  >= sysdate

2)

ODBC instead of OLEDB

3)

when you run the script manually, do you run it with the same user of the QlikView distrib service?

If not, maybe some settings (regional settings) are different?  

Not applicable

Re: QlikView error while creating QVD file

You don't need to tell Oracle to format the sysdate.

So 'ACTUAL_DATE  >= sysdate' should suffice

Not applicable

Re: QlikView error while creating QVD file

I already tried it, error is same

Not applicable

Re: QlikView error while creating QVD file

my date (ACTUAL_DATE) format is 'dd.mm.yyyy'. i am sure about that. i checked each data one by one.

Gabriel
Valued Contributor II

Re: QlikView error while creating QVD file

Hi,

In that case I have tried not formatting the sysdate?

Community Browser