topic Re: How to strip out the load scripts/hidden scripts for a qlikview qvw in QlikView

How to strip out the load scripts/hidden scripts for a qlikview qvw

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

Hi,

We have a old qlikview qvw design by not so great 'qlik' person developer.

When open it says 'Access denied to this QLIKView document'

So I am trying to find out what file. Or if it has hidden scripts. To dump out the scripts to

try and reverse engineer this.

Do you have a command line tool to strip out the scripts so it can be debugged why this message appears.

Possible it has HARD-CODED a file path which no longer exists.

Thanks

Regards

Justin

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

Anil_Babu_Samineni — Wed, 23 May 2018 04:04:11 GMT

Usually, When you talk about old and open - May be there has some security in that application. As far i know, That you can not open that restrict by Qlik.

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

Anonymous — Wed, 23 May 2018 04:31:11 GMT

what a poor design..in qlikview.

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

jonathandienst — Wed, 23 May 2018 04:59:45 GMT

Have you tried opening it without data? From the QV desktop start page, right click the file name in the Recents list and try "Open 'file' Without Data".

If the file is not in the recent list, create a text file with the line

"C:\Program Files\QlikView\qv.exe" /nodata %1

Store it on your desktop with a .bat extension. Then drag the file and drop it on the bat file.

Or, open a run command and enter

"C:\Program Files\QlikView\qv.exe" /nodata "your filepath and name"

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

marcus_sommer — Wed, 23 May 2018 08:48:02 GMT

If there is any section access implemented it does what it should by deny the access for unauthorized persons. If there is no query for an user and a password the restrictions will probaly base on the NTNAME and/or your licence and/or your domain.

Within the xml-header of the qvw you might get some valuable hints from where the section access come from:

<Discriminator>\\YourServer\d\...\sectionaccess\sectionaccessrules.xlsx</Discriminator>

and which users are included:

<String>DOMAIN\USER1</String>

and with this knowledge and something from here: Bypassing QlikView Section Access – Infinity Insight Blog you might be lucky to get access again to this application.

- Marcus

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

Anonymous — Wed, 23 May 2018 09:48:43 GMT

Thanks Jonathan

Tried that sill same error 'Access denied to this QlikView document';

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

Anonymous — Wed, 23 May 2018 09:50:59 GMT

Thanks Marcus,

How would one get to the xml-header/extract xml-header from a binary file.

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

marcus_sommer — Wed, 23 May 2018 09:55:57 GMT

Just opening it within an editor like notepad++ and using CTRL + F with "sectionaccess" to find the mentioned xml-parts at the bottom of the file.

- Marcus