Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
BrunPierre
Partner - Master
Partner - Master

Re: Governance Dashboard cannot handle special characters in QVW and QVD filenames including [ ] '

@NadiaB  How do I solve this execution script error? Thanks.

peter_brown_0-1658653039365.png

 

1 Solution

Accepted Solutions
NadiaB
Support
Support

Hi @Anonymous 

By any chance have you seen this already?

 

How to configure the Governance Dashboard

https://community.qlik.com/t5/Knowledge/How-to-configure-the-Governance-Dashboard/ta-p/1717487

 

Looking at the code the field comes from the autonum for the Audit log,  I was wondering if maybe the dashboard is reading from the incorrect place.

'$(fname)' & RecNo() as _AuditId,

Other option to narrow down where the problem relies would be to check the document script log to see at what point fails, the log should show the last successfully file loaded, that will give some idea of what file should be next, or other option would be also to add a TRACE entry in the script printing variable "fname" before the file is processed to see what was the next file attempted to read before the failure. 

 

Also if you are using a most recent QlikView version, it is suggested to download the most recent version of the Governance Dashboard and configure it accordingly. 

 

Hope it helps. 

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm

View solution in original post

3 Replies
NadiaB
Support
Support

Hi @Anonymous 

By any chance have you seen this already?

 

How to configure the Governance Dashboard

https://community.qlik.com/t5/Knowledge/How-to-configure-the-Governance-Dashboard/ta-p/1717487

 

Looking at the code the field comes from the autonum for the Audit log,  I was wondering if maybe the dashboard is reading from the incorrect place.

'$(fname)' & RecNo() as _AuditId,

Other option to narrow down where the problem relies would be to check the document script log to see at what point fails, the log should show the last successfully file loaded, that will give some idea of what file should be next, or other option would be also to add a TRACE entry in the script printing variable "fname" before the file is processed to see what was the next file attempted to read before the failure. 

 

Also if you are using a most recent QlikView version, it is suggested to download the most recent version of the Governance Dashboard and configure it accordingly. 

 

Hope it helps. 

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm
BrunPierre
Partner - Master
Partner - Master
Author

@NadiaB So the issue was resolved by simply renaming "_AuditId" to "AuditId" to conform to the field name used in the subsequent resident loads.

Many thanks for your time.

NadiaB
Support
Support

Hi @BrunPierre 

The Governance Dashboard should work without manual changes, that field probably renamed at some point, the suggestion would be to reconfigure the GD from scratch with a newer version. 

Governance Dashboard with edited scripts are not supported.

Hope it helps!

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm