topic Re: Execution of Script Failed .Reload Old data Error message? in QlikView

Execution of Script Failed .Reload Old data Error message?

Thu, 19 Dec 2013 05:52:05 GMT

Hi ,

I am getting the following error message in QlikView when I do an incremental reload to an exsiting QVD:

Previous it was working Fine .I Just Loaded Previuos Month data thats it .I m getting this Error .I Enabled log files also .In log file it is showing GENERAL SCRIPT ERROR.May i know the reason .

Regards,

Divya

Re: Execution of Script Failed .Reload Old data Error message?

jagan — Thu, 19 Dec 2013 05:55:40 GMT

HI,

Check whether the QVD file exists in the given path or if you are using STORE command check that path is exists.

Regards,

Jagan.

Re: Execution of Script Failed .Reload Old data Error message?

Anonymous — Thu, 19 Dec 2013 05:57:27 GMT

There would be a scrip syntax error,

or if you have used any aggregate function then you have to use group by statement also which would be missing or incorrect.

Check your script at syntactic level.

It willbe resolved or provide use the view of your script....

Regards

Nitin

Re: Execution of Script Failed .Reload Old data Error message?

sujeetsingh — Thu, 19 Dec 2013 06:08:35 GMT

General error.

Check for qvd and related fields too.

Try to debug and see where this happens

Re: Execution of Script Failed .Reload Old data Error message?

Thu, 19 Dec 2013 06:12:47 GMT

QVD file exists or not and check syntax in the given particular STORE command.

Re: Execution of Script Failed .Reload Old data Error message?

Thu, 19 Dec 2013 06:32:28 GMT

Hi,

I am using Include Command for Loading datapaths .PFA

I did not changed any thing in the Code .Prevoius it was working fine yesterday i loaded data into that then it is showing this error .i have 5 intermediate Apps for that Final App Allthe the 5 are showing the Same error.

Regards

P.Divya

Re: Execution of Script Failed .Reload Old data Error message?

Anonymous — Thu, 19 Dec 2013 06:36:46 GMT

Can you provide a look of your script.?????

Re: Execution of Script Failed .Reload Old data Error message?

jagan — Thu, 19 Dec 2013 06:38:52 GMT

Hi,

All the paths exists

SET QlikView ='G:\Qlikview\';

SET QlikView_Data ='G:\Qlikview\Data\';

SET Raw_Data ='Raw_Qvds\';

SET Other_Sources ='Other_Source\';

SET Barnch_Sla ='Other_Source\SBI Master Branches_Avilablity\';

SET Model_Qvd ='Modelled_Qvds\';

SET C_Edge_Master ='Other_Source\C_Edge_Master\';

SET On_Off_Sites ='Other_Source\On-Off_Sites\';

Also, can you attach the file and script which you are using for reload.

Regards,

Jagan.

Re: Execution of Script Failed .Reload Old data Error message?

Thu, 19 Dec 2013 06:54:30 GMT

Hi,

all the paths are there.PFA

This is One of the Intermediate file .

Re: Execution of Script Failed .Reload Old data Error message?

Thu, 19 Dec 2013 07:30:09 GMT

Hi,

After doing debugging I am getting Error Can anyone Pls help me . how to resolve this error . it is Urgent bcoz it is already in Access point i have to upload the data

Barnch_Sla "Other_Source\SBI Master Branches_Avilablity\"

QlikView_Data "G:\Qlikview\Data\"

Model_Qvd "Modelled_Qvds\"

OpenUrlTimeout 86400

StripComments 1

ErrorMode 1

ScriptErrorCount 0

WinPath "C:\Windows"

QvWorkRoot "G:"

QvWorkPath "G:\QLIKVIEW\EXTRACTOR\INTERMEDIATE"

ScriptErrorList ""

QvRoot "C:"

QvPath "C:\Program Files\QlikView\Distribution Service"

WinRoot "C:"

ScriptError

CD "D:"

FLOPPY "A:"

Thanks in Advance

Re: Execution of Script Failed .Reload Old data Error message?

jagan — Thu, 19 Dec 2013 07:52:16 GMT

Hi,

Can you attach the log file.

Regards,

Jagan.

Re: Execution of Script Failed .Reload Old data Error message?

Thu, 19 Dec 2013 07:55:10 GMT

Hi Jagan,

PFA of Log File

Re: Execution of Script Failed .Reload Old data Error message?

stabben23 — Thu, 19 Dec 2013 09:28:52 GMT

Hi,

I Think the qvd file is "open"/used by another process. Close all other document that maybe use the qvd file.

It can also be that the sequrity has been changed at the folder where save your qvd.

//Staffan

Re: Execution of Script Failed .Reload Old data Error message?

danieloberbilli — Thu, 19 Dec 2013 09:44:22 GMT

Could it be that some of the files you include and try to change / re-store are locked as they are opened / used e.g. with an editor / Excel...?

Re: Execution of Script Failed .Reload Old data Error message?

Thu, 19 Dec 2013 09:54:05 GMT

Hi Daniel,

I did not Changed any script. I just uploaded data into the Qvd then I am getting this error

Re: Execution of Script Failed .Reload Old data Error message?

danieloberbilli — Thu, 19 Dec 2013 10:08:06 GMT

Maybe its a memory issue...is the data very big?

There is also an interesting reply from Jonathan Dienst to a similar problem in http://community.qlik.com/message/395705#395705

Quote from Jonathan Dienst:''

User does not have write access to the path specified

the path does not exist (the write command does NOT create the folder if it does not exist). If you have a space between $(qvdpath) and TableNm, this could be the problem.

The file name and path should be enclosed in square brackets if the path contains spaces. ie like [$(qvdpath)TableNm.qvd].

The file is locked and cannot be overwritten. This can be caused by a failed QV reload that was aborted, but left the QV.exe running. Close all instances of QV.exe processes in the task manager.

'' Quote end

Re: Execution of Script Failed .Reload Old data Error message?

Fri, 20 Dec 2013 09:42:35 GMT

Hi Daniel,

How can i know whether i am having write permissions or not.

Thanks in Advance

Re: Execution of Script Failed .Reload Old data Error message?

Fri, 20 Dec 2013 09:45:21 GMT

Hi ,

have you checked log File.Did you find any Solution let me know it is urgent.

Thanks in Advance

Re: Execution of Script Failed .Reload Old data Error message?

jagan — Fri, 20 Dec 2013 09:55:50 GMT

Hi,

There is no details about the error in the log file, it just has General script error. with this it is difficult to know the reason. One for sure it is whether the path is missing or you do not have access to the path.

Check the access in MyComputer and paste the path there, and check whether you have access to read and write, try to create a file there.

Regards,

Jagan.

Re: Execution of Script Failed .Reload Old data Error message?

Fri, 20 Dec 2013 10:16:52 GMT

Hi,

I have access I can read QVD and I can Create a File in that location.Lastmonth i Loaded data in QVD at that time it is working Fine . Right now i am getting this Error .

Recently one week back I have Provided Security for Final Application by using Section Access in Edit Script .is there any Problem because of Security.

Regards,

P.Divya