topic Re: execution script when importing excel in QlikView

execution script when importing excel

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: execution script when importing excel

m_woolf — Wed, 17 Jan 2018 20:50:23 GMT

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?

Re: execution script when importing excel

Anonymous — Wed, 17 Jan 2018 21:11:53 GMT

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

132

118

Yes

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

132

118

Yes

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

132

118

Yes

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

132

118

Yes

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

132

118

Yes

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

132

118

Yes

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

132

118

Yes

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

132

118

Yes

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

132

118

Yes

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

132

118

Yes

Complete

Pending ITSM

\\sample file path 10

8/18/2012

Re: execution script when importing excel

zebhashmi — Wed, 17 Jan 2018 21:17:36 GMT

Can you try to load it through script? instead of a wizard.

Re: execution script when importing excel

Anonymous — Wed, 17 Jan 2018 21:19:18 GMT

not really sure how to do that

Re: execution script when importing excel

rwunderlich — Wed, 17 Jan 2018 22:51:11 GMT

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

http://masterssummit.com

http://qlikviewcookbook.com

Re: execution script when importing excel

Anonymous — Thu, 18 Jan 2018 14:27:16 GMT

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.

Re: execution script when importing excel

Anonymous — Thu, 18 Jan 2018 15:25:30 GMT

Found the column that was the issue by deleting some and rerunning... No idea why though, its just a column with numbers 0 - 2000