topic Re: Script failed without any error. in QlikView

Script failed without any error.

ajaykumar1 — Fri, 15 Nov 2013 07:18:08 GMT

Hi All,

I have the 2 qvd's which contains the date field namely Date_end(Extractor level) which contains data from March 2008 to Nov 2013 and the date format type is 03/01/2013.

I need to fetch the data only for last 13 months with the use of Date_end.(which is coming from already existing qvd and using at extractor level)

After fetching that 13 months data with 'where' clause then i have to use that Date_end field as Period in application level.(Report level).

I have used the the where clause at extractor level to fetch only 13 months data.It is showing "script failed and reload old data" without any error.

Sample data attached here.

Thanks

Ajay Kumar

Re: Script failed without any error.

kaushiknsolanki — Fri, 15 Nov 2013 07:26:23 GMT

Hi,

QVD 1 and QVD2 both as almost same data, why you need duplicate data?

And even if you want you can use the concatenate instead of join.

Regards,

Kaushik Solanki

Re: Script failed without any error.

ajaykumar1 — Fri, 15 Nov 2013 08:30:05 GMT

Thanks..I will the try the same....But in my original data i have the different fields also between QVD1 and QVD2.The result of the join , i have to use in some other QVD level.

If am trying to fetch last 13 months data from QVD (at extractor level) am getting the above problem Otherwise script runs successfully.

What might be the possible causes to get the problem like "Script failed and reload old data".(Not showing any error while debugging).

Thanks,

Ajay Kumar

Re: Script failed without any error.

kaushiknsolanki — Fri, 15 Nov 2013 08:38:38 GMT

Hi,

Its hard to say the reason for the error without actually looking at your script.

So if possible share the script.

Regards,

Kaushik Solanki