Xml Publisher setting

The XML publisher reports now seem to be working when using the template builder.

The problem seemed to be related to one of the solutions you sent me last week. Essentially all of the fields in the report need to be edited via the word properties - Add help text option so that the default fields in the form field help text window beginning with 'ref' are replaced with the actual field names. So for example:



Replaced with



Importantly the F and E fields which are at the start and end of all fields listed in a template that has repeating values need to be replaced as follows:

F field at the beginning:

replaced with

And

E field at the end:

Replaced with

This allows all of the values to be listed in a report table.

Turn on logging for xmlp Reports

Steps to Turn ON Logging for XMLP Reports for Debugging

Steps to Turn ON Logging for XMLP Reports for Debugging.

Create a file named xdodebug.cfg and place it under [PS_HOME]\JRE\Lib] folder.The file should include the following line:

Under Windows
LogLevel=STATEMENT

LogDir=c:\temp

Under Unix
The file Should look like this (point to an appropriate temporary directory under the Unix box)
LogLevel=STATEMENT

LogDir=/pshome/appserv/

Remove xdodebug.cfg when finished replicating the issue.

The logging is specifically useful for troubleshooting the Template(RTF/PDF) or Data File(XML file) specific issues. The generated XML file is the actual data file which is run from the MS Word Design Helper Preview mode to narrow down the issue.

Peoplesoft on YouTube

PeopleSoft on YouTube

Search for PSFTOracle

http://www.youtube.com/watch?v=HjeTC7dPeBs

Search for PeopleSoftTechnology

http://download.oracle.com/peopletools/viewlets.html

PeopleTools 8.52 is supporting PeopleSoft on iPAD, mobile Safari

You can find demo PeopleSoft Environments at the url below

www.connectnd.us

psmail to send mails

Pretty handy!!

C:\pshome\bin\server\winx86\psmail -TO"devendra.vaidya@myeemail.com" -FROM"PeopleSoft@peoplesoft.com" -SUBJECT"give your subject" -BODY"Give your body" -FILE"filename with path" >>D:\maillogs\mail1.log

Script to extract last 'n' number of lines from a text file

@echo off > newfile.TXT & setLocal enableDELAYedexpansion

set N=

for /f "tokens=* delims= " %%a in (C:\TEST.TXT) do (

set /a N+=1

)

set /a X=!N!-4

set N=

for /f "tokens=* delims= " %%a in (C:\TEST.TXT) do (

set /a N+=1

if !N! gtr !X! echo %%a >> newfile.TXT

)

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.

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.

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.