oracle

QDM could not load query definition – PS


Was receiving this error this last week after changing the primary permission list on some accounts in PIA.
[Open Query] [CQryStmt::Prepare] QDM could not load query definition [ PUBLIC.PT_SEC_PLIST_USERS ]
I was trying to run a query to see which users belonged to a permission list.

Turns out that the reason was because the primary permission list that I assigned to some accounts did not have access via definition security to the PeopleTools Group ID. (also, make sure you change display view to Yes.

definition security QDM

After adding the primary permission list with access to the PeopleTools group + display view set to Yes, then the queries in PIA worked fine. Also, make sure the primary permission list is under the query process groups in PIA as well.


You may also like:

PeopleSoft Favorites – Authorization Error Discovered some users today that couldn't add favorites in PIA. Whenever they would try to add one they would get the following error: Authorization E...
Disable TypeAhead Feature for Everyone In certain PeopleSoft versions of PeopleTools, the TypeAhead feature simply doesn't work very well. It causes weird behavior, such as the mouse cursor...
PS – Move/Copy a Query to a new Database Here are instructions for moving/copying queries back and forth between different PeopleSoft databases. PeopleSoft Database Queries This includes mo...
Creating a SQL view/record for PSQuery Have you every been annoyed by creating a query in PIA, using PSQuery? The easier way to do it is to create a new record, turn that into a view, and t...
PeopleSoft Fix IE9 Spacing Issue As most of you probably noticed with the upgrade to PeopleTools 8.51 there is a spacing issue (white space between header and top of page) with IE9. T...
READ ALSO  How to Double Space in Word 2010