The background of the issue is in older versions of PeopleSoft SQR programs used to execute from a client workstation and there was no 4-tier concept, so People used to hardcode the output file path with in the program.
PeopleSoft 8 onwards reports are being posted to web and people can view the reports in the [...]
One of the users reported that she was getting the above error when she runs a private query.
I found out that this query is bringing back around 100,000 rows back and which is taking a lot of memory and the size.
To overcome the issue I asked her to adjust the query to bring the less [...]
With PeopleTools 8.4 and higher PeopleSoft delivered a great feature to improve the online performance, which is shared caching. This will eliminate the unnecessary caching and trips to the database.
Without enabling the shared cache, application server domain will create separate cache file for each process. With shared cache enabled all the user processes will share [...]
• Your systems people should create a DNS entry to point the IP address to a custom alias.
• If you are on UNIX open etc/host file to include the new host name.
• Go to weblogic admin page and change the PIA portal if needed.
• If the environment is already configured for machine name, go to Process Scheduler -> Report [...]
This was one of the strange situations we faced when we went live with PeopleTools 8.45.17 and Financials 8.8 SP1 Maintenance Pack 3.
After a couple of days that we went live users in Accounts Receivables area started complaining that they can’t enter the deposits any more and the system started throwing them out.
I identified that [...]
The below error was came up when one of my colleague was trying to truncate a table with in an SQR procedure. I don’t know whether this is a Sybase specific or for all the databases.
SQL Error = (226) TRUNCATE TABLE command not allowed within multi-statement transaction.
The Solution is to COMMIT before and after the [...]
PeopleSoft environment agent uniquely identifies a particular instance based on a GUID. PeopleSoft assigns this Unique value to each PeopleSoft database instance (application if you have multiple versions installed on the same servers), so when an EM Agent notifies the Environment Management Hub that it has found a component belonging to an environment and if [...]