Datetime field format error
This is a quick short post for resolution of the datestamp error while running a PS Query. Datestamp errors are quite common when running a PS Query. When you run a PS Query and are prompted to enter the datetime value – many a times you will end up entering a wrong format and you […]
Continue readingPeopleSoft Query – Which Tables are Involved?
PeopleSoft Query is a great way to retrieve information from PeopleSoft without having to write the complex SQL queries. However, as a PeopleSoft admin – there may be situations when you need to seek information from the PeopleSoft Query tables. For example, find out the private queries of a PeopleSoft user; Convert all private queries […]
Continue readingQuery result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specified for the application server.
One of the common errors encountered while running a PSQuery is: “Query result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specified for the application server.“ As the error message suggests, this error has been caused due to huge result size, which the application server is unable to render […]
Continue readingPSQuery Not Running
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 […]
Continue readingTransfer Private PS Queries From One User To Another
If any user leave the department and there are many Private queries which needs to be transferred to any new user, then there are 2 ways to do this. Option1: Log in as the user who owns the query, go to Query Manager in PeopleSoft and change the queries from Private to Public. Now new […]
Continue reading