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.

Wednesday, March 30, 2011

Integration Broker Queues

Integration Broker Queues

  • Publication Contracts

select queuename,statusstring,count(*) from psapmsgpubcon where trunc(createdttm) = trunc(sysdate) group by queuename,statusstring

  • Subsription Contracts

select queuename,statusstring,count(*) from psapmsgsubcon where trunc(createdttm) = trunc(sysdate) group by queuename,statusstring order by 1

For a date range.

  • Publication Contracts

select queuename,statusstring,count(*) from psapmsgpubcon where trunc(createdttm) between trunc(sysdate-

  • Subsription Contracts

select queuename,statusstring,count(*) from psapmsgsubcon where trunc(createdttm) between trunc(sysdate-

______________________________________________________________________________________________________________________

Domain Status

SELECT DOMAIN_STATUS INTO DSTAT FROM PSAPMSGDOMSTAT

______________________________________________________________________________________________________________________

Domain is active, but messages not being processed

For publication messages

SELECT IBTRANSACTIONID,QUEUENAME,CREATEDTTM,PUBLISHTIMESTAMP,STATUSSTRING ,

floor(((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60)/3600)

|| ' HOURS ' ||

floor((((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60) -

floor(((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60)/3600)*3600)/60)

|| ' MINUTES ' ||

round((((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60) -

floor(((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60)/3600)*3600 -

(floor((((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60) -

floor(((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60)/3600)*3600)/60)*60) ))

|| ' SECS ' time_difference

FROM PSAPMSGPUBCON

WHERE STATUSSTRING IN ('NEW','ERROR') AND trunc(createdttm) = trunc(sysdate) ORDER BY 4

For subscription messages

Looking at the above query and this query we can find out if the domain is active but still messages are not being proecessed.

SELECT IBTRANSACTIONID,QUEUENAME,CREATEDTTM,PUBLISHTIMESTAMP,STATUSSTRING ,

floor(((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60)/3600)

|| ' HOURS ' ||

floor((((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60) -

floor(((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60)/3600)*3600)/60)

|| ' MINUTES ' ||

round((((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60) -

floor(((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60)/3600)*3600 -

(floor((((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60) -

floor(((CREATEDTTM-PUBLISHTIMESTAMP)*24*60*60)/3600)*3600)/60)*60) ))

|| ' SECS ' time_difference

FROM PSAPMSGSUBCON

WHERE STATUSSTRING IN ('NEW','ERROR') AND trunc(createdttm) = trunc(sysdate) ORDER BY 4

Tuesday, March 15, 2011

Activate Domain Status

**** Be Sure that PUB/SUB processes are up and running before using this script ****
SET SERVEROUT ON;
SPOOL D:\APPS\MONITORDOMAIN\MONITORDOMAIN.LOG;
DECLARE

DSTAT VARCHAR2(1) := 'T';

BEGIN

BEGIN
SELECT DOMAIN_STATUS INTO DSTAT FROM PSAPMSGDOMSTAT WHERE DOMAIN_STATUS = 'I';
EXCEPTION
WHEN NO_DATA_FOUND THEN
DSTAT:='A';
WHEN TOO_MANY_ROWS THEN
DSTAT:='I';
END;
IF DSTAT ='I' THEN

UPDATE PSIBFAILOVER SET IB_FAILOVER_FLAG = 1;

UPDATE PSAPMSGDSPSTAT SET DSPSTATUS = 0 , STATUSSTRING = 'ACT' WHERE STATUSSTRING='INACT';

UPDATE PSAPMSGDOMSTAT SET DOMAIN_STATUS = 'A' WHERE DOMAIN_STATUS = 'I';

END IF;
DBMS_OUTPUT.PUT_LINE(DSTAT);

END;
/

SPOOL OFF;
EXIT;