Wednesday, October 5, 2011

Find status of Services From command line

Use sc query

FOR /F "tokens=4 delims= " %%A IN ('SC QUERY peoplesoft ^| FIND "STATE"') DO

Process Scheduler delays in kicking the process

Seen Process Scheduler kicking off a process after a while.

its worth have a look at Heartbeat
Heartbeat : The Process Server Agent needs to track server status-running, down, or suspended. Every time it checks the server status it updates the LAST_UPD_DTTM field in the PS_SERVERDEFN table with the current date and time of the database engine. This prevents the database from accepting more than one Process Server Agent with the same name on one or multiple servers.

If there are too many processes in Error or in No Success status, it somehow affects running App Engines Clear them and check it.

Friday, July 29, 2011

Applying PeopleTools 8.51.11 patch

A. Stop all the application servers, web servers and process schedulers.

B. Follow the below steps

FILE SERVER CHANGES


On windows 2008

1. rename d:\apps\pshome\ d:\apps\pshome_8.51.09

2. copy d:\apps\pshome_8.51.09 d:\apps\pshome_8.51.11

3. Apply 8.51.11 to d:\apps\pshome_8.51.11 directory

4. junction link name directory i.e. junction.exe pshome d:\apps\pshome_8.51.09

(for deleting links use the junction –d link unlike removing link in linux (rm link name))

5. copying jrockit

a. copy Q:\apps\technical\PEOPLETOOLS\pt851\jrockit-jdk1.6.0_26 d:\apps\

b. change the jrmc junction

c. d:\apps\junction –d jrmc

d. d:\apps\junction jrmc d:\apps\jrockit-jdk1.6.0_26

e. (documentation asks use to change D:\oracle\weblogic\common\bin\commEnv.cmd , change java home .. start using junction you created above)

On Linux

6. mv /apps/pshome /apps/pshome_8.51.09

7. cp /apps/pshome_8.51.09 /apps/pshome_8.51.11

8. Apply 8.51.11. to /apps/pshome_8.51.11

9. ln –s directory linkname i.e. ln –s /apps/pshome_8.51.11 pshome

10. copying jrockit (steps for people using links .. way to go)

a. unzip Q:\apps\technical\PEOPLETOOLS\pt851\ p12706519_2814_Linux-x86-64.zip and ftp it linux box (we can choose any method)

b. jrockit-jdk1.6.0_26 (linux) should be placed under /apps

c. change the jrmc link

d. rm jrmc

e. ln –s /apps/ jrockit-jdk1.6.0_26 jrmc

DATABASE CHANGES

On Windows

11. Login to Application Designer

12. Go - Data Mover

13. Run d:\apps\pshome_8.51.11\scripts\ptpatch.dms and exit Data Mover

14. From Application Designer

15. Copy Project from file - d:\apps\pshome_8.51.11\projects\PATCH851

16. IMPORTANT

a. After importing the patch851 project, instructions say to build the project if there are any database changes.

b. I am surprised with this instruction. (so I decided take a call at the end)

c . So in Demo, after looking at the DDD Audit, it is pretty clear that there are no changes to the database as DDD Audit is very clean.

d. Only 1 table and 2 views are there, that are in the database but not defined in the Application Designer.

e. Need to decide what to do with it.

17.

18. Exit from Application Designer

19. Login to Data Mover in boot strap mode

20. Run d:\apps\pshome_8.51.11\scripts\msgtlsupg.dms

21. Clear all the cache directories from Web , Application and process schedulers

a. /apps/user/DEMO/appserv/CACHE

b. /apps/user/DEMO/appserv/prcs/CACHE

c. D:\apps\user\DEMO\appserv\prcs\CACHE

d. D:\apps\user\DEMO\webserv\peoplesoft\applications\peoplesoft\PORTAL.war\ps\cache

22. Redeploy PIA

23. Start all the application servers, process schedulers, webservers.

24. Run all the process of each type.

25. Run DDDAudit, SysAudit and review.

Thursday, April 14, 2011

New Features - 8.51

Installation /Configuratoin

1. PS_CFG_HOME -
One place to hold all the configuration. Best to have it outside PSHOME
On Windows , we still want to have under individual PS_HOME, can do the following
Edit psadmin.bat
set PS_CFG_HOME=
\appserv\psadmin

2. Install on Linux/Unix with x-Windows
\setup.sh -tempdir -i swing

3. Standby Application Server

4. Psadmin Process Scheduler menu changed, similar to Application Server Domain Menu

5. Turn off Jolt Pooling
joltpooling=false set in configuration.properties (not in web.xml)

6. Adding process scheduler/application server and service on nt
Modify - pswinsrv.cfg (%ps_cfg_home%\appserv\)

7. Change default navigation
PeopleTools > Portal > General Settings > Navigation Options

8. Personalize Content
PeopleTools > Portal > Structure and Content > Portal Objects >HomePage > Tabs > Edit > TAB Content
interesting find for yourself

9.Registry Search Index
Configure Application Server Configuration File as below
Values for config section - Search
Deployment Type=2
Application Server Port=7777
Remote Search Server Credentials=SRCHSERV|localhost:7778

Deployment type = 1 for PSAPPSRV to handle
Deployment type = 2 for seperate process
Deployment type = 3 for different domain.

run the build portal search index process
PeopleTools > Portal (take a new run control id)
Deployment type 1 did not work so started a separate process.

Sometimes on red hat linux 5, sestatus needs to be disabled
/usr/sbin/sestatus (se security enhanced)
deployment type needs to be 2

10.PeopleTools 8.50 onwards, PeopleSoft ODBC driver and Crystal Runtime can be installed by running psodbccrinst.exe.

11. Remove links like Signout.
_____________________________________________________________
1) Log in to application designer and open the html object PT_IFRAME_HDR
.
In PT_IFRAME_HDR, comment out the following line-



2) Log in to application designer and open the html object PT_IFRAME_HDR_SWAN

In PT_IFRAME_HDR_SWAN, comment out the following line-



This will not generate any header links.
3) There is another way you can disable only the "Sign out" link although It has not been tested thoroughly and not sure about its implications.

a) Open the peoplecode at PT_BRANDING.BrandingBase.OnExecute (note that PT_BRANDING is an application package).

Here comment out the following lines-

&signOutLink = &hdrLink.GetLogoutURL();
&hdrLinkHTML = %This.setIframeHdrLinkHTML(&hdrLinkHTML, &signOutLink, "");

This will not generate the "Sign out" link.
__________________________________________
12. report not posting link : http://peoplesoft.wikidot.com/reports-not-posting

--------------------
Firewall
1. opening firewall on linux
vi /etc/sysconfig/iptables
/etc/init.d/iptables restart
SOLARIS $ ipfstat -hio
SOLARIS $ cat /etc/opt/ipf/ipf.conf

________________________________________________
If you have turned on your firewall , 2008 handles things differently

netsh advfirewall ; firewall

Good information on

Using the GUI.
1. Run firewall.cpl and press enter.
2. Enable “file and printer sharing (ICMP requestv4)” and save it.

netsh advfirewall
___________________
Registry Entry for Services.msc
HKEY_LOCAL_MACHINE>SYSTEM>ControlSet01>Services

how to run AE Version

following the link above.