Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, new to qlikview and did not see an issue exactly like mine. I am attempting to import Excel data into Qlikview; when I complete the wizard I get the "Execution script failed" and it asked if I would like to load old data, not matter if I click yes or no I am presented with a blank page. I do not even have a debug option. The excel file I am importing does contain links, could that be the issue?
I doubt that links would cause a problem, but it would be simple enough to create a test file to find out.
The problems is more caused by your data. Can you attach a sample file that would demonstrate the problem?
sorry to be a newb, but i dont see how to attach a file. However; below is a sample of the data and i actually dont have links.
UTID | UT Name | UT Risk | UT Status | Registration Status | Activation Date | Country | LOB | Sub-LOB 1 | Sub-LOB 2 | UT Owner Name | UT Backup Owner Name | Business Champion Name | UT Owner SID | UT Backup Owner SID | Business Champion SID | Remaining / Coming Due UT Actions | Days in Proposed Status | Days Since Last Annual Review | Days since last Integrity Review | Days since last Risk Classification | Control Ageing | Initial Controls Complete | Annual Control Review | Access Control | Backup Control | Change Control | Documentation | Integrity Review | Version Control | Access Status | UT Path | Model Flag | Created On |
100000 | Sample tool 1 | MEDIUM | Active | Valid | 1/1/2018 | UNITED STATES | sample lob11 | sample lob21 | sample lob 23 | john doe 1 | jane doe 1 | jim doe 1 | X111111 | Z111111 | Y11111 | 0 | 132 | 118 | Yes | Complete | Complete | Complete | Complete | Complete | Complete | Pending ITSM | \\sample file path 1 | 8/9/2012 | |||||
100001 | Sample tool 2 | MEDIUM | Active | Valid | 1/2/2018 | UNITED STATES | sample lob11 | sample lob21 | sample lob 23 | john doe 2 | jane doe 2 | jim doe 2 | X111112 | Z111112 | Y11112 | 0 | 132 | 118 | Yes | Complete | Complete | Complete | Complete | Complete | Complete | Pending ITSM | \\sample file path 2 | 8/10/2012 | |||||
100002 | Sample tool 3 | MEDIUM | Active | Valid | 1/3/2018 | UNITED STATES | sample lob11 | sample lob21 | sample lob 23 | john doe 3 | jane doe 3 | jim doe 3 | X111113 | Z111113 | Y11113 | 0 | 132 | 118 | Yes | Complete | Complete | Complete | Complete | Complete | Complete | Pending ITSM | \\sample file path 3 | 8/11/2012 | |||||
100003 | Sample tool 4 | MEDIUM | Active | Valid | 1/4/2018 | UNITED STATES | sample lob11 | sample lob21 | sample lob 23 | john doe 4 | jane doe 4 | jim doe 4 | X111114 | Z111114 | Y11114 | 0 | 132 | 118 | Yes | Complete | Complete | Complete | Complete | Complete | Complete | Pending ITSM | \\sample file path 4 | 8/12/2012 | |||||
100004 | Sample tool 5 | MEDIUM | Active | Valid | 1/5/2018 | UNITED STATES | sample lob11 | sample lob21 | sample lob 23 | john doe 5 | jane doe 5 | jim doe 5 | X111115 | Z111115 | Y11115 | 0 | 132 | 118 | Yes | Complete | Complete | Complete | Complete | Complete | Complete | Pending ITSM | \\sample file path 5 | 8/13/2012 | |||||
100005 | Sample tool 6 | MEDIUM | Active | Valid | 1/6/2018 | UNITED STATES | sample lob11 | sample lob21 | sample lob 23 | john doe 6 | jane doe 6 | jim doe 6 | X111116 | Z111116 | Y11116 | 0 | 132 | 118 | Yes | Complete | Complete | Complete | Complete | Complete | Complete | Pending ITSM | \\sample file path 6 | 8/14/2012 | |||||
100006 | Sample tool 7 | MEDIUM | Active | Valid | 1/7/2018 | UNITED STATES | sample lob11 | sample lob21 | sample lob 23 | john doe 7 | jane doe 7 | jim doe 7 | X111117 | Z111117 | Y11117 | 0 | 132 | 118 | Yes | Complete | Complete | Complete | Complete | Complete | Complete | Pending ITSM | \\sample file path 7 | 8/15/2012 | |||||
100007 | Sample tool 8 | MEDIUM | Active | Valid | 1/8/2018 | UNITED STATES | sample lob11 | sample lob21 | sample lob 23 | john doe 8 | jane doe 8 | jim doe 8 | X111118 | Z111118 | Y11118 | 0 | 132 | 118 | Yes | Complete | Complete | Complete | Complete | Complete | Complete | Pending ITSM | \\sample file path 8 | 8/16/2012 | |||||
100008 | Sample tool 9 | HIGH | Active | Valid | 1/9/2018 | UNITED STATES | sample lob11 | sample lob21 | sample lob 23 | john doe 9 | jane doe 9 | jim doe 9 | X111119 | Z111119 | Y11119 | 0 | 132 | 118 | Yes | Complete | Complete | Complete | Complete | Complete | Complete | Pending ITSM | \\sample file path 9 | 8/17/2012 | |||||
100009 | Sample tool 10 | HIGH | Active | Valid | 1/10/2018 | UNITED STATES | sample lob11 | sample lob21 | sample lob 23 | john doe 10 | jane doe 10 | jim doe 10 | X111120 | Z111120 | Y11120 | 0 | 132 | 118 | Yes | Complete | Complete | Complete | Complete | Complete | Complete | Pending ITSM | \\sample file path 10 | 8/18/2012 |
Can you try to load it through script? instead of a wizard.
not really sure how to do that
You'll want to review the script document log to determine where the failure occurred.
1. Ensure Document Logging is turned on: Settings, Document Properties, General. Check on "generate logfile".
2. Reload the document and then review the log file. The logfile is on the same folder as the qvw and will have the same name as the qvw with a ".log" extension. eg for "Sales.qvw' the log will be "Sales.qvw.log".
if you can't determine what the problem is, post the log here for us to look at. "Execution script failed" is the dreaded unhandled error so it's likely you may need some help determining the exact cause.
-Rob
Got the log, had to exit the window and not click yes or no.
2018-01-18 09:22:40 Execution started.
2018-01-18 09:22:40 QlikView Desktop Version 12.10.20400+2017-05-05 15:41:24.HEAD.Component.Version
2018-01-18 09:22:40 CPU Target x64
2018-01-18 09:22:40 Operating System Windows 7 Enterprise Service Pack 1 (64 bit edition)
2018-01-18 09:22:40 Wow64 mode Not using Wow64
2018-01-18 09:22:40 Language 0409 English (United States) English
2018-01-18 09:22:40 Country 1 United States United States
2018-01-18 09:22:40 MDAC Version 6.1.7601.17514
2018-01-18 09:22:40 MDAC Full Install Version 6.1.7601.17514
2018-01-18 09:22:40 PreferredCompression 2
2018-01-18 09:22:40 EnableParallelReload 1
2018-01-18 09:22:40 ParallelizeQvdLoads 1
2018-01-18 09:22:40 AutoSaveAfterReload 0
2018-01-18 09:22:40 BackupBeforeReload 1
2018-01-18 09:22:40 EnableFlushLog 1
2018-01-18 09:22:40 SaveInfoWhenSavingFile 0
2018-01-18 09:22:40 UserLogfileCharset 65001
2018-01-18 09:22:40 OdbcLoginTimeout -1
2018-01-18 09:22:40 OdbcConnectionTimeout -1
2018-01-18 09:22:40 LongestPossibleLine 1048576
2018-01-18 09:22:40 MaxCoreMask -1
2018-01-18 09:22:40 ScriptWantsDbWrite false
2018-01-18 09:22:40 ScriptWantsExe false
2018-01-18 09:22:40 LogFile CodePage Used: 65001
2018-01-18 09:22:40 UseMemoryFillPattern 1
2018-01-18 09:22:40 ScriptMode Legacy (gives greater system access) (aka qv11 mode)
2018-01-18 09:22:40 SequentialThreadCount 678
2018-01-18 09:22:40 NumberOfCores (effective) 8
2018-01-18 09:22:40 ReloadCodebase Classic
2018-01-18 09:22:40 Reload Executed By NAEAST\n595405
2018-01-18 09:22:40 Process Executing QlikView Desktop
2018-01-18 09:22:40 Process ID 13164
2018-01-18 09:22:40 0002 SET ThousandSep=','
2018-01-18 09:22:40 0003 SET DecimalSep='.'
2018-01-18 09:22:40 0004 SET MoneyThousandSep=','
2018-01-18 09:22:40 0005 SET MoneyDecimalSep='.'
2018-01-18 09:22:40 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'
2018-01-18 09:22:40 0007 SET TimeFormat='h:mm:ss TT'
2018-01-18 09:22:40 0008 SET DateFormat='M/D/YYYY'
2018-01-18 09:22:40 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'
2018-01-18 09:22:40 0010 SET FirstWeekDay=6
2018-01-18 09:22:40 0011 SET BrokenWeeks=1
2018-01-18 09:22:40 0012 SET ReferenceDay=0
2018-01-18 09:22:40 0013 SET FirstMonthOfYear=1
2018-01-18 09:22:40 0014 SET CollationLocale='en-US'
2018-01-18 09:22:40 0015 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
2018-01-18 09:22:40 0016 SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'
2018-01-18 09:22:40 0017 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
2018-01-18 09:22:40 0018 SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'
2018-01-18 09:22:40 Execution finished.
Found the column that was the issue by deleting some and rerunning... No idea why though, its just a column with numbers 0 - 2000