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-

%bind(:18)

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-

%bind(:17)

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

http://www.petri.co.il/enable-ping-windows-2008-server.htm

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

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=611565.1

following the link above.

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

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;

Send mail from oracle db

CREATE OR REPLACE PROCEDURE SEND_MAIL (

mesg_to varchar2,

mesg_subject varchar2,

mesg_text varchar2 )

IS

c utl_smtp.connection;

rc integer;

mesg_from varchar2(50) := 'MYDEVDB';

mailhost VARCHAR2(30) := 'name of your mailhost';

BEGIN

c := utl_smtp.open_connection(mailhost, 25); -- SMTP on port 25

utl_smtp.helo(c, mailhost);

utl_smtp.mail(c, msg_from);

utl_smtp.rcpt(c, msg_to);

utl_smtp.data(c,'From: MYDEVDB Oracle Database' || utl_tcp.crlf ||

'To: ' || msg_to || utl_tcp.crlf ||

'Subject: ' || msg_subject ||

utl_tcp.crlf || msg_text);

utl_smtp.quit(c);

EXCEPTION

WHEN UTL_SMTP.INVALID_OPERATION THEN

dbms_output.put_line(' Invalid Operation in Mail attempt

using UTL_SMTP.');

WHEN UTL_SMTP.TRANSIENT_ERROR THEN

dbms_output.put_line(' Temporary e-mail issue - try again');

WHEN UTL_SMTP.PERMANENT_ERROR THEN

dbms_output.put_line(' Permanent Error Encountered.');

END;

-------------------------------------------

Guideline taken from internet.