Query Administration - Part 3 - Testing Various Services used by PSQuery when run in different ways.
A PS Query can be run in several ways including: 1) From PS Query tool in 2-tier 2) Using Query Viewer 3) Run to HTML from Query Manage...
Showing posts with label PS-Query. Show all posts
Showing posts with label PS-Query. Show all posts
How to display the prompt value in PS-Query results?
If we would want to display the prompt value in PS-Query then, mostly we would add the corresponding field to the query results instead of...
Data from a encrypted field cannot be decrypt in a PS-Query
Recently, I was analyzing ways in which we could encrypt/decrypt data stored in PeopleSoft using PeopleTools utilities. Out of curiosity, I...
What are the various values and description stored in EXPRTYPE field in PSQRYCRITERIA record?
The Expressions that we create and use in PS-Queries are not saved AS-IS in the back end. They are broken into several parts and stored. A ...
Query Administration - Part 2 - Tests to run after killing a PS Query
Once a PS-Query is killed, I observed that if the configuration is improper, then it leads to certain issues. So, it is important to run p...
Query result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specified for the application server.
When running PS-Query, sometimes the following error message appears: " Query result set too large, (124,87). Result of (SQL Fetch) ...
How to use FROM clause in a expression in a PS-Query?
An expression in a PS-Query will never allow a FROM clause to be specified. In case, a FROM is specified, an error will be issued as " ...
Why PSQRYSTATS and PSQRYEXECLOG records are not populated always??
PSQRYSTATS and PSQRYEXECLOG records get populated only for queries that are run from PIA i.e., either from Query Manager or Query Viewer. ...
Information on PSAPPSRV, PSQCKSRV, and PSQRYSRV, PSQCKSRV processes and their impact on PS Queries
Are PSAPPSRV, PSQCKSRV, and PSQRYSRV processes different? No. The PSAPPSRV, PSQCKSRV, and PSQRYSRV processes are basically the same progra...
Why a Service or PS-Query request runs twice though it is submitted only once from PIA?
This is very common among PS-Queries due to improper configuration setup. Before we find an answer to this question, it would be better if w...
Subscribe to:
Posts
(
Atom
)