topic Re: Governance Dashboard Script Error in QlikView

Governance Dashboard Script Error

btrompetter — Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I installed the Governance Dashboard on our Qlikview 11 Server.

But I always get a Script Error in the hidden part:

Table not found

DateIsland:

LOAD

1 as MaxID,

Max(LoadDate) as MaxLoadDt

Resident FileList

Did somebody has the same issue?

Best wishes

Bastian

Re: Governance Dashboard Script Error

Michael_Tarallo — Wed, 10 Oct 2012 11:50:06 GMT

Hello Bastian

I have seen this error before - can you please tell me a little about your environment?

Version of the QVGD - I assume the recent Beta 1.0?
Are you using a VM?
Operating system
Version of QlikView Desktop you are using to load the .qvw? - I assume 11 SR x?

Try running a reload again - CTRL+R - or click scan. Please repeat that a few times.

Please let me know

Regards,

Mike T

Re: Governance Dashboard Script Error

btrompetter — Wed, 10 Oct 2012 12:02:50 GMT

Hallo Mike,

I download the Beta 1.0 Version from the Qlikview Market. We are using a VM but it's a single VM on one Machine.

We use Qlikview 11.00.11307.0 SR1 with the Customer Patch for the Publisher Bug.

I open the Dashboard in the Qlikview Desktop on our Server with Version 11.00.112882.0 SR1 64-bit

We are using Windows Server 2003

		Operating System	Microsoft Windows Server 2003 R2 Service Pack 2 (64 bit edition)
		Operating System Version	5.2.3790

I try to reload it but it doesn't work.

We have the Publisher and Server Logfiles in a seperate folder.

CTRL + R won't work.

Best wishes

Bastian

Re: Governance Dashboard Script Error

Michael_Tarallo — Wed, 10 Oct 2012 12:11:43 GMT

I download the Beta 1.0 Version from the Qlikview Market. We are using a VM but it's a single VM on one Machine.

AH HA! - I thought so. I have already informed engineering. I have seen this before in some of my pre-beta testing -but only on VMs. I have not isolated the problem myself just yet. However I will come back to you promptly once I hear back from engineering.

Do you have another HOST machine you can try this on in the mean-time?

Regards,

Mike T

Re: Governance Dashboard Script Error

btrompetter — Wed, 10 Oct 2012 12:35:52 GMT

Hello Mike,

on my local machine I didn't get the error after one minute. It looks like working.

But I have to uninstall the Expressor Suite and reinstall the QVGD because with an installed version oif expressor I get a connector error.

Did it read the complete qvw files over the network? We have e.G. one 4 GB Dashboard on our server. OR did it readf only the meta data?

Is it possible to analyze the logfiles with a Desktop Client on my local host or is this only working on the server?

Best wishes

Bastian

Re: Governance Dashboard Script Error

Michael_Tarallo — Wed, 10 Oct 2012 12:52:43 GMT

Hey Bastian -

But I have to uninstall the Expressor Suite and reinstall the QVGD because with an installed version of expressor I get a connector error.

I'd like to have our team possibly investigate this "if" it becomes a problem after installing. The QVGD comes with its own QlikView Expressor engine and is independent of the QlikView Expressor Desktop and engine components that come with the Full Installer. Please open another post specifically for this if it does become a problem.

Did it read the complete qvw files over the network? We have e.G. one 4 GB Dashboard on our server. OR did it read only the meta data?

If the paths you include in the configuration sheet of the QVGD are shared network drives and even possibly UNC "\\machine_name\share" (I have not tested UNC yet - but I believe I heard this works too) then yes it will scan that file over the network and grab the metadata from it to build the associative data model. I do believe file size will pay an important role. I am not sure if there is logic in the scan that will bypass pieces in the file that are not needed. If this becomes an issue - please let me know in a separate thread.

Is it possible to analyze the log files with a Desktop Client on my local host or is this only working on the server?

Yes and Yes - since the QlikView Governance Dashboard is a QlikView application which utilizes QlikView Expressor technology - either installed on a local client desktop with shared and/or network paths to all the required server files (profiles, document paths, log files etc) OR installed on the QlikView Server - you can create a publisher task to scan the environment unattended and display the results in AccessPoint.

It is recommended that you install QVGD on the same machine as the server and have QlikView Desktop installed on that machine as well.

See the installed documentation - file:///C:/ProgramData/QlikTech/Governance_1.0Beta/doc/index.htm

..for more information

Check out the FAQ too:

http://qlikmarket.qlik.com/qvajaxzfc/pdf/Data-Governance_FAQ-US.pdf

Let me know how you do.

Regards,

Mike T

Re: Governance Dashboard Script Error

Michael_Tarallo — Wed, 10 Oct 2012 13:07:30 GMT

Hello Bastian -

I moved the discussion thread to this forum based on PM advisement. So please take note you are in the:

"Deployment and Management (Server/Publisher/AJAX/IE/Web Parts)" forum now.

As per engineering:

R&D believes that they have isolated the cause of this defect in executing the QlikView Expressor Connector. The defect is believed to be in the QVX protocol’s reply handling logic of QVSR2 and earlier (it is not a Governance Dashboard or Connector bug). The QV11 R&D team is looking into this and believes that the fix can possibly be incorporated into a QV11SR2 Update to be released in the next 2 to 3 weeks.

We have noticed that the problem is more prevalent on machines with 2 or fewer cores available to QlikView and, in particular, VMs. Machines with 4 to 8 (or more) cores tend not to create the conditions under which the defective code path is executed.

We will update you when appropriate.

Regards,

Mike T

Re: Governance Dashboard Script Error

TK_ — Wed, 24 Oct 2012 19:35:32 GMT

Hi Mike

Just to confirm your feedback.

I get the same error at one of our customers.

The server is on a VM with Win 2008 R2 and 1 cpu.

I have the latest QV version installed (11, sr2) and I downloaded the QVGD today.

Regards

Terje

Re: Governance Dashboard Script Error

Michael_Tarallo — Wed, 24 Oct 2012 19:46:26 GMT

Thanks Terje - check out this link to see the list of known issues and approaches that may help:

http://community.qlik.com/docs/DOC-3546

Mike T

Re: Governance Dashboard Script Error

btrompetter — Thu, 25 Oct 2012 11:55:10 GMT

Hallo

when did you expect to fix the issue with the virtual machine?

Because creating a data linage is only possible on the server. OR can I run QGDB on my PC to get the data linage?

Best wishes

Bastian

Re: Governance Dashboard Script Error

Ricardo_Gerhard — Thu, 08 Nov 2012 17:23:30 GMT

I´m useing Amazon and get the same error.

Attached the file with my log configurations.

Machine Information
		Computer Name	AMAZONA-P0BIBBH
		Operating System Version	Win32_OperatingSystem=@ X64 (Microsoft Windows NT 6.1.7601 Service Pack 1)
		.NET Version	4.0.30319.269
		Physical Memory	7679Mb
		Available Memory	4359Mb
	CPU Information
		CPU 0	Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
		CPU 1	Intel(R) Xeon(R) CPU E5645 @ 2.40GHz

Re: Governance Dashboard Script Error

Michael_Tarallo — Thu, 08 Nov 2012 17:33:27 GMT

Hello Ricardo - do not use spaces in your document scan path and let me know.

Regards,

Mike T

Re: Governance Dashboard Script Error

Ricardo_Gerhard — Thu, 08 Nov 2012 17:45:20 GMT

Same error, when I disable Has Log Server, the problem didn´t occur.

The problem only occur when the document read Logs is enabled.

I´ve Publisher and didn´t enable

Re: Governance Dashboard Script Error

Michael_Tarallo — Thu, 08 Nov 2012 18:21:00 GMT

Hello Ricardo - can you please verify all of the following listed in the following document and let me know if any of it has fixed the issue:

http://community.qlik.com/docs/DOC-3546

This issue (script error) has been reported and is being fixed, however if none of the items in the document fix the issue it might be related to the VM.

I assume you are getting the DateIsland Script error when running the scan of the QVGD?

I will have one of our team look at this too to get another set of eyes on it.

Regards,

Mike T

Re: Governance Dashboard Script Error

Michael_Tarallo — Fri, 09 Nov 2012 14:16:33 GMT

Hello Ricardo

Can you also attach the following logs:

C:\ProgramData\QlikTech\Governance_1.0Beta\profiles\default\Governance Dashboard.qvw.log

C:\ProgramData\QlikTech\Governance_1.0Beta\profiles\default\QVX_LastRun\FullScan.Messages.log

C:\Users\<username>\AppData\Roaming\expressor\expressorQlikViewConnector.log

Thanks

Mike T

Re: Governance Dashboard Script Error

marcelo_7 — Fri, 09 Nov 2012 15:12:18 GMT

Hello Michael,

I get the same error. I have a physical server with Windows Server 2008 R2 64-bit.

I have several folders in my source document path. One folder is called "In Production" and another is called "Prod" and a third one is called "QVD Load".

When I add "In Production" to the list i get the DateIsland error and when I search the others it works just fine. I thought that the space in "In Production" might have been the cause but the folder "QVD Load" works so logically it has to be something else. What can I do?

EDIT:

Also, how do I change to western formatting of dates? And in some parts the letters "å ä ö" are either replaced with weird characters or just skipped. In other parts they are displayed correctly.

Cheers,

Marcelo G.

Re: Governance Dashboard Script Error

Michael_Tarallo — Fri, 09 Nov 2012 16:05:24 GMT

Hello Marcelo - can you send these logs - attach to the thread you respond with:

C:\ProgramData\QlikTech\Governance_1.0Beta\profiles\default\Governance Dashboard.qvw.log

C:\ProgramData\QlikTech\Governance_1.0Beta\profiles\default\QVX_LastRun\FullScan.Messages.log

C:\Users\<username>\AppData\Roaming\expressor\expressorQlikViewConnector.log

Thanks

Mike

Re: Governance Dashboard Script Error

Ricardo_Gerhard — Fri, 09 Nov 2012 16:38:39 GMT

I did it by message because I cannot sent by forum.

Re: Governance Dashboard Script Error

marcelo_7 — Mon, 12 Nov 2012 09:03:50 GMT

After your last message I wanted to run the program and give you the logs of both folders. The "In production" that returned an error and the "QVD Load" that worked. After your message I initiated a scan with the dashboard providing only the "In production" folder. I left it running and when I logged back in 5 hours later it was still running so i cancelled it and uninstalled the dashboard. All processes didn't end and I could not manually end them either. etool.exe *32 was running several instances. I performed a reboot today, removed all files and installed it again. I must have done something wrong because the same thing happened today but when performing a scan on the "QVD Load" folder that I know worked before and this time it kept running much longer than it should have so i cancelled it. I can't end the process etools.exe now so I have decided to put this on hold for now.

EDIT: For clarity, I uninstalled it properly and removed the files that were not deleted automatically.

Re: Governance Dashboard Script Error

Michael_Tarallo — Mon, 12 Nov 2012 12:35:18 GMT

Hello Marcelo - it seems like you may be experiencing a long run-time - however it seems you did not get the script error as originally stated:

Have you tried scanning a smaller directory? Just to see? Something that has a few QVW, QVD files just to test the behavior? If that DOES work then at least we know the dashboard is now working and you resolved your original issue.

Please note this write up on the slow run time:

Problem: Scans take a very long time, in some cases multiple hours.

Issued Id: GOV-121

Remedy: The QlikView Governance Dashboard metadata scanner obtains its QVW and QVD metadata

by scanning these files and extract out XML tag information that contains the metadata. In the case of

QVW files, these XML tags tend to be near the end of the file, after all the encoded data contents. In

the case of QVD files, the XML tags are at the top of the file.

For QVW files that have very large data volumes, identifying the start of the XML tag block can take

longer than for QVW files that have little or no data. If the QVWs to be scanned are deployed to the

Publisher’s SourceDocuments folder in a data cleaned state, the time to scan them will generally be

faster than if deployed with a large volume of existing data. Use the ‘File->Reduce Data->Remove All

Values’ function on these larger QVWs before deploying so that the scanner can identify the XML tag

blocks more quickly.

For QVD files that were generated from QVWs that loaded hundreds of data sources (either using a

looping construct or a LOAD * pattern), these target QVD files will contain as many <LineageInfo> tags

as there were different source files used in the QVWs that generated the target QVDs. We have

observed instances in which the generating QVW files we’re loading thousands of machine generated

log files resulting in thousands of <LineageInfo> elements (all with cryptic, machine-generated file

names which provided little additional lineage value). These QVDs can be eliminated from the

Governance Dashboard scan process by entering a pattern that matches unite parts of their file names

or parts of the names of the sub-directories to which they are written. Care must be exercised to make

sure your pattern does not inadvertently match the names of QVW or QVD files (or their directories)

that you do want included in the scan.

List of Paths to Scan: This is a table of pairs of text fields where the first, left field contains a 'scan path' which must be a valid, full path specification of a directory that the scanner will search for QVW, QVD or QVX files. The scanner descends into all sub-directories of each scan path root directory to find all QVW, QVD and QVX files to analyze. One or more exclusion patterns, can be entered into the Excluded Keywords text field (separated by vertical bar | characters) to exclude from the metadata scan individual files or entire directories whose names match the exclusion pattern. Note that if the name of the candidate folder or file matches ANY one of the pipe-delimited patterns, the file or subfolder (and all of contents) is excluded from the scan.

Please let me know how you do when you continue working with QlikView Governance Dashboard.

Regards,

Mike T