Re: Execution of Script Failure - Qlik Community

zagzebski · ‎2013-07-26

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?

rustyfishbones · ‎2013-07-26

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 · ‎2013-07-26

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 · ‎2013-07-26

are you using Personal Edition?

zagzebski · ‎2013-07-26

nope - on QV server

zagzebski · ‎2013-07-26

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 · ‎2013-07-26

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 · ‎2013-07-27

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