Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Not applicable

PGO Files

Does someone know any way to parse the pgo files into a qlikview? Thanks

1 Solution

Accepted Solutions
Employee
Employee

PGO Files

There is a diagnostic setting in QlikView Server that allows for the PGO files to be mirrored in XML format for debugging purposes. It is named "PgoAsXmlAlso" and it's value should be "1" if enabled. You can set this in the Settings.ini file for QVS, under the "Settings 7" node in QlikView Server 10 and 11.

27 Replies
disqr_rm
Valued Contributor III

PGO Files

You can't. But you can surely use QMS APIs to get information you are looking for. Search QMS API here in the forum and you will find some information. Also Power Tools would allow you to export some information you might be looking for.

Employee
Employee

PGO Files

There is a diagnostic setting in QlikView Server that allows for the PGO files to be mirrored in XML format for debugging purposes. It is named "PgoAsXmlAlso" and it's value should be "1" if enabled. You can set this in the Settings.ini file for QVS, under the "Settings 7" node in QlikView Server 10 and 11.

disqr_rm
Valued Contributor III

Re: PGO Files

Interesting!!! Thanks Stefan.

What if we keep the setting active always? Any side effects or issues with keeping this setting active in production environment?

Employee
Employee

Re: PGO Files

For data security purposes, and also performance, I would not recommend having this enabled in any environment over extended periods of time. It is a diagnostic easter-egg, not a feature.

Specifically in larger cluster environments where PGO operations needs to be instantaneous, this is very much not recommended.

disqr_rm
Valued Contributor III

Re: PGO Files

Thanks Stefan.

How about reading Meta files? Any trick to that?

deepakk
Valued Contributor III

Re: PGO Files

hi Stefan,

With lots of curoisty I  tried  the above method. but where does the xml file gets created. I am not able to find it

Deepak

Employee
Employee

Re: PGO Files

They will be created and maintained in the QVS root - the main User Document folder for your QVS. Are you sure you created the setting correctly?

Settings.ini file example:

[Settings 7]

PGOAsXmlAlso=1

..more settings..

[Authentication]

..settings...

Employee
Employee

Re: PGO Files

Rakesh Mehta wrote:

Thanks Stefan.

How about reading Meta files? Any trick to that?

Yes, but that has to be done with the SharedFileViewer, which is a part of the Power Tools for QlikView: http://community.qlik.com/docs/DOC-2649. Just note, that reading .meta files in this tool is kind of a "bonus", so never mind the red or pink markings on data in the file, as that does not apply to .meta files, only to .shared files.

Once you get the object list, double click IDs to see the data and venture deeper into the file.

deepakk
Valued Contributor III

Re: PGO Files

Thanks Stefan

I made a mistake. I wrote PGOAsXmlAlso=1 at the end of the file. I changed it to the top and now its working fine.

Deepak