Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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!
are you using Personal Edition?
nope - on QV server
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,
idcols.i 2
vIdPosition 1
vDataColName "A"
vNumPositions 98
Position.i ...
as [ResponseIdentity]"
subRawDataColumn "BC"
subPosition 55
subQuestionNum 1
vPathIndicator "...
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?
No that was the start of what the corrupt files log was saying.