Friday, August 18, 2006

Reset your PeopleSoft Password or AccessID Password

Many times you may get a request from user to reset his password and you can not login to PeopleSoft Web App to do that. Here is a way to reset the password using your database SQL utility. This assumes that you can login to your database using valid Peoplesoft db account or superuser account.

 

This resets the password = oprid

update psoprdefn
set operpswd = oprid,
encrypted = 0
where oprid = any_oprid;

Login to data mover (bootstrap mode or regular mode)
and run encrypt_password oprid;

2. For some reason, you login to Appdesigner and it gives following error message

SQL error. Stmt #: 2 Error Position: 0 Return: 404 - ORA-01017: invalid username/password; logon denied;

This indicated that your database password and password stroed in PSACCESSPRFL (Encrypted format in accesspswd) are not in sync.
Run the following command in your database SQL Utility

update PSACCESSPRFL
set accessid = 'peoplesoft_schema_id',
accesspswd = 'current_password',
encrypted = 0
where symbolicid = <your symbolic id>

Login to App designer and it will let you login again and also encrypt the password in PSACCESSPRFL

Tuesday, August 08, 2006

Another Application Designer is the Debugger. (143,7) error

If you are getting this error Another Application Designer is the Debugger. (143,7) error then try the following

Restart the application server after clearing the cache.