My Blog List

Monday, August 11, 2008

Peoplesoft SMTP settings

To generate electronic mail messages then SMTP settings must be configured
for both the Application Server as well as the Process schedulers. These
Settings are configured through PSADMIN or through the PSAPPSRV.CFG and
PSPRCS.CFG files respectively.

Step 1:
;===============================================================
; Settings for SMTP mail
;===============================================================

SMTPServer=PSP-SMTP-01<---- name of your SMTP server (this can also be the
IP address of the SMTP server)

-------------------------------------------------------------------------------
SMTPPort=25 <---- port number for your server (usually will be 25)

SMTPServer1=PSP-SMTPG-01 <----- name of backup server (not necessary)

SMTPPort1=25 <---- backup server port number

SMTPSender=PeopleSoft@peoplesoft.com <----- Valid email ID format

SMTPSourceMachine=ts-hp03.peoplesoft.com <------Server or Process Scheduler is on>..com (this can also be
the IP address of the machine without the .com) Note: This
needs to be the machine name of the server being configured, Application
or Process Scheduler, NOT THE NAME OF THE DATABASE YOU ARE CONNECTING TO.

Step 2:
check the Emil check box

Friday, August 8, 2008

How to clear cache on any/all of the PeopleSoft Internet Architecture

BEA Application Server
*************************

1) Shutdown Domain(s)
2) Delete all files and folders in %PS_HOME%\appserv\\CACHE
3) Start Domain(s)

BEA WebLogic 5.1/6.1/8.1
************************

1) Stop WebServer Service
2) Delete all files and folders under cache directory
Version 5.1 path --> C:\weblogic\myserver\public_html\PIASite\cache\*
Version 6.1 path -->
C:\bea\wlserver6.1\config\\applications\PORTAL\\cache
Version 8.1 path -->
PS_HOME/webserv//applications/peoplesoft/PORTAL//cache
3) Start WebServer

IBM WebSphere 4
********************

1) Stop WebServer Service
2) Delete all files and folders under cache directory
Version 4.0.x path -->
C:\WebSphere\AppServer\installedApps\peoplesoft\PORTAL\ps\cache
3) Start WebServer

Microsoft Internet Explorer 5.x/6.x
************************************

1) Navigate to Tools > Internet Options > General Tab
2) Click on Delete Files button
3) Close all open instances of the browser as this will clear in-memory
cookies
note: 6.x offers a delete Cookies Button on the same General Tab page

Netscape 4.x/6.x
**************

1) Navigate to Edit, and select Preferences on the Netscape menu bar
2) Click Advanced
3) Click Cache
4) Click the Clear Memory Cache button
5) Click the Clear Disk Cache button
6) Click OK

Mozilla Firefox 1.x
***************

1) Navigate to Tools and select Options
2) Select the Privacy section
3) Select the Cache tab
4) Click the "Clear Cache Now" button
5) Click OK

How do I delete personalizations for portal users? (Deleting User Homepage Cache)


It is possible to delete cache while a server is online. For example:
http://cit-srv-one:8020/psp/ps/EMPLOYEE/QE_LOCAL/c/WEB_PROFILE.WEB_PROFILE.GBL?cmd=purge&pwd=dayoff

The command to purge purges the webserver cache. The password dayoff is
an example. You would need the webserver's configured audit password
here.

Enabling the Help Link from the Application Pages

Each page in your PeopleSoft applications includes a Help icon that, when clicked, opens a new browser window displaying help topics that discuss that page.
To enable the Help link from application pages:

1. In your PeopleSoft application, navigate to the PeopleTools, Web Profile, Web Profile Configuration page.
2. Click Search and select the Profile Name you specified during your PeopleSoft Pure Internet Architecture installation.
3. Change the value for the Help URL field by replacing the "helpweb server" string with the domain name and port number of your web server. Also, if you installed to a directory other than "htmldoc" (the default), replace "htmldoc" accordingly.
Example:
If your PSOL server is named “mywebserver” and listens to port 5080, you would modify the default
Help URL from:
http://helpweb server/htmldoc/f1search.htm?ContextID=%CONTEXT_ID%&LangCD=%LANG_⇒CD%
to:
http://ctg-srv-one:8020/PSOL/htmldoc/f1search.htm?ContextID=%CONTEXT_ID%&LangCD=%LANG_CD%

Note. The system resolves %CONTEXT_ID% to the page name from which you called help. The system
resolves %LANG_CD% to the signon language of the user.
Note. If you do not want the Help icon to display in your applications, clear the Help URL field value.
Note. The default port for PSOL in a WebLogic multi-server domain installation is 6001.
4. Save and exit the Web Profile Configuration page.
5. Before testing help functionality, purge the browser cache on the client and close all web browsers.Restart the application server and web server for PIA.
6. Test the help functionality by clicking the Help icon on a PeopleSoft application page.




How do I successfully configure verity search in Peopletools ?


Make sure that the verity installation path is added to the System's 'PATH' environment variable on the server: %PS_HOME%\verity\winx86\_nti40\bin

(Note : Please REPLACE the %PS_HOME% with the PS_HOME path)

Also, clean the web server and browser cache, and MAKE SURE TO REBOOT the WebServer machine (not just Stop and start webserver, but restart the system) for the changes to take effect and check if the issue still persists.

Note: Multiserver domain users must make below changes in set_psol_env file before performing other steps:

If you are using a Multiserver domain the port number to access Peoplebooks should be of PSOL, default is 6001.
Open set_psol_env.bat or sh from the location
e.g \webserv\peoplesoft\applications\peoplesoft\PSOL\htmldoc\admin


Make sure, set PSOL_SERVERNAME value is set to PSOL not PIA. Set PSOL_SERVERURL should show the hostname and port number of PeopleBooks. Check below......
set PSOL_SERVERNAME=PSOL
set PSOL_SERVERURL=HTTP://:9999

Enabling peoplesoft F1 Search

This procedure describes how to enable F1 help for Application Designer, PeopleCode Editor, and other Windows-based PeopleSoft programs.
To enable F1 help:
1. Sign on to your PeopleSoft application using your browser.
2. Navigate to the PeopleTools, Utilities, Administration, PeopleTools Options page.
3. Enter the same URL as set in webprofile for online search (where // reflects your installation) into the F1 Help URL field:
http://ctg-srv-one:8020/PSOL/htmldoc/f1search.htm?ContextID=%CONTEXT_ID%&LangCD=%LANG_CD%
4. Save the page.

Wednesday, August 6, 2008

useful Links

LIBTUX_CAT:681: ERROR: Failure to create message queue
http://iambic.homeip.net/site/doku.php/tech/psoft/install_psoft_on_gentoo
Some examples of using UNIX find command
http://www.athabascau.ca/html/depts/compserv/webunit/HOWTO/find.htm
PeopleSoft IB setup Url.
http://docs.huihoo.com/oracle/docs/B14099_19/integrate.1012/b14060/int_broker.htm
Rman Recovery From Backupset In Different Location From Backup Location
http://www.orafaq.com/forum/t/118731/0/
Linux Users and Sudo
http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch09_:_Linux_Users_and_Sudo
Data Mover
https://heprod.georgetown.edu/htmldoc/eng/psbooks/tdam/chapter.htm?File=tdam/htm/dmcomt02.htm
Setting up Build Search Collection for Solution Advisor
http://www.peoplesoft.com/psp/portprd/CUSTOMER/CRM/c/C1C_MENU.C1_SOLN_SUMMARY.GBL?page=C1_SOLN_SUMMARY&SETID=SHARE&SOLUTION_ID=201049808

Wednesday, July 30, 2008

The Minimum Access Needed for Project Migration and Project Build

The Minimum Access Needed for Project Migration and Project Build

With the following Security setup, the User will be able to successfully migrate
Projects between two environments:


1-Create a new Permission List called TEST.
2-Go to 'Definition Permissions', change 'Project ' to 'Read only', save it, then change it back to 'Full Access'.
3-Go to 'Tools Permission' and change ' Upgrade' to 'Full Access'
4-Save and close out of the Permission List
Create a new Role named TEST and assign the TEST Permission List to this new Role.
1-Save and close out of the Role
2-Create a new User called TEST and assign the TEST Role to this User.
3-Add the PeopleSoft User Role to the TEST User
4-Save and close out of the User Profile


With the following Security setup, the User will be able to successfully build a Project:

1-Create a new Permission List called TEST1
2-Go to 'Definition Permissions', change 'Project ' to 'Read only’. save it then change it back to 'Full Access'
3-Go to 'Tools Permission' and change ' Build / Data Admin' to 'Full Access'
Save and close out of the Permission List
4-Create a new Role named TEST1 and assign the TEST1 Permission List to this new Role.
5-Save and close out of the Role
6-Create a new User called TEST1 and assign the TEST1 Role to this User.
7-Add the PeopleSoft User Role to the TEST User
8-Save and close out of the User Profile

Friday, April 18, 2008

Change the Access ID password in Peoplesoft

Path 1 : Log into Data Mover as the Access ID (Bootstrap mode).

Then run this command:

CHANGE_ACCESS_PASSWORD sa1 (This is your symbolic ID) cloud123 (This is the new password for the Access ID);

And hit the Green traffic light.

NOTE - This method does NOT work in PT 8.14 or 8.15, but is now fixed in PT 8.16 (T-JPELAY-AU4QW) so use method 2 or method 3. You MUST also make sure that the password for the Access ID has successfully been changed at the Database level because prior to PT 8.17 this method would not change the database level password. To do this go through your SQL tool (SQL Plus, Query Analyzer) and make the change in the database users table.

Path 2: - (Second best method) You need to change the Access ID Password at database level then log into Data Mover in bootstrap mode and run:

update PSACCESSPRFL set ACCESSID = 'what your Access ID is' , ACCESSPSWD = 'your New Access Password' , ENCRYPTED = 0, where SYMBOLICID = 'whatever the SYMBOLICID is';

Then run

ENCRYPT_PASSWORD *;

Note: If you have more than 45,000 rows in the PSOPRDEFN table then you may not be able to run the ENCRYPT_PASSWORD *; command in Data Mover. In that case just logon as a valid user in 2 tier and that will encrypt the Access ID in the PSACCESSPRFL table.

This will synch up the PSACCESSPRFL table with the same password stored at the database level for your Access ID.

Path 3 : - (Last and most discouraged method) Go into Application Designer / Tools / Miscellaneous Objects / Access Profiles.

Highlight the Symbolic ID and push the Edit button, enter the old password, new password, and confirm new password.

If you change it in Application Designer it does not change at the database level. This is because we do not GRANT to the database in PT 8. You MUST also make sure that the password for the Access ID has successfully been changed at the DB level. To do this go through your SQL tool (SQL Plus, Query Analyzer) and make the change in the database users table.