Windows Share 

When you share a mount on Windows as Mypc\Myshare. This will work on all other PC's other than PC / Server where this mount actually resides. When you try to access MyPC\Myshare on that PC i will ask for user name and password.

To over come this, you need to set registry setting, to disable loopback checking.

Add following values in regisitry Also may need to disable Loopback checking: 926642 DisableLoopbackCheck registry entry in the KEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa registry subkey to 1. To set the DisableLoopbackCheck registry entry to 1, follow these steps on the client [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters] "DisableStrictNameChecking"=dword:00000001

How to start Multiple PeopleSoft domains using Windows Services

When you have multiple PS_HOME, PS_APP_HOME, setting up windows services does not set PS_APP_HOME variable and it causes SQR / COBOL process to fail. This is due to Application related SQR/Cobol are stored under PS_APP_HOME.

Work around for this is to edit psappsrv.ubx / psprcs.ubx file


Edit the psappsrv.ubx file for the Domain your testing this with and add the PS_APP_HOME parameter to the Environment Variables section at the bottom of the file under the {WINDOWS} section

{WINDOWS}
PS_APP_HOME=D:\PSOFTDEV\Your PS_APP_HOME

Then reconfigure the Domain via psadmin. You should see the APP variable set in your psappsrv.env file

Blank Pages Appearing After Upgrading to PT 8.5x

E-PIA\Upgrade: Blank Pages Appearing After Upgrading to PT 8.5x

1094893.1

To resolve the issue do the following.

i.e. Navigate to Portal Administration->Navigation->Structure and Content.
Select Portal Objects->Templates
Edit "8.50 default template".
Change "Usage Type" from "Frame Template" to "Inline frame template".
Save.
Reboot the web and app servers to have this change take affect.

IF you can't check/change this setting via PIA please issue the following query:

select * from PSPRSMDEFN
WHERE PORTAL_OBJNAME = 'DEFAULT_TEMPLATE' AND PORTAL_REFTYPE = 'C'
AND PORTAL_PRNTOBJNAME = 'PORTAL_TEMPLATES' AND PORTAL_CREF_USGT = 'FRMT'
AND PORTAL_URI_SEG1 = 'WEBLIB_PT_NAV'
AND PORTAL_URI_SEG2 = 'ISCRIPT1'
AND PORTAL_URI_SEG3 = 'FieldFormula';
If the PORTAL_CREF_USGT field value is "FRMT", then the following sql statement needs to be run to change the PORTAL_CREF_USGT value to "IFRM".

UPDATE PSPRSMDEFN SET PORTAL_CREF_USGT = 'IFRM'
WHERE PORTAL_NAME = 'XXXX_SITE_PORTAL_NAME' AND PORTAL_OBJNAME = 'DEFAULT_TEMPLATE' AND PORTAL_REFTYPE = 'C'
AND PORTAL_PRNTOBJNAME = 'PORTAL_TEMPLATES' AND PORTAL_CREF_USGT = 'FRMT'
AND PORTAL_URI_SEG1 = 'WEBLIB_PT_NAV'
AND PORTAL_URI_SEG2 = 'ISCRIPT1'
AND PORTAL_URI_SEG3 = 'FieldFormula';

Where 'XXXX_SITE_PORTAL_NAME' is the PORTAL_NAME value from the select statement.

AMI for Amazon Cloud Finace/SCM 9.1

PeopleSoft Finance DB and Application in one Server. Just install it everything will start automatically. 

Search for ami-994d94f0

Other Linux 
paravirtual-less info

Hypervisor

ovm

Source

348918650738/PeopleSoftDemoDB

Owner

 

Owner Id

348918650738 

Image Type

machine

Root Device

/dev/sda2

Kernel ID

aki-4e7d9527

 Finace/SCM 9.1

How to Install PeopleSoft on Amazon Cloud

Login it http://aws.amazon.com/Cloud

There are two was to manage cloud either via Amazon consoleor via Elasticfox Firefox Extension for Amazon EC2

Via Amazon

VIA FireFox ElasticFox

Install Elasticfox FireFox Extension for Amazon EC2

You can download it from (http://aws.amazon.com/developertools/609?_encoding=UTF8&jiveRedirect=1(

Tools ->

Chose the model

Select CPU / Memory

Once instance is created long to Server. Right click on thehost and select Connect. Point to key file and connect.  Make sure you have downloaded putty  and copy to (c:\program files\Putty\putty.exe  If you are connecting to console you need to convert keys using Putty Genkeys. 

How to connect using Putty toLinux server.

Youneed to down load key you created and convert it to putty format.

Start the PuttyGen program as shown below. If you skipped readingmost of this to get to here, you can download PuttyGen from:http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

Find the key that you made when you made your initial image andclick on load. You will get a dialog box that wants you to load your key filethat you got from Amazon. Find where you dropped your key file (again probablyin downloads). Remember to set your file type to * to see all your files(otherwise it will default to looking for a PPK file, which you do not haveyet).


Click on OK when you find and enter your file name. You should see the dialogbelow that shows the Amazon key was successfully converted from the Amazonformat to the PPK format Putty can read.

Click on OK in the above screen and if everything went well, youshould see the screen below

Click on Save Private Key. You really need to save your privatekey at this point. Remember where you saved your brand new PPK extension key(if you forget where you saved it, search your computer for *.ppk). You havemade it through the first hurdle, and now you need to fire up Putty

Start Firefox ->  Tools -> ; ElasticFox  login to cloud

Right lick on instance and select connect to instance

Pointto key file you

Clickon open , it will open a putty screen

Howto setup Oracle Database.

Changedirectory to /opt/oracle/psft/vm/scripts

Read README File

Run . ./oraclevm-template.sh to install Oracle

Reset Oracle Password else appserver won’t boot

the password will expire within 7 days

select * from dba_profiles where RESOURCE_NAME LIKE'PASSWORD_LIFE_TIME';

ALTER PROFILE default LIMITPASSWORD_LIFE_TIME UNLIMITED;

alter user sysadm identified by SYSADM;

alter user people identified by peop1e;

Install PIA

Start Oracle DB,  ( su– oracle ; dbstart  )

Start listener  ( su –oracle; lsnrctl start)

As PeopleSoft user ( psadm2) run tnsping FS91DEMO  to validate Tnsnames and listener.

Connect to DB using sqlplus : sqlplus sysadm@FS91DEMO  password sysadm

Once you can connect to database start application servers /PIA

Samples Listner.ora

# listener.ora Network Configuration File:/u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

      (SID_DESC =

         (SID_NAME = PLSExtProc)

         (ORACLE_HOME =/u01/app/oracle/product/11.1.0/db_1 )

         (PROGRAM = extproc)

      )

  (SID_DESC=

        (GLOBAL_DBNAME=fs91dmo)

        (ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1)

        (SID_NAME=FS91DMO)

   )

  )

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL =TCP)(HOST = localhost.localdomain)(PORT = 1521))

      (ADDRESS = (PROTOCOL =IPC)(KEY = EXTPROC1521))

    )

  )

Sample Tnsnames.ora file

[oracle@domU-12-31-39-09-26-31 admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File:

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL =TCP)(HOST = %hostname% )(PORT = %port%))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

FS91DMO =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL =TCP)(HOST = localhost.localdomain)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = FS91DMO )

    )

  )

If you need word document please email me at sivaran@gmail.com

PeopleSoft Notes

How To Reset CRef Expire Dates From 2010-12-31

update PSPRSMDEFN set PORTAL_EXPIRE_DT = '' WHERE PORTAL_EXPIRE_DT is not null; commit;

HOW TO UNLOCK A USER IN PEOPLESOFT

UPDATE PSOPRDEFN SET ACCTLOCK = 0 WHERE OPRID = 'VP1'

How to Start / stop Pub/SUB

In psadmin menu select Tux admin shutdown -g PUBSUB
boot -g PUBSUB

Process Scheduler

psadmin -p start -d database (Start a Process Scheduler) psadmin -p stop -d database (Stop a Process Scheduler) psadmin -p configure -d database (Configure a Process Scheduler) psadmin -p status -d database (Show status of a Process Schedul psadmin -p kill -d database (Kill a Process Scheduler) psadmin -p create -d database -t template -ps ps_set (Create a new Process Scheduler)

Delete Process Scheduler Configuration

DELETE FROM PS_SERVERCLASS WHERE SERVERNAME= 'PSNT'; DELETE FROM PS_SERVEROPRTN WHERE SERVERNAME= 'PSNT'; DELETE FROM PS_SERVERDEFN WHERE SERVERNAME= 'PSNT'; DELETE FROM PS_SERVERACTVTY WHERE SERVERNAME = 'PSNT'; DELETE FROM PS_SERVERMESSAGE WHERE SERVERNAME = 'PSNT'; DELETE FROM PS_SERVERNOTIFY WHERE SERVERNAME = 'PSNT'; DELETE FROM PS_SERVERPURGLIST WHERE SERVERNAME = 'PSNT'; DELETE FROM PSPRCSQUE WHERE SERVERNAMERUN = 'PSNT'; DELETE FROM PS_CDM_TRANSFER WHERE SERVERNAMERUN = 'PSNT'; DELETE FROM PSPRCSRQST WHERE SERVERNAMERUN = 'PSNT'; DELETE FROM ps_servercategory WHERE SERVERNAME = 'PSNT';

Fix PeopleTools Client issues

1) Run this first on your PC - PS_HOME\setup\vcredist\vcredist_x86.exe. 2) Then run this : PS_HOME/bin/client/winx86/pscfg.exe

Turning Off Tablespace Allocation
If you do not want to see the Change Space dialog box every time a new record definition is saved, clear the Platform Compatibility Mode option. Follow these steps:
1. In the browser, select PeopleTools, Utilities, Administration, PeopleTools Options. 2. Clear the Platform Compatibility Mode check box. 3. Save the changes.

How do find Current PS users logged in
declare P_Hr number :=0; P_Date VARCHAR2(9) := TRUNC(SYSDATE); a number;b varchar2(10); begin For Z1 in 1..24 LOOP select count(1),P_Hr'-'(P_Hr+1) into a,b from psaccesslog where logindttm between to_date(P_Date' 'P_Hr':00:00','DD-MON-YY HH24:MI:SS') and to_date(P_Date' 'P_Hr':59:59','DD-MON-YY HH24:MI:SS')+1/24 and oprid not in 'GFAAPSRV'; DBMS_OUTPUT.PUT_LINE(a','b); P_Hr := P_Hr+1; END LOOP;end;

select count(1) "Login_Users",'12AM - 01AM' "Time" from psaccesslog where logindttm between to_date('04-AUG-11 00:00:00','DD-MON-YY HH24:MI:SS') and to_date('04-AUG-11 23:59:59','DD-MON-YY HH24:MI:SS') and oprid not in 'GFAAPSRV';

Weblogic WLS Server does not boot Unable to obtain lock on /home/psfsusr/ There was an error while opening the file store file "WLS_DIAGNOSTICS000000.DAT" Store:280021 Shutdown server clean up following directories /home/psfsusr/FS91DEMO/webserv/fs91demo/servers/PIA/logs /home/psfsusr/FS91DEMO/webserv/fs91demo/servers/PIA/tmp /home/psfsusr/FS91DEMO/webserv/fs91demo/servers/PIA/data/ldap /home/psfsusr/FS91DEMO/webserv/fs91demo/servers/PIA/data/store /home/psfsusr/FS91DEMO/webserv/fs91demo/servers/PIA/cache/diagnostics restart the web server

PeopleSoft IB to MQ Integration

How to Setup MQ / Peoplesoft Connectivity

Document History:
Version
Author(s)
Description/Summary
Date Completed
1.0
Siva Kumar
How to Setup MQ Connectivity
03/29/2006
1.1
Siva Kumar
Added Support Procedure
04/27/2006


Last Updated
04/27/2006







Steps Required to setup MQM:

1) MQM Client Libraries.
2) Create jndi file using IVTSetup
3) Setup Java Message Converter.
4) Configure Websphere with MQM Resource
5) Configure Integration Broker with Inbound and Outbound nodes
6) Edit integrationbroker.properties file
7) Edit web.xml file
8) Start JMS Listener.
9) Support Procedure


Setup MQM Client Libraries.

Create user called mqm home directory /opt/mqm

You can download the MQM Client Libraries from MQ all you need following jar files to support MQ.

-r--r--r-- 1 mqm mqm 17978 Aug 2 2005 connector.jar
-r--r--r-- 1 mqm mqm 1785632 Aug 2 2005 com.ibm.mqjms.jar
-r--r--r-- 1 mqm mqm 41822 Aug 2 2005 com.ibm.mqbind.jar
-r--r--r-- 1 mqm mqm 344929 Aug 2 2005 com.ibm.mq.jar
-r--r--r-- 1 mqm mqm 33243 Aug 2 2005 CL3Nonexport.zip
-r--r--r-- 1 mqm mqm 13577 Aug 2 2005 CL3Export.zip
-r--r--r-- 1 mqm mqm 702319 Aug 2 2005 rmm.jar
-r--r--r-- 1 mqm mqm 77116 Aug 2 2005 providerutil.jar
-r--r--r-- 1 mqm mqm 444428 Aug 2 2005 postcard.jar
-r--r--r-- 1 mqm mqm 123717 Aug 2 2005 ldap.jar
-r--r--r-- 1 mqm mqm 8809 Aug 2 2005 jta.jar
-r--r--r-- 1 mqm mqm 98496 Aug 2 2005 jndi.jar
-r--r--r-- 1 mqm mqm 25998 Aug 2 2005 jms.jar
-r--r--r-- 1 mqm mqm 22769 Aug 2 2005 fscontext.jar
drwxr-xr-x 5 mqm mqm 512 Feb 15 2006 ..
-rw-r--r-- 1 mqm mqm 144700 Feb 16 2006 libmqjbnd05.so
-rw-r--r-- 1 mqm mqm 12808 Feb 16 2006 libmqjbdf02.so
-rw-r--r-- 1 mqm mqm 22084 Feb 16 2006 libMQXAi02.so



Create jndi file using IVTSetup
Get the required queue names from MQM admins

cd /opt/mqm/java/bin

Edit JMSAdmin file Location of .binding file

PROVIDER_URL=file:/opt/mqm/java/peoplesoft/jndi

Edit IVTSetup file and put the correct

# cat IVTSetup
#!/bin/sh

# ------------------------------------------------------------
# IBM Websphere MQ Support for Java Message Service
# Installation Verification Test - Setup script
#
# Licensed Materials - Property of IBM
#
# 5648-C60 5724-B4 5655-F10
#
# (c) Copyright IBM Corp. 1999. All Rights Reserved.
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
# ------------------------------------------------------------

echo "+ Calling JMSAdmin in batch mode to create objects"

cat << EOT java -DMQJMS_LOG_DIR=$MQ_JAVA_DATA_PATH/log -DMQJMS_TRACE_DIR=$MQ_JAVA_DATA_PATH/trace -DMQJMS_INSTALL_PATH=$MQ_JAVA_INSTALL_PATH com.ibm.mq.jms.admin.JMSAdmin
def qcf(trQCF) HOSTNAME(Your MQ Server ) PORT(1417) CHANNEL(SYSTEM.DEF.SVRCONN) QMANAGER(NYXENAP1.QM) TRANSPORT(client)
def q(troutQ) qu(Outbound Queue) PERSISTENCE(NON) TARGCLIENT(MQ)
def q(troutSwit) qu(Swift Queue) PERSISTENCE(NON) TARGCLIENT(MQ)
def q(trinQ) qu(inbound queue) PERSISTENCE(NON) TARGCLIENT(JMS)
def q(trinPS) qu(inbound1) PERSISTENCE(NON) TARGCLIENT(JMS)
def q(trinQNTP) qu(Queue hold message converted) PERSISTENCE(NON) TARGCLIENT(MQ)
def tcf(trTCF)
def t(trT) topic(MQJMS/PSIVT/Information)
end
EOT

echo "+ Done!"

. ./PATH.sh
./IVTSetup

This will create a .binding file in PROVIDER_URL=file:/opt/mqm/java/peoplesoft/jndi directory. Verify the file before continuing.

Note : Are you required to rebuild the .binding file if any queue name changes. For rebuilding you need to delete .binding file the run the IVTSetup script.

Make a note queue short names these names will be referred in WAS / PeopleSoft and JMS converter.


Setup Java Message Converter.

This part is key without this message will not work. As PeopleSoft supports only XML messages and swift takes only plain message. We need a java code which will convert messages from plain to XML and XML to plain.

We asked our java developer to write a small code which will read from Queue a and converts message (either adding or deleting xml tags) then put it another queue. This code will running all the time as soon as it sees a message it will convert.

This is used in the java code to convert.

headerAdjuster.jms.factory=trQCF : Connect Factory we defined in IVTSetup file
headerAdjuster.jms.username=
headerAdjuster.jms.password=
headerAdjuster.jms.sourceINQueue=trinQ Inbound Queue Name without tags
headerAdjuster.jms.sourceQueue.MessageSelector=
headerAdjuster.jms.destinationINQueue=trinPS Inbound Queue Name with tags (PS will read this)
headerAdjuster.requestingNode=MQ_INBOUND Node in IB
headerAdjuster.destinationNodes=
headerAdjuster.reply=false
headerAdjuster.debug=false
headerAdjuster.MessageVersion=VERSION_1 Message Version in IB
headerAdjuster.jms.sourceOUTQueue=troutQ Outbound Message with xml Tags
headerAdjuster.jms.destinationOUTQueue=troutSwit Outbound Message without Tags
headerAdjuster.messageName=Message Name Message Name in IB



Configure Websphere with MQM Resource


Login to admin server

http://hostname:9090/admin



Setup up MQ Environment files locations and Library Files.

Click on Environment -> Manage WebSphere Varibles. You need to set JAVA_HOME. MQ_INSTALL_ROOT






Click on Resources -> WebSphere MQ JMS Provider

Enter server name you are setting up ‘fs880tst’ and click on Apply



Click on WebSphere MQ Queue Connection Factories -> New

Fill up Name , JNDI Host Port , Channel , Transport Type. All this information you will get it from MQ admins and IVTSetup file



Click on apply to save the changes


Go back to ‘Web Sphere MQ JMS Provider’ and select ‘WebSphere MQ Queue Destinations’ and click on new .

Fill up Name, JNDI name, Base Queue Name ( Where Converted messages with xml tags for Peoplesoft Inbound kept). Queue Manage Name, host, port Channel Name. All this info you will get it from IVTSetup / MQ Admins.




Setting up JMS Listener ports


Servers -> Application Servers -> fs880tst ( Server you are setting up )

Message Listener Service

Listener Ports

Clikc on New and setup Create New Port called trQCF which your connect factory. Define all required fileds

Connection Factory and Destination JNDI name











Reboot the Server1


Login as wsadmin

Cd bin
./stopServer.sh server1
./startServer.sh server1


This will complete WebSphere Setup.

Click on Apply.



Configure Integration Broker with Inbound and Outbound nodes


Login to WebServer

http://hostname:8074/webserver/signon.html

AS VP1. -> PeopleTools -> Integration Broker -> Node Definitions

Create required nodes. Here we have 3 nodes 2 for inbound 1 for outbound.

Add a New Values

Creating MQ_INBOUND for inbound messages


Click on Connectors set Connector ID = PSFTTARGET


Click save then Click on Transactions Add Transaction and add the message your want to configure. Message should be active in app designer. Fill the required informanation.


It should show something like this after setup. External name which will be used in IB properties file.


Setup same thing for other Inbound MQ_IN_CONF put the correct message name.

Adding Outbound Node Name.


Click on Connectors select connector ID as JMSTARGET and fill the required filed. These values must match you what we defined in IVTSetup and WebSphere Setup.



Save it.

Check the status in Monitor Message by using Ping Node. Remember only Outbound Node can be pinged not inbound.

This completed WebServer setup in Peoplesoft.


Edit integrationbroker.properties file


Login to unix server as wsadmin user

Cd /opt/psoft/fs/pshomet/webserv/server_name/website.ear/PSIGW/WEB-INF

Cp integrationGateway.properties integrationGateway.properties.DDMM

Vi integrationGateway.properties


Find JMS Configuration Section and Make sure Correct connection factory is enabled.

#The JNDIFactory Classnames for Weblogic, IPlanet, MQSeries.
#ig.jms.JMSProvider.JNDIFactory.Weblogic=weblogic.jndi.WLInitialContextFactory
#ig.jms.JMSProvider.JNDIFactory.IPlanet=com.sun.jndi.fscontext.RefFSContextFactory
ig.jms.JMSProvider.JNDIFactory.MQSeries=com.sun.jndi.fscontext.RefFSContextFactory

Number of Queues to monitor

# Enter the number of Queue listners to instantiate
ig.jms.Queues=1 (number of any queues you want to monitor)

Configure following queues and messages.

ig.jms.Queue1=trinPS
ig.jms.Queue1.Provider=MQSeries
# ig.jms.Queue1.MessageSelector=
ig.jms.Queue1.JMSFactory=trQCF
ig.jms.Queue1.Url=file:/opt/mqm/java/peoplesoft/jndi

As we are getting the Message name and requestingNode from the Message. This is optional if your message does not have tag following will used as default.

ig.jms.Queue1.MessageName=NMR_TRADE_TRANS_INB1
ig.jms.Queue1.MessageVersion=VERSION_1
ig.jms.Queue1.RequestingNode=MQ_INBOUND

We changed this procedure as we wanted to get the message in one queue only. If you want two different queues.
ig.jms.Queue2=trinPSNTP
ig.jms.Queue2.Provider=MQSeries
# ig.jms.Queue2.MessageSelector=
ig.jms.Queue2.JMSFactory=trQCF
ig.jms.Queue2.Url=file:/opt/mqm/java/peoplesoft/jndi
ig.jms.Queue2.MessageName=NMR_BANK_CONF_INB1
ig.jms.Queue2.MessageVersion=VERSION_1
ig.jms.Queue2.RequestingNode=MQ_IN_CONF

For Production Make sure you update the both the AppServers.

Edit web.xml file

Cd /opt/psoft/fs/pshome/webserv/servername/website.ear/PSIGW/WEB-INF

Cp web.xml web.xml.bak
Vi web.xml

Add following lines

Just below
Psigw
Add --– (This is comment don’t put this in file)

JMSListeningConnectorAdministrator
com.peoplesoft.pt.integrationgateway.listeningconnector.JMSListeningConnectorAdministrator

Add –ends – (This is comment don’t put this in file)
In the same file more place
Just on top of ‘ServletMapping’
Add--– (This is comment don’t put this in file)

JMSListeningConnectorAdministrator
/JMSListeningConnectorAdministrator/*

Add end – (This is comment don’t put this in file)

Final Setup start JMS Listener


Start JMS Listener
Start
http://server_name:port/PSIGW/JMSListeningConnectorAdministrator?Activity=start
Stop

http://servername:8000/PSIGW/JMSListeningConnectorAdministrator?Activity=stop

If everything setup correctly you see messages coming into PeopleSoft, else send me email at skumar@us.nomura.com I will replay when I get time.


Common errors

Message stays in New.

Make sure domain status is active


Check if there is any error messages.