PS QUERY 8.49.21 | PeopleSoft Scheduled Query returns no rows
When running a PS query via PS Scheduled query process no rows are on the file. However when running to Excel or HTML the query returns rows.
The query should be returning rows. Please note we must run query via Scheduled process as query is larger than MAX Fetch size.
We have adjusted Max Fetch Size as follows – however this doesn’t seem to apply to scheduled queries. per Doc ID 617786.1
[PSAPPSRV]
Max Fetch Size=95000
[PSQRYSRV]
Max Fetch Size=95000
No Errors or Warnings found on SCHDLR.log and/or AESRV.log
Any ideas?
Tagged:
1