Hello All, We are trying to upgrade the Peoplesoft Database from SQL Server 2000 to SQL Server 2005. We are at PeopleTools 8.48. Can you please let me know if...
Hello All, We are trying to upgrade the Peoplesoft Database from SQL Server 2000 to SQL Server 2005. We are at PeopleTools 8.48. Can you please let me know if...
Hi, We are having this nagging problem for a while now and I have tried almost everything I know to resolve this issue without any success. Following is the...
Sounds like you have two problems - 1) QMD (Query of Mass Destruction) 2) Web Timeout settings - but not on the weblogic server of your PIA - but on your proxy...
It's supposed to do that!!! Rewrite and optimize the queries (but you tried that) - this is a prime example of using the wrong tool for the job. If a query...
Ah - I didn't make myself clear (my bad) I was just explaining why the error was ocurring... I 100% agree - do not alter the timeout - rewrite the query with...
If I am running the application server and the process scheduler on the same Unix server and with the same PS_HOME, is there any benefit in implementing remote...
Glenn, Did you checked your appserver log file?($PS_HOME/appserv/domain/LOGS/appXXX.log. Check any server process got killed and not able to restart) If so,...
The trouble with remote call is that it blocks a PSAPPSRV process while the remote called process runs. The app server spawns the process and waits for it to...
I suppose QMD are like WMDs - you are sure they are there, and you are sure you will find them - except that they really do exist! You can set a maximum query...
All, Quick question I have struggled to find an answer to, as an Oracle DBA about to implement PS CRM 8.9, I wanted to know if the Advanced Configurator is ...
Hello, Within the Application Server configuration file - psappsrv.cfg - for both the WSL and JSL, there are two parameters :- ' Max Handlers' and 'Max Clients...
... are sure ... amout of data ... the user ... PSQRYSRV, ... tuxedo ... pool before ... memory ... don't let ... that was ... Crystal ... increase the ... ...
Hi, Its my pleasure to become a member of this group. Thanks to David who created this group. Im looking forward to get your book here in Singapore. If anyone...
amazon.com PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the...
Hello All, I am getting Query Name and Row count when we run the PS Query to excel which is unwanted for our users. Is there a way to suppress it permanently. ...
Hi David, Thanks very much for your quick reply - and your very encouraging answer ! I was afraid there may have been serious memory implications or something...
Has anyone seen the message "Unable to find Access Password for Process Request" in the process scheduler log file when trying to start SQR processes? ...
hello david, quick question can you run the sqr from command line I.e. from windows and see whether it is the password or some other issue. thanks raj...
Hi David, I can think of a few things as Raj said try to run SQR from 2 tier. See if the password is hardcoded in SQRs somewhere. Make sure that after cloning...
I'm thinking that we need to increase the number of PSAPPSRV processes we have configured to improve performance and wanted some input from the members of this...
I guess my first question would be how many users do you have on concurrently when these conditions occur? I have run 60 concurrent users on each of two 2 CPU...
Hi, I just had a weird things happened when one of the queries(SELECT) reported to me running slow. Previously it rans around 2 mins then sudddenly called me...
I emailed you this before realizing I should post it here: Clark, I'm not sure what it is at the peak. When I do client status I get page after page of lines....
Hi, I am unable to configure help URL for App Designer. Please let me know. Thanks, satya ... Shape Yahoo! in your own image. Join our Network Research Panel...
Hi, Where can i get performance and tuning documents for PeopleSoft. Thanks, satya ... Take the Internet to Go: Yahoo!Go puts the Internet in your pocket:...
Hi, I have little bit confusion regarding connectid : people. While installing peoplesoft we will use connectid in connect.sql script. Actually what is the...
Hi, Please let me know what is the function of PSANALYTICSERV in PeopleSoft processes. Thanks, satya ... Building a website is a piece of cake. Yahoo! Small...