Changing Password of PTWEBSERVER

Change the password of the user PTWEBSERVER, if used to create Peoplesoft website.
==================================================================================

Solution

There are 2 places that changes need to be made

Step 1:
PTWEBSERVER is a user id in the user profile, so you can change the
password by opening the user profile for PTWEBSERVER by navigating to
Peopletools -> Security -> User Profiles

Step 2 :
Once you change the password, you have to run run the PSCipher script
located in ($PSHOME\webserv\)

On a UNIX machine, change the PSCipher.sh script file permissions so you
can execute it.

Execute the script file with your password as an argument, for example:

pscipher MYPASSWORD

The utility returns the encrypted password as a string; for example:
VOBN5KcQZMg=

Copy the encrypted string and paste it into the configuration.properties
file, for example:

WebPassword=VOBN5KcQZMg=

After you save the configuration.properties file, restart your web
server and the new profile takes effect.

Bypassing PS Signon Page

Bypassing PSsignon screen on PIA and directly navigate to Target Page
=====================================================================

Solution
---------------------------------------------------------------------
1. In PIA, Navigate to Peopletools > Web Profile > Web Profile configuration
Click on Search and choose the appropriate web profile(DEV).
Go to "Security" tab and in the "Public User" section , enter the valid login details
eg. User id = VP1 Password = VP1
click on Save.

2. On Webserver, Navigate to $PS_HOME/webserv/domain/applications/peoplesoft/PORTAL/WEBINF/psftdocs/website/
Open configuration.properties file and enter the following
bypasssignon=true

3. Now you can directly access any page inside the peoplesoft application without logging into the PIA.
Just provide the URL for the page and access

Queued processes in Process Scheduler in Peoplesoft

In Peoplesoft, many times we face the error like the reports are in queued staus for a long time & even if we run more reports, they also go in the same status.There could be number of reasons for it.
1. Process Scheduler could be down. Check the status in Process Monitor> Server List
2. If it is a report, check whether the report is present on the process scheduler file server..
3. Check if there is no memory to be allocated. Check virtual memory.
4. Tablespace could be filled. Check the same & if need be increase the size of the respective tablespace.
5. Possibility could be that database Server might not be having enough space on the disk.
6. In most of the cases if one process is in queued status, it will make all the new process to remain in queued status. This happens mostly in the case of Application Engine Programs.In that case we can go ahead and clear all the Process instances other than Success/ Posted. This can be done from the Process Monitor page itself. But in case, you don't have enough rights to delete the same from PIA. I am also attaching the Run status of Process Instances in Process Scheduler table i.e PSPRCSRQST.
Process Scheduler Run Status
1- Cancel 2- Delete 3- Error 4- Hold 5- Queued 6- Initiated 7- Processing 8- Cancelled9- Success 10- No Success 11- Posted 12- Not Posted 13- Resend 14- Posting 15- Generated
To resolve this , shut down the process scheduler and clear the cache. After this, run the below SQL in the respective database using Access ID (usually 'sysadm' in oracle & 'sa' in MS SQL Server).
select count(*) from psprcsrqst where runstatus<>'9';
delete from psprcsrqst where runstatus<>'9';
commit;