Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Governance Dashboard: Error in hidden script

Hi

I installed the governance dashboard on my qv server where the qlikview documents reside and tried to run the reload but keep getting this error message.

“Error in hidden script. For details, open hidden script before reload.

For security reasons, failed hidden script code is not shown.”

I looked into this thread but the thread is from 2012 and didn’t seem to shed any light on the issue. http://community.qlik.com/thread/63476

The details:

Picture2.png

I also have an email out to qvgdfeedback@qliktech.com to see if they can shed some light on it. I'll update this post if I find anything.

13 Replies
Highlighted
Employee
Employee

Re: Governance Dashboard: Error in hidden script

Hello Philip,

Can you send the following information to QlikTech Support so we can troubleshoot it?

  1. Governance Dashboard.qvw.log
  2. fullscan.messages.log*
  3. fullscan.statistics.log*
  4. Description of how your environment is configured:
    1. Version of QlikView
    2. Where is GovernanceDashboard.exe installed?
    3. Where is the reload occurring?
    4. User account that is reloading it - does it have read/write access to the profiles and file folders?

You might try reloading without "Has Server" to see if you get the same issue.

Tyler

* in profiles\default\QVX_LastRun folder

Highlighted
Not applicable

Re: Governance Dashboard: Error in hidden script

Hmm... I might have been guilty of an ignorant oversight.

I just did a clean reinstall of the Governance Dashboard and noticed a warning that there was a Qv.exe still running and it suggested to shut it down. (Another user had it running on their server session.) I don't remember seeing this before but I might have just continued past the warning.

After closing all Qv.exe processes and doing a clean reinstall it worked fine.

If I have any other issues I'll post them here along with the logs you suggested.

Highlighted
Creator III
Creator III

Re: Governance Dashboard: Error in hidden script

Hello,

My Governance Dashboard gives an "Error: Error in hidden script. For details, open hidden script before reload."

It only gives this error when scanning a particular folder. The directory test works though.

I found something strange in the "Fullscan messages log".

What does the "Extract Directory Scan Error mean"?

I attached the log of the dashboard and the "Fullscan messages log".

,KR Koen

Highlighted
Employee
Employee

Re: Governance Dashboard: Error in hidden script

Thanks for including the log files!

From the FullScan.messages.log, I see the following errors (noted by the -A and -F):

Multi-Transform QVW - OPERATOR-0016-F: toolId 186.0, name 'Multi-Transform QVW' - Exception 'BufferAllocatorException' occurred in the 'process' function for thread 0. (FullScan.Step_1)

Multi-Transform QVW - OUTPUT_BUFFER-0005-A: An output record is too large. The hard limit on output buffer size of 33,554,432 bytes has been exceeded by a request for 40,173,568 bytes. (FullScan.Step_1)

Multi-Transform QVW - OPERATOR-0005-F: toolId 186.0, name 'Multi-Transform QVW' - the 'process' function failed for thread 0. (FullScan.Step_1)

The fact that it fails on the Multi-Transform QVW operator denotes there is a problem scanning one of the QVWs.  The error "An output record is too large" could mean several things about one or more of the QVWs in the folder you are scanning. Here is my guess in order of likelihood:

  1. a .qvw has extensive data lineage. This can happen when you use a load ... from *.* or a large loop extract (imagine pulling from thousands of log files).
  2. a .qvw contains hundreds or thousands of data tables and/or fields. This is also written to the qvw XML metadata which could be too large to read.
  3. a .qvw is corrupt.
  4. a .qvw has a super long SQL select statement.  Never seen this cause a problem, but is possible.

Are you aware of any qvws that might have any of these characteristics?

Highlighted
Not applicable

Re: Governance Dashboard: Error in hidden script

I am having this error when executing the script..any help would be greatly appreciated..

Table not found

tempQVWs:

  Load FileName as tempFileName,

  LoadDateKey

  Resident FileList

  Where Extension = 'qvw'

  AND FileDate >= '2015-03-16'

  AND (FileTime >= '1995-08-26 00:00:00'

  OR not exists (SOE_FileName,FileName))

  AND not exists (NonReadableMetadataQVW,FileName)

Highlighted
Employee
Employee

Re: Governance Dashboard: Error in hidden script

Are you pointing to a file folder (on the Configuration page of the app, "List of File Paths to Scan") which has no QVWs?

Or, does this folder only contain one QVW and the QVW can't be read (really old or corrupt)?

Highlighted
Not applicable

Re: Governance Dashboard: Error in hidden script

Hi, did you find an answer to this? Thanks

Highlighted
Creator
Creator

Re: Governance Dashboard: Error in hidden script

I was having same issue with new install of 2.0.2 and found that by adding a qvw to the main file path as Tyler noted above, the hidden script error was resolved.

Highlighted
Partner
Partner

Re: Governance Dashboard: Error in hidden script

hi,

create a empty qvw file in "List of File Paths to Scan".

after governance will works!!