Execution script fail error

[maneshkhottcpl]

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.

[Anonymous]

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.

[deepakk · Accepted solution]

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).

[maneshkhottcpl]

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