topic Execution script fail error in QlikView

Execution script fail error

maneshkhottcpl — Thu, 24 Mar 2011 09:46:26 GMT

Hi,

I am facing two types of errors.

1. While i m loading the data from MS SQl server , loading data is working fine but showing the error while table store into QVD.(Execution script fail error).

2. The same error occuring at time of QVD loading. i.e While i am loading the qvd into the application with where clause its getting error.

I m using qv 9.0 SR 4 on leased licence.

Execution script fail error

Anonymous — Thu, 24 Mar 2011 10:04:39 GMT

Hi Manesh

First you create the correct folder structure like,

>>APPLICATION -->Application ie QVW File.

>>DATA -->qvd files.

>>ETL->you store the qvd generater appl..

and enable the relative path in the edit script.and store qvd as show below.

SQL SELECT *
FROM Part.Physical."V_Trans";

store * from Trans into ..\Data\Transtock.qvd;

It will help you.

Execution script fail error

deepakk — Thu, 24 Mar 2011 10:05:02 GMT

hi Manesh,

I have faced similar issue. In My Case the QVd was already in use.

Try changing the name of the QVd while stroing and loading.

Restarting the system might sort out this issue.

Or you need to go to Task manager and check if any Qlikview application is running or not (other the file which you have openend).

Execution script fail error

maneshkhottcpl — Thu, 28 Apr 2011 03:55:50 GMT

Hi Deepak,

The issue has been resolved.

Thanks for ur advise.

If QVD is in work then also this error comes, but u dont need to restart system, just close all qlikview application which are using the qvd.It is due to some script error while reloading the qvd into application.

In my case the virtual memory was less, i just increase the virtual memory and problem go away 🙂

Thanks agin