Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

zagzebski
Not applicable

Execution of Script Failure

I have never had this happen. My QVW was working fine then all of a sudden no matter what I do if gives me the "Execution of Script Failed. Reload old data?" message.

I even excited the script immediately just to see what happens and still got the message. (Right after the SET values on the first tab).

I create a brand new blank file and just made the connection to the same Access Database I was using ran it to check and it ran fine.

Anyone know why this would happen, or what to look for?

7 Replies
rustyfishbones
Not applicable

Re: Execution of Script Failure

Check that you are not missing a ;(semi-colon) after the SET statement or any other statement.

You may have deleted one by mistake, it has happenned to me lots of times

Regards

Alan

zagzebski
Not applicable

Re: Execution of Script Failure

Thanks for the response. Nope everything ok there.

Can a file get corrupted?

I literally copied and paste the first two tabs of my file that ISNT working into the sample one I create. When I ran the sample one it was fine - no "Execution of Script Faile..." problem.  Is there a setting or something that I need to look at. Thiis is ridiculous!

rustyfishbones
Not applicable

Re: Execution of Script Failure

are you using Personal Edition?

zagzebski
Not applicable

Re: Execution of Script Failure

nope - on QV server

zagzebski
Not applicable

Re: Execution of Script Failure

Alan -

Kind of weird but I ran debug on the data in the new sample file and in the dialog box I got the following. Then below this I put what I got in my other dialog box from the file that is erroring out...ALL KINDS OF STUFF even though the script is identical and all I am running the debug on just the connection, then exiting the script.:

DayNames   "Mon;Tue;Wed;Thu;Fri;Sat;Sun"
MonthNames "Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec"
TimestampFormat "M/D/YYYY h:mm:ss[.fff] TT"
DateFormat "M/D/YYYY"
TimeFormat "h:mm:ss TT"
MoneyFormat     "$#,##0.00;($#,##0.00)"
MoneyDecimalSep "."
MoneyThousandSep     ","
DecimalSep "."
ThousandSep     ","
OpenUrlTimeout  86400
WinPath    "C:\Windows"
ScriptErrorList ""
ScriptError    
StripComments   1
ErrorMode  1
WinRoot    "C:"
QvWorkPath "S:\Development\UserApplications\AGN\AGN SC-Insight 2.0"
QvWorkRoot "S:"
QvPath     "C:\PROGRA~1\QlikView"
QvRoot     "C:"
CD   "D:"
CD2  "E:"
ScriptErrorCount     0
FLOPPY     "A:"

THE CORRUPT FILE HAS THIS - IS THERE SOMETHING CAUGHT UP IN THIS FILE??:

DayNames   "Mon;Tue;Wed;Thu;Fri;Sat;Sun"
MonthNames "Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec"
TimestampFormat "M/D/YYYY h:mm:ss[.fff] TT"
DateFormat "M/D/YYYY"
TimeFormat "h:mm:ss TT"
MoneyFormat     "$#,##0.00;($#,##0.00)"
MoneyDecimalSep "."
MoneyThousandSep     ","
DecimalSep "."
ThousandSep     ","
OpenUrlTimeout  86400
WinPath    "C:\Windows"
ScriptErrorList ""
ScriptError    
StripComments   1
ErrorMode  1
WinRoot    "C:"
QvWorkPath "S:\Development\UserApplications\AGN\AGN SC-Insight 2.0"
QvWorkRoot "S:"
QvPath     "C:\PROGRA~1\QlikView"
QvRoot     "C:"
CD   "D:"
CD2  "E:"
ScriptErrorCount     0
FLOPPY     "A:"
vDataDirectory  "C:\Users\ccammers\Dropbox\BoehringerIngelheim\Insight\"
vSurveyDefDoc   "C:\Users\ccammers\Dropbox\BoehringerIngelheim\Insight\SurveyDefinitions\Survey Definitions.xlsx"
vResultDirectory     "C:\Users\ccammers\Dropbox\BoehringerIngelheim\Insight\SurveyResponse\"
i    1
vSurveyNum 2000
vSurveyFile     "C:\Users\ccammers\Dropbox\BoehringerIngelheim\Insight\SurveyResponse\All TA raw data - Final 7.27.xlsx"
vIntroTab  ""
vDataTab   "Sheet 1"
vStatisticsTab  "StatusLog-Invite-188474-2012-07"
vResponseFileName    "C:\Users\ccammers\Documents\Scientific Comercialization\Data\Raw\QlikView Data\SurveyResponse\"
vIntroductionTab     ""
vSurveyNumber   5000
vRowCount  3
vColumnName     "Viewed"
vColumnValue    "'96'"
vTableStatement "concatenate([Status Log])"
vNumSurveys     ""
2677153    2677153
vNumColumns     18
vLoadList  "[Survey Number] & '-' & as ResponseIdentity, as [2000-20], as [2000-21], as [2000-22], as [2000-23], as [2000-24], as...






















































































as [ResponseIdentity]"
idcols.i   2
vIdPosition     1
vDataColName    "A"
vNumPositions   98
Position.i ...













as [ResponseIdentity]"
subRawDataColumn     "BC"
subPosition     55
subQuestionNum  1
vPathIndicator  "...




















rustyfishbones
Not applicable

Re: Execution of Script Failure

I am not sure,

But I noticed this in the text

THE CORRUPT FILE HAS THIS - IS THERE SOMETHING CAUGHT UP IN THIS FILE??:

Was that part of the log file, or did you put that in the Text above yourself?


zagzebski
Not applicable

Re: Execution of Script Failure

No that was the start of what the corrupt files log was saying.