7 Replies Latest reply: Jul 27, 2013 10:27 AM by Steve Zagzebski RSS

    Execution of Script Failure

    Steve Zagzebski

      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?

        • Re: Execution of Script Failure
          Alan Farrell

          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

            • Re: Execution of Script Failure
              Steve Zagzebski

              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!

                • Re: Execution of Script Failure
                  Alan Farrell

                  are you using Personal Edition?

                    • Re: Execution of Script Failure
                      Steve Zagzebski

                      nope - on QV server

                      • Re: Execution of Script Failure
                        Steve Zagzebski

                        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] & '-' & [A] as ResponseIdentity, [T] as [2000-20], [U] as [2000-21], [V] as [2000-22], [W] as [2000-23], [X] as [2000-24], [Y] as [2000-25], [Z] as [2000-26], [AA] as [2000-27], [AB] as [2000-28], [AC] as [2000-29], [AD] as [2000-30], [AE] as [2000-31], [AF] as [2000-32]"
                        vQuestionDefinitionTab    "Question Definition"
                        vSurveyDataTab  "20120720153043-SurveyExport"
                        vDimColumnCount 13
                        vRespColPosition     32
                        vRespSourceCol  "AF"
                        vRespColLabel   "2000-32"
                        vIdentityColCount    1
                        vThisIdCol "A"
                        vQuantQList     "'1000-33', '1000-34', '1000-35', '1000-36', '1000-37', '1000-38', '1000-39', '1000-40', '1000-41', '1000-42', '1000-43', '1000-44', '1000-45', '1000-46', '1000-47', '1000-48', '1000-49', '1000-50', '1000-51', '1000-52', '1000-53', '1000-54', '1000-55', '1000-56', '1000-57', '1000-58', '1000-59', '1000-60', '1000-61', '1000-62', '1000-63', '1000-64', '1000-65', '1000-66', '1000-67', '1000-68', '1000-69', '1000-70', '1000-71', '1000-72', '2000-33', '2000-34', '2000-35', '2000-36', '2000-37', '2000-38', '2000-39', '2000-40', '2000-41', '2000-42', '2000-43', '2000-44', '2000-45', '2000-46', '2000-47', '2000-48', '2000-49', '2000-50', '2000-51', '2000-52', '2000-53', '2000-54', '2000-55', '2000-56', '2000-57', '2000-58', '2000-59', '2000-60', '2000-61', '2000-62', '2000-63', '2000-64', '2000-65'"
                        vTextQList "'1000-20', '1000-21', '1000-22', '1000-23', '1000-24', '1000-25', '1000-26', '1000-27', '1000-28', '1000-29', '1000-30', '1000-31', '1000-32', '2000-20', '2000-21', '2000-22', '2000-23', '2000-24', '2000-25', '2000-26', '2000-27', '2000-28', '2000-29', '2000-30', '2000-31', '2000-32'"
                        vRankQList "'2677153-56', '2677153-57', '2677153-58', '2677153-59', '2677153-60', '2677256-56', '2677256-57', '2677256-58', '2677256-59', '2677256-60', '2677256-61', '2677256-62', '2677256-63'"
                        ProcessSurveys.i     3
                        2677256    2677256
                        vTableCount     0
                        CleanUp.i  7
                        CleanUp.Tname   ""
                        vQuestionField  "Finish Time"
                        vShowThing 1
                        vProtectedNameCount  0
                        vSPCount   3
                        LoadSalesForceData.i 4
                        vFieldList "SalesForceRecordNumber, Trim(Subfield([Standard Practice],';',1)) as SP_1, Trim(Subfield([Standard Practice],';',2)) as SP_2, Trim(Subfield([Standard Practice],';',3)) as SP_3"
                        vMaskData  "Yes"
                        vDocumentPath   "C:\Users\ccammers\Dropbox\BoehringerIngelheim\Insight\"
                        vIncludeSalesForce   "No"
                        vShowDevObjects "no"
                        vTableNameArray "'ResponseDimensions', 'SalesForce'"
                        vFieldName "MSL Name"
                        tbl  "SalesForce"
                        vCount     5266
                        ProtectTheInnocent.i 5267
                        vCurVal    "Jonathan Daitch"
                        vBeginDate 40179
                        vEndDate   40999
                        vMaskedWhere    "Where 1=1 "
                        SurveyResponseQuantitativeData.i     ""
                        1000 1000
                        vStatusLogFile  "C:\Users\ccammers\Dropbox\SC-Insight\Data\Survey Data\Master\SurveyResponse\RSD Status Log 11.23.12 - FINAL.xlsx"
                        2000 2000
                        vCustomer  "Allergan"
                        vUser "Neal"
                        ENV_QV_SERVER   "C:\Users\Neal\Dropbox\SC-Insight\Development\"
                        ENV_IS_DEV 1
                        ENV_FTP_PATH    "C:\Users\Neal\Dropbox\SC-Insight\Development\FTP\"
                        ENV_QV_USER_DOCS     "C:\Users\Neal\Dropbox\SC-Insight\Development\UserApplications\"
                        ENV_QV_DATA     "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\"
                        ENV_QV_DATA_MODELS   "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Data Models\"
                        ENV_QV_EXTERNAL_DATA "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\ExternalData\"
                        ENV_QV_FINAL_STAGE   "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Final Stage\"
                        ENV_QV_LOAD_SCRIPTS  "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Load Scripts\"
                        ENV_QV_RAW_STAGE     "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Raw\"
                        ENV_QV_STAGE    "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Stage\"
                        ENV_QV_SYSTEM_STAGE  "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\System Stage\"
                        ENV_APPLICATION_INTERFACE_DIR   "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\ApplicationInterface\"
                        ENV_QV_DATA_COMMON   "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Common\"
                        ENV_QV_SURVEY_DATA   "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Survey Data\"
                        ENV_QV_RAW_APPLICATION_DATA     "C:\Users\ccammers\Dropbox\SC-Insight\Data\Raw\Applications\"
                        ENV_QV_RAW_APPLICATION_HIST     "C:\Users\ccammers\Dropbox\SC-Insight\Data\Raw\Applications\Historical\"
                        ENV_QV_FS_APPLICATION_DATA "C:\Users\ccammers\Dropbox\SC-Insight\Data\Final Stage\Applications\"
                        ENV_QV_RAW_ACTUARIALCERT_DATA   "C:\Users\ccammers\Dropbox\SC-Insight\Data\Raw\ActuarialCertificates\"
                        ENV_QV_RAW_ACTUARIALCERT_HIST   "C:\Users\ccammers\Dropbox\SC-Insight\Data\Raw\ActuarialCertificates\Historical\"
                        ENV_QV_STAGE_ACTUARIALCERT "C:\Users\ccammers\Dropbox\SC-Insight\Data\Stage\ActuarialCertificates\"
                        ENV_QV_STAGE_ACTUARIALCERT_HEADERS   "C:\Users\ccammers\Dropbox\SC-Insight\Data\Stage\ActuarialCertificates\Headers\"
                        ENV_QV_STAGE_ACTUARIALCERT_RIDERS    "C:\Users\ccammers\Dropbox\SC-Insight\Data\Stage\ActuarialCertificates\Riders\"
                        ENV_QV_FS_ACTUARIALCERT_DATA    "C:\Users\ccammers\Dropbox\SC-Insight\Data\Final Stage\ActuarialCertificates\"
                        ENV_QV_FS_CURRENCY   "C:\Users\ccammers\Dropbox\SC-Insight\Data\Final Stage\Currency Exchange Rates\"
                        ENV_QV_RS_HISTORICAL "C:\Users\ccammers\Dropbox\SC-Insight\Data\Raw\Historical Data\"
                        ENV_QV_RAW_GROUPTERM "C:\Users\ccammers\Dropbox\SC-Insight\Data\Raw\GroupTermLife\"
                        ENV_QV_RAW_GROUPTERM_HIST "C:\Users\ccammers\Dropbox\SC-Insight\Data\Raw\GroupTermLife\Historical\"
                        ENV_QV_STAGE_GROUPTERM    "C:\Users\ccammers\Dropbox\SC-Insight\Data\Stage\GroupTermLife\"
                        ENV_QV_FS_GROUPTERM  "C:\Users\ccammers\Dropbox\SC-Insight\Data\Final Stage\GroupTermLife\"
                        ENV_QV_RAW_COMMON    "C:\Users\ccammers\Dropbox\SC-Insight\Data\Raw\Common\"
                        ENV_QV_RAW_COMMON_HIST    "C:\Users\ccammers\Dropbox\SC-Insight\Data\Raw\Common\Historical\"
                        ENV_QV_STAGE_COMMON  "C:\Users\ccammers\Dropbox\SC-Insight\Data\Stage\COMMON\"
                        ENV_QV_FS_COMMON     "C:\Users\ccammers\Dropbox\SC-Insight\Data\Final Stage\COMMON\"
                        ENV_QV_RAW_DISABILITY     "C:\Users\ccammers\Dropbox\SC-Insight\Data\Raw\Disability\"
                        ENV_QV_RAW_DISABILITY_HIST "C:\Users\ccammers\Dropbox\SC-Insight\Data\Raw\Disability\Historical\"
                        ENV_QV_STAGE_DISABILITY   "C:\Users\ccammers\Dropbox\SC-Insight\Data\Stage\Disability\"
                        ENV_QV_FS_DISABILITY "C:\Users\ccammers\Dropbox\SC-Insight\Data\Final Stage\Disability\"
                        vSACalendarOverride  "='[' & Concat({1<$Table = {"MasterCalendar"}>}$Field,'] = , [') & '] ='"
                        vSurveyResponseData  "C:\Users\ccammers\Dropbox\SC-Insight\Data\Survey Data\Master\SurveyResponse\"
                        vSurveyDefinitionData     "C:\Users\ccammers\Dropbox\SC-Insight\Data\Survey Data\Master\SurveyDefinitions\"
                        vSurveyCount    5
                        vDataFileName   "C:\Users\ccammers\Dropbox\SC-Insight\Data\Survey Data\Master\SurveyResponse\RSD Data Export 11.23.12 - FINAL.xlsx"
                        vStatusLogTab   "StatusLog-Invite-212900-2012-11"
                        vIdColCount     1
                        vIdentityExpression  "5000 & '-' & [A] as [ResponseIdentity]"
                        idcols.i   2
                        vIdPosition     1
                        vDataColName    "A"
                        vNumPositions   98
                        Position.i 99
                        vPositionNum    98
                        vRawDataColumn  "CT"
                        vResponseType   "Dimension"
                        vQuestionCategory    "Dimension"
                        vQuestionNum    ""
                        vSurvey.i  6
                        subSurveyNumber 1000
                        subStatusLogFile     "C:\Users\ccammers\Dropbox\SC-Insight\Data\Survey Data\Allergan\SurveyResponse\EC Status Log 11.9.12 - Final.xlsx"
                        subStatusLogTab "StatusLog-Invite-209990-2012-11"
                        subFieldNum     35
                        subStatusLogFieldExpression     "5000 & '-' & RecNo() as [Status Log ID], 5000 & '-' & [Response ID] as [ResponseIdentity], 5000 as [Survey Number], 1 as [Status Counter], [Campaign] as [Status Log Campaign], [Email] as [Status Log Email], [First Name] as [Status Log First Name], [Last Name] as [Status Log Last Name], [Email Status] as [Status Log Email Status], [Response Status] as [Status Log Response Status], [Contact Status] as [Status Log Contact Status], [Invite Link] as [Status Log Invite Link], [Response ID] as [Status Log Response ID], [Customer Contact ID] as [Status Log Customer Contact ID], [Organization] as [Status Log Organization], [Department] as [Status Log Department], [Phone (Home)] as [Status Log Phone (Home)], [Phone (Fax)] as [Status Log Phone (Fax)], [Phone (Work)] as [Status Log Phone (Work)], [Address] as [Status Log Address], [Suite/Apt] as [Status Log Suite/Apt], [City] as [Status Log City], [Region] as [Status Log Region], [Postal Code] as [Status Log Postal Code], [Country] as [Status Log Country], [Job Title] as [Status Log Job Title], [Website] as [Status Log Website], [Invite Custom Field 1] as [Status Log Invite Custom Field 1], [Invite Custom Field 2] as [Status Log Invite Custom Field 2], [Invite Custom Field 3] as [Status Log Invite Custom Field 3], [Invite Custom Field 4] as [Status Log Invite Custom Field 4], [Invite Custom Field 5] as [Status Log Invite Custom Field 5], [Invite Custom Field 6] as [Status Log Invite Custom Field 6], [Invite Custom Field 7] as [Status Log Invite Custom Field 7], [Invite Custom Field 8] as [Status Log Invite Custom Field 8], [Invite Custom Field 9] as [Status Log Invite Custom Field 9], [Invite Custom Field 10] as [Status Log Invite Custom Field 10]"
                        subCurField     "Invite Custom Field 10"
                        subTableEnd     "Yes"
                        subIdentityExpression     "[A] as [ResponseIdentity]"
                        subRawDataColumn     "BC"
                        subPosition     55
                        subQuestionNum  1
                        vPathIndicator  "CustNameNotFoundInFilePath"
                        vMSLLabel  "RSS Name"
                        vSurveyTextReplaceValue   "the RSS"
                        ENV_QV_DATA_RAW_HISTORY   "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\RawHistorical\"
                        ENV_QV_DATA_SURVEYLOG_PATH "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\SurveyProcessingLogs\"
                        ENV_QV_SURVEY_STAGE  "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Stage\Surveys\"
                        ENV_QV_STAGE_SURVEY  "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Stage\Surveys\"
                        ENV_QV_STAGE_SURVEY_QUESTIONS   "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Stage\Surveys\Questions\"
                        ENV_QV_STAGE_SURVEY_ANSWERS     "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Stage\Surveys\ResponseAnswers\"
                        ENV_QV_STAGE_SURVEY_DIMENSIONS  "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Stage\Surveys\ResponseDimensions\"
                        ENV_QV_STAGE_SURVEY_STATUSLOG   "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Stage\Surveys\StatusLog\"
                        ENV_QV_STAGE_SURVEY_DEFINITION  "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Stage\Surveys\SurveyDefinition\"
                        ENV_QV_STAGE_CRM     "C:\Users\Neal\Dropbox\SC-Insight\Development\Data\Stage\CRM\"
                        vTheraputicAreaTable "C:\Users\Neal\Dropbox\SC-Insight\Development\FTP\AGN\"
                        vCustomerAbbr   "AGN"
                        ENV_QV_GRAPHICS "C:\Users\Neal\Dropbox\SC-Insight\Development\Graphics\"
                        vMinDate   40590
                        vMaxDate   41369
                        vToday     4/17/2013
                        vHolidayList     "'1/1/2012','1/1/2013','1/1/2014','11/22/2012','11/23/2012','11/27/2014','11/28/2013','11/28/2014','11/29/2013','12/24/2012','12/25/2012','12/25/2013','12/25/2014','12/26/2013','12/27/2013','12/31/2012','2/17/2014','2/18/2013','2/20/2012','3/29/2013','4/11/2012','4/18/2014','5/26/2014','5/27/2013','5/28/2012','7/4/2012','7/4/2013','7/4/2014','7/5/2013','9/1/2013','9/2/2013','9/3/2012'"
                        ScriptErrorDetails   <NULL>