PSQuery Not Running

by Apurva Tripathi on February 26, 2013

in PeopleSoft Administration

Came across a situation where the PSQuery does not run even after you click of ‘Run’ or ‘Run to Excel’ or ‘Run to HTML’. This post is to address such situations.
On clicking these buttons/links nothing happens and the page(browser) remains AS-IS instead of launching new window to run the PS-Query where it would also prompt for parameters if available. This is an Internet Explorer Settings Issue.
In Internet Explorer select:
Tools > Internet Options > On the Security Tab > Select Custom level > Select Enable for Automatic prompting for file downloads
Alternatively you can also add the PIA URL to Trusted sites and do the above change in case you cannot enable automatic prompting for file downloads for all sites.
In PeopleSoft 9.1, the ‘View Results’ button no longer looks like a button as it was earlier in PeopleSoft 8.9 and before. So users might tend to overlook upon ‘View Results’ as it more looks like a static text instead of a button though it does what it is meant to. Make sure you click upon ‘View Results’ to retrieve query results in PIA.
Also Read:  How to access SQL for a Private PS query of another user

{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post: