Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

PGO Files

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

1 Solution

Accepted Solutions
StefanBackstrand
Partner - Specialist
Partner - Specialist

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.

View solution in original post

27 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

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.

StefanBackstrand
Partner - Specialist
Partner - Specialist

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
Partner - Specialist III
Partner - Specialist III

Interesting!!! Thanks Stefan.

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

StefanBackstrand
Partner - Specialist
Partner - Specialist

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
Partner - Specialist III
Partner - Specialist III

Thanks Stefan.

How about reading Meta files? Any trick to that?

deepakk
Partner - Specialist III
Partner - Specialist III

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

StefanBackstrand
Partner - Specialist
Partner - Specialist

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...

StefanBackstrand
Partner - Specialist
Partner - Specialist

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
Partner - Specialist III
Partner - Specialist III

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