Monday, 21 December 2015

Following are the steps bringing the latest security, trees and queries after peoplesoft upgrade (CutOver Time)





Following are the steps bringing the latest security,trees and queries.

Step 1: Backed up all the tables related to query and trees using data mover.

SET LOG C:\Temp\Test.log;
SET OUTPUT C:\Temp\QRY_TREE.dat
EXPORT PSQRYDEFN ;
EXPORT PSQRYEXPR ;
EXPORT PSQRYDEFNLANG ;
EXPORT PSQRYRECORD ;
EXPORT PSQRYSELECT ;
EXPORT PSQRYBIND ;
EXPORT PSQRYBINDLANG ;
EXPORT PSQRYCRITERIA ;
EXPORT PSQRYFIELD ;
EXPORT PSQRYFIELDLANG ;
EXPORT PSQRYLINK ;
EXPORT PSTREEDEFN;
EXPORT PSTREEBRANCH;
EXPORT PSTREELEAF;
EXPORT PSTREELEVEL;
EXPORT PSTREENODE;

SET LOG C:\Temp\Test_Imp.log;
SET INPUT C:\Temp\QRY_TREE.dat
IMPORT PSQRYDEFN AS PSQRYDEFN_89;
IMPORT PSQRYEXPR AS PSQRYEXPR_89;
IMPORT PSQRYDEFNLANG AS PSQRYDEFNLANG_89;
IMPORT PSQRYRECORD AS PSQRYRECORD_89;
IMPORT PSQRYSELECT AS PSQRYSELECT_89;
IMPORT PSQRYBIND AS PSQRYBIND_89;
IMPORT PSQRYBINDLANG AS PSQRYBINDLANG_89;
IMPORT PSQRYCRITERIA AS PSQRYCRITERIA_89;
IMPORT PSQRYFIELD AS PSQRYFIELD_89;
IMPORT PSQRYFIELDLANG AS PSQRYFIELDLANG_89;
IMPORT PSQRYLINK AS PSQRYLINK_89;
IMPORT PSTREEDEFN AS PSTREEDEFN_89;
IMPORT PSTREEBRANCH AS PSTREEBRANCH_89;
IMPORT PSTREELEAF AS PSTREELEAF_89;
IMPORT PSTREELEVEL AS PSTREELEVEL_89;
IMPORT PSTREENODE AS PSTREENODE_89;


Step 2: Llet the upgrade complete patching / Tax updates.

Step 3: Import additional missing Queries and Trees.

INSERT INTO PSQRYDEFN SELECT * FROM PSQRYDEFN_89 WHERE QRYNAME NOT IN (SELECT QRYNAME FROM PSQRYDEFN);
INSERT INTO PSQRYRECORD SELECT OPRID, QRYNAME, SELNUM, RCDNUM, RECNAME, JOINTYPE, JOINRCDNUM, JOINFLDNUM, CORRNAME, ' ' FROM PSQRYRECORD_89  WHERE QRYNAME NOT IN (SELECT QRYNAME FROM PSQRYRECORD);
INSERT INTO PSQRYSELECT SELECT * FROM PSQRYSELECT_89  WHERE QRYNAME NOT IN (SELECT QRYNAME FROM PSQRYSELECT);
INSERT INTO PSQRYBIND SELECT * FROM PSQRYBIND_89 WHERE QRYNAME NOT IN (SELECT QRYNAME FROM PSQRYBIND);
INSERT INTO PSQRYBINDLANG SELECT * FROM PSQRYBINDLANG_89 WHERE QRYNAME NOT IN (SELECT QRYNAME FROM PSQRYBINDLANG);
INSERT INTO PSQRYCRITERIA SELECT * FROM PSQRYCRITERIA_89 WHERE QRYNAME NOT IN (SELECT QRYNAME FROM PSQRYCRITERIA);
INSERT INTO PSQRYFIELD SELECT * FROM PSQRYFIELD_89 WHERE QRYNAME NOT IN (SELECT QRYNAME FROM PSQRYFIELD);
INSERT INTO PSQRYFIELDLANG SELECT * FROM PSQRYFIELDLANG_89 WHERE QRYNAME NOT IN (SELECT QRYNAME FROM PSQRYFIELDLANG);
INSERT INTO PSQRYLINK SELECT * FROM PSQRYLINK_89 WHERE QRYNAME NOT IN (SELECT QRYNAME FROM PSQRYLINK);
INSERT INTO PSQRYEXPR SELECT * FROM PSQRYEXPR_89 WHERE QRYNAME NOT IN (SELECT QRYNAME FROM PSQRYEXPR);


insert into PSTREEDEFN (SELECT SETID, ' ' SETCNTRLVALUE, TREE_NAME, EFFDT, EFF_STATUS, VERSION, TREE_STRCT_ID, DESCR, ALL_VALUES, USE_LEVELS, VALID_TREE, LEVEL_COUNT, NODE_COUNT, LEAF_COUNT, TREE_HAS_RANGES, DUPLICATE_LEAF, TREE_CATEGORY, TREE_ACC_METHOD, TREE_ACC_SELECTOR, TREE_ACC_SEL_OPT, NULL LASTUPDDTTM, ' ' LASTUPDOPRID, ' ' TREE_IMAGE, ' ' BRANCH_IMAGE, ' ' NODECOL_IMAGE, ' ' NODEEXP_IMAGE, ' ' LEAF_IMAGE  FROM PSTREEDEFN_89
WHERE (SETID, TREE_NAME) NOT IN (SELECT SETID, TREE_NAME FROM PSTREEDEFN));

insert into PSTREEBRANCH (SELECT SETID, ' ' SETCNTRLVALUE, TREE_NAME, EFFDT, TREE_BRANCH, VERSION, PARENT_BRANCH, BRANCH_LEVEL_NUM, PARENT_NODE_NUM, TREE_LEVEL_NUM, TREE_NODE_NUM, TREE_NODE_NUM_END, NODE_COUNT, LEAF_COUNT, ' ' BRANCH_IMAGE FROM PSTREEBRANCH_89
WHERE (SETID, TREE_NAME, TREE_BRANCH) NOT IN (SELECT SETID, TREE_NAME, TREE_BRANCH FROM PSTREEBRANCH));

insert into pstreeleaf (SELECT SETID, ' ' SETCNTRLVALUE, TREE_NAME, EFFDT, TREE_NODE_NUM,  TREE_BRANCH, RANGE_FROM, RANGE_TO, DYNAMIC_RANGE, OLD_TREE_NODE_NUM, ' ' LEAF_IMAGE FROM PSTREELEAF_89
WHERE (SETID, TREE_NAME,  RANGE_FROM, RANGE_TO, TREE_BRANCH) NOT IN (SELECT SETID, TREE_NAME,  RANGE_FROM, RANGE_TO, TREE_BRANCH FROM PSTREELEAF));

insert into PSTREELEVEL (SELECT SETID, ' ' SETCNTRLVALUE, TREE_NAME, EFFDT, TREE_LEVEL, TREE_LEVEL_NUM, ALL_VALUES FROM PSTREELEVEL_89
WHERE (SETID, TREE_NAME, TREE_LEVEL) NOT IN (SELECT SETID, TREE_NAME, TREE_LEVEL FROM PSTREELEVEL));

insert into PSTREENODE (SELECT SETID, ' ' SETCNTRLVALUE, TREE_NAME, EFFDT, TREE_NODE_NUM, TREE_NODE, TREE_BRANCH, TREE_NODE_NUM_END, TREE_LEVEL_NUM, TREE_NODE_TYPE, PARENT_NODE_NUM, ' ' PARENT_NODE_NAME, OLD_TREE_NODE_NUM, ' ' NODECOL_IMAGE, ' ' NODEEXP_IMAGE FROM PSTREENODE_89
WHERE (SETID, TREE_NAME,  TREE_NODE, TREE_BRANCH) NOT IN (SELECT SETID, TREE_NAME, TREE_NODE, TREE_BRANCH FROM PSTREENODE));



Step 4 :
Security
Export:
SET LOG C:\TEMP\USER_PROFILES_C2.LOG;
SET OUTPUT C:\TEMP\USER_PROFILES_C2.DAT;
EXPORT PSOPRDEFN WHERE OPRID IN ('VN93552','VN93474','VN95541');
EXPORT PSOPRALIAS WHERE OPRID IN ('VN93552','VN93474','VN95541');
EXPORT PSROLEUSER WHERE ROLEUSER IN ('VN93552','VN93474','VN95541');
EXPORT PSUSERATTR WHERE OPRID IN ('VN93552','VN93474','VN95541');
EXPORT PSUSEREMAIL WHERE OPRID IN ('VN93552','VN93474','VN95541');
EXPORT PSUSERPRSNLOPTN WHERE OPRID IN ('VN93552','VN93474','VN95541');
EXPORT PS_ROLEXLATOPR WHERE ROLEUSER IN ('VN93552','VN93474','VN95541');
EXPORT PS_RTE_CNTL_RUSER WHERE ROLEUSER IN ('VN93552','VN93474','VN95541');

Import:
SET LOG C:\TEMP\USER_PROFILES_C2_IMPORT.LOG;
SET INPUT C:\TEMP\USER_PROFILES_C2.DAT;
SET UPDATE DUPS;
Import *;


REN FIX

 
FDEV92 Refresh


select * from PSREN;
select * from PSMCFRENURLID;
delete from PSREN;
delete from PSMCFRENURLID;
SELECT * FROM PSMCFRENURLID;
--UPDATE PSMCFRENURLID SET MCFREN_URL_ID = 'RENCLSTR_0001', MCFREN_INT_URL='http://vmpsfina1:8190', MCFREN_BROWSER_URL='http://vmpsfina1.corp.top.wr.com:8190' WHERE MCFREN_URL_ID='RENCLSTR_0008';
 

PeopleSoft Upgrade Related Script

PeopleSoft Upgrade Related Script

UPDATE PSIBRTNGDEFN SET sendernodename = 'PSFT_FINT92' where sendernodename = 'PSFT_FCNV92';
UPDATE PSIBRTNGDEFN SET receivernodename = 'PSFT_FINT92' where receivernodename = 'PSFT_FCNV92';
UPDATE PSRTNGDFNPARM SET sendernodename = 'PSFT_FINT92' where sendernodename = 'PSFT_FCNV92';
UPDATE PSRTNGDFNPARM SET receivernodename = 'PSFT_FINT92' where receivernodename = 'PSFT_FCNV92';
UPDATE PSMSGNODEDEFN SET msgnodename = 'PSFT_FINT92' where MSGNODENAME = 'PSFT_FCNV92';

UPDATE PSNODECONPROP set PROPVALUE = 't3://UXESBDEV:' where PROPVALUE like '%t3%' and msgnodename like 'WE_%';

update PSNODECONPROP set propvalue = '\\NT-WRFSDATA\PSoft_Fin\FINT92\Inter\IN\out\Hubbell' where PROPVALUE = '\\NT-WRFSDATA\PSoft_Fin\FCNV92\Inter\IN\out\Hubbell';
update PSNODECONPROP set propvalue = '\\NT-WRFSDATA\Psoft_Fin\FINT92\Inter\PO' where PROPVALUE = '\\NT-WRFSDATA\Psoft_Fin\FCNV92\Inter\PO';
update PSNODECONPROP set propvalue = '\\NT-WRFSDATA\PSoft_Fin\FINT92\Inter\AP' where PROPVALUE = '\\NT-WRFSDATA\PSoft_Fin\FCNV92\Inter\AP';
update PSNODECONPROP set propvalue = '\\NT-WRFSDATA\PSoft_Fin\FINT92\Inter' where PROPVALUE = '\\NT-WRFSDATA\PSoft_Fin\FCNV92\Inter';
update PSNODECONPROP set propvalue = '\\NT-WRFSDATA\PSoft_Fin\FINT92\Inter\IN\out\Koppers' where PROPVALUE = '\\NT-WRFSDATA\PSoft_Fin\FCNV92\Inter\IN\out\Koppers';
update PSNODECONPROP set propvalue = 'http://othercorp.com.com8880/PSAttachServlet/FINT/' where PROPVALUE = 'http://fscm.wr.com/PSAttachServlet/FCNV92/';
update sysadm.ps_BSP_IMPORT set FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FINT92\Inter\TR\in\USB\' where FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FCNV92\Inter\TR\in\USB\';
update sysadm.ps_BSP_IMPORT set FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FINT92\Inter\TR\in\USB\' where FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FCNV92\Inter\TR\in\USB\';
update sysadm.ps_BSP_IMPORT set FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FINT92\Inter\TR\in' where FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FCNV92\Inter\TR\in';
update sysadm.ps_BSP_IMPORT set FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FINT92\Inter\TR\in\' where FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FCNV92\Inter\TR\in\';
update sysadm.ps_BSP_IMPORT set FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FINT92\Inter\TR\in\WF\' where FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FCNV92\Inter\TR\in\WF\';
update sysadm.ps_BSP_IMPORT set FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FINT92\Inter\TR\in' where FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FCNV92\Inter\TR\in';
update sysadm.ps_BSP_IMPORT set FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FINT92\Inter\TR\in\JPM\' where FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FCNV92\Inter\TR\in\JPM\';
update sysadm.ps_BSP_IMPORT set FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FINT92\Inter\TR\in\WF\' where FILE_PATH_NAME = '\\NT-WRFSDATA\PSoft_Fin\FCNV92\Inter\TR\in\WF\';

UPDATE PS_FILE_DIR_FS set FILE_DIRECTORY = '\\nt-wrfsdata\PSoft_Fin\FINT92\File_Loc\EMA\' where FILE_DIRECTORY = '\\nt-wrfsdata\PSoft_Fin\FCNV92\File_Loc\EMA\';
UPDATE PS_FILE_DIR_FS set FILE_DIRECTORY = '\\nt-wrfsdata\PSoft_Fin\FINT92\File_Loc\EMA' where FILE_DIRECTORY = '\\nt-wrfsdata\PSoft_Fin\FCNV92\File_Loc\EMA';
UPDATE PS_FILE_DIR_FS set FILE_DIRECTORY = '\\nt-wrfsdata\PSoft_Fin\FINT92\File_Loc\DOC' where FILE_DIRECTORY = '\\nt-wrfsdata\PSoft_Fin\FCNV92\File_Loc\DOC';
UPDATE PS_FILE_DIR_FS set FILE_DIRECTORY = '\\nt-wrfsdata\PSoft_Fin\FINT92\File_Loc\EDX\' where FILE_DIRECTORY = '\\nt-wrfsdata\PSoft_Fin\FCNV92\File_Loc\EDX\';

UPDATE PS_FILE_DIR_FS set FILE_DIR_SERVER = '\\nt-wrfsdata\PSoft_Fin\FINT92\File_Loc\EMA\' where FILE_DIR_SERVER = '\\nt-wrfsdata\PSoft_Fin\FCNV92\File_Loc\EMA\';
UPDATE PS_FILE_DIR_FS set FILE_DIR_SERVER = '\\nt-wrfsdata\PSoft_Fin\FINT92\File_Loc\EMA' where FILE_DIR_SERVER = '\\nt-wrfsdata\PSoft_Fin\FCNV92\File_Loc\EMA';
UPDATE PS_FILE_DIR_FS set FILE_DIR_SERVER = '\\nt-wrfsdata\PSoft_Fin\FINT92\File_Loc\DOC' where FILE_DIR_SERVER = '\\nt-wrfsdata\PSoft_Fin\FCNV92\File_Loc\DOC';

select * from PSREN;
select * from PSMCFRENURLID;
delete from PSREN;
delete from PSMCFRENURLID;
SELECT * FROM PSMCFRENURLID;
UPDATE PSMCFRENURLID SET MCFREN_URL_ID = 'RENCLSTR_0005', MCFREN_INT_URL='http://other:8390', MCFREN_BROWSER_URL='http://other.corp.top.wr.com:8390' WHERE MCFREN_URL_ID='RENCLSTR_0005';


DELETE FROM PS_SERVERDEFN where SERVERNAME = 'PSNTB';
DELETE FROM PS_SERVERDEFN where SERVERNAME = 'PSNVS';
DELETE FROM PS_SERVERDEFN where SERVERNAME = 'PSNTBB';

UPDATE PS_SERVERDEFN SET DISTNODENAME = 'FINT92';

UPDATE PS_VENDOR_PAY SET EMAILID = 'zafrulla.khan@xyz.com' where EMAILID <> ' ';
update PSOPRDEFN set EMAILID = ' ' where OPRID not like 'PSF%';
update PSUSEREMAIL set EMAILID = ' ' where OPRID not like 'PSF%';
update ps_rolexlatopr set EMAILID = ' ' where OPRID not like 'PSF%';

--*******************************************************************************************************

Select A.PNLGRPNAME, C.PTSF_SRCCAT_NAME from PSPNLGRPDEFNEXT A, PSPNLGRPDEFN B, PSPTSF_SRCCAT C where A.PNLGRPNAME = B.PNLGRPNAME AND B.OBJECTOWNERID = C.OBJECTOWNERID ORDER BY 1;
select * from PSPNLGRPDEFNEXT;
SELECT * FROM PSPNLGRPDEFN;
SELECT * from PS_PTSF_SRCHCAT;
Select 'Search Categories',' ',PTSF_SRCCAT_NAME,DESCR100,LASTUPDDTTM,LASTUPDOPRID from PSPTSF_SRCCAT;
Select * from PSPTSF_SRCCAT;

SELECT * FROM PS_PTSF_SRCHCAT;
SELECT * FROM PS_PTSF_ATTRS;
SELECT * FROM PS_PTSF_CAT_ADVFLD;
SELECT * FROM PS_PTSF_CAT_DSPFLD;
SELECT * FROM PS_PTSF_CAT_FACETS;
SELECT * FROM PS_PTSF_SBO;
SELECT * FROM PS_PTSF_SBO_ATTR;
SELECT * FROM PS_PTSF_SBO_DOCACL;
SELECT * FROM PS_PTSF_SBO_DOCATR;
SELECT * FROM PS_PTSF_SBO_PNLGRP;
SELECT * FROM PS_PTSF_SRCHCATATR;
SELECT * FROM PS_PTSF_URLDEFN;

select 'SELECT * FROM PS_' || recname || ';' from psrecdefn where recname like 'PTSF_%' and rectype=0 and sqltablename=' ';


UPDATE PSPROJECTDEFN SET RELEASELABEL='All Projects' WHERE PROJECTNAME IN('WE_MASTER_PRJ_SIT1');

SELECT PROJECTNAME, LASTUPDDTTM,RELEASELABEL,RELEASEDTTM FROM PSPROJECTDEFN WHERE LASTUPDDTTM > '10-MAY-2015' AND LASTUPDDTTM < '09-JUN-2015' AND LASTUPDOPRID <> 'PPLSOFT' ORDER BY LASTUPDDTTM;

UPDATE PSPROJECTDEFN SET RELEASELABEL='WE_MASTER_PRJ_SIT1' WHERE LASTUPDDTTM > '10-MAY-2015' AND LASTUPDDTTM < '09-JUN-2015' AND LASTUPDOPRID <> 'PPLSOFT';
SELECT PROJECTNAME, LASTUPDDTTM,RELEASELABEL,RELEASEDTTM FROM PSPROJECTDEFN WHERE RELEASELABEL = ' ' AND LASTUPDDTTM >= '09-JUN-2015'AND LASTUPDOPRID <> 'PPLSOFT' ORDER BY LASTUPDDTTM;

UPDATE PSPROJECTDEFN SET RELEASELABEL='NEW' WHERE RELEASELABEL = ' ' AND LASTUPDDTTM >= '09-JUN-2015'AND LASTUPDOPRID <> 'PPLSOFT';

UPDATE PSPROJECTDEFN SET RELEASELABEL='NEW' WHERE RELEASELABEL = ' ' AND LASTUPDDTTM >= '09-JUN-2015'AND LASTUPDOPRID <> 'PPLSOFT' and PROJECTNAME='WE_PSEXI004';

SELECT PROJECTNAME, LASTUPDDTTM,LASTUPDOPRID, RELEASELABEL,RELEASEDTTM FROM psprojectdefn;

SELECT PROJECTNAME from PSPROJECTDEFN where releaselabel='NEW';
DELETE FROM PSPROJECTITEM WHERE PROJECTNAME ='WE_MASTER_PRJ_SIT1_ADDED';
insert into psprojectitem select distinct 'WE_MASTER_PRJ_SIT1_ADDED'    ,OBJECTTYPE    ,OBJECTID1    ,OBJECTVALUE1    ,OBJECTID2    ,OBJECTVALUE2    ,OBJECTID3    ,OBJECTVALUE3    ,OBJECTID4    ,OBJECTVALUE4    ,0,0,0,0,0,0 from psprojectitem where projectname in (select projectname from psprojectdefn where releaselabel = 'NEW');
SELECT PROJECTNAME from PSPROJECTDEFN where releaselabel='NEW';

SET OUTPUT D:\temp\prjexp.dat;
EXPORT psprojectDEFN where projectname in (select projectname from psprojectdefn where releaselabel = 'NEW');
EXPORT psprojectitem where projectname in (select projectname from psprojectdefn where releaselabel = 'NEW');


SET INPUT D:\temp\prjexp.dat;
SET LOG D:\temp\IMP_prjexp.log;
SET UPDATE_DUPS;

IMPORT *;


SELECT PROJECTNAME from PSPROJECTDEFN where releaselabel='All after WE_MASTER_PRJ_SIT1';
UPDATE PSPROJECTDEFN SET RELEASELABEL='All after WE_MASTER_PRJ_SIT1' WHERE RELEASELABEL = 'NEW';

-- Inactive Chartfield whose FldtoIdx to be unchecked

SELECT A.* FROM PSPTSF_SD_ATTR A WHERE PTSF_SBO_NAME IN ('EP_AP_VENDOR', 'EP_AP_VOUCHERS', 'EP_CS_DOC_CONTRACTS', 'EP_CS_DOC_PURCHORDRS', 'EP_EX_REPORT', 'EP_GL_JOURNAL', 'EP_PO_CONTRACTS', 'EP_PO_PURCHASE_ORDERS', 'EP_PO_RECEIPTS', 'EP_PO_REQUISITIONS', 'EP_PV_EXPRESSITEMS_SD', 'EP_PV_MASTERITEMVENDOR_SD', 'EP_PV_MASTERITEM_SD', 'PTPORTALREGISTRY', 'PTSEARCHREPORTS', 'PTWL_GEN_MSG_WL') AND PTSF_ISFIELDTOIDX = 'Y' AND SUBSTR(QRYFLDNAME, INSTR(QRYFLDNAME,'.')+1, 50) IN (SELECT FIELDNAME FROM PS_FS_CF_TMPLT_VW WHERE CF_ACTIVE_STATUS<>'A') ORDER BY 1,2,3;


--Active Chartfield whose FldtoIdx to be Checked
SELECT A.* FROM PSPTSF_SD_ATTR A WHERE PTSF_SBO_NAME IN ('EP_AP_VENDOR', 'EP_AP_VOUCHERS', 'EP_CS_DOC_CONTRACTS', 'EP_CS_DOC_PURCHORDRS', 'EP_EX_REPORT', 'EP_GL_JOURNAL', 'EP_PO_CONTRACTS', 'EP_PO_PURCHASE_ORDERS', 'EP_PO_RECEIPTS', 'EP_PO_REQUISITIONS', 'EP_PV_EXPRESSITEMS_SD', 'EP_PV_MASTERITEMVENDOR_SD', 'EP_PV_MASTERITEM_SD', 'PTPORTALREGISTRY', 'PTSEARCHREPORTS', 'PTWL_GEN_MSG_WL') AND PTSF_ISFIELDTOIDX <> 'Y' AND SUBSTR(QRYFLDNAME, INSTR(QRYFLDNAME,'.')+1, 50) IN (SELECT FIELDNAME FROM PS_FS_CF_TMPLT_VW WHERE CF_ACTIVE_STATUS ='A') ORDER BY 1,2,3;

Tuesday, 15 December 2015

Auto Discovery of the PeopleSoft Services on the Linux Servers.


Auto Discovery of PeopleSoft Services


Scripting made to help to check the Peoplesoft Services  on all the servers mentioned in the alias.

Technology used.

KSH with ssh shell.

Features. It auto discovers all the services running on the servers specified and provides the
list of running peoplesoft services.

I will shortly provide the script on this blog. Watch for the updates or email me to get the scripts.



 



Saturday, 12 December 2015

Automated Smart Windows Server Bounce Script for PeopleSoft



Automated Smart Windows Server Bounce Script for PeopleSoft

Technologies used.

1) Cygwin
2) PHP
3) Bash Scripting
4) Sendmail As because, PHP can not use mailx to send emails.
5) NSSM Windows Service Manager.

Problem Statement
Why do we need a windows server bounce running peoplesoft NT Process scheduler domains?



Windows OS is part of PeopleSoft architecture and can not be ignored. But, there are some difficult times where windows server become a bit uncomfortable after running for a 3 months to 6 months.

Windows Servers running Peoplesoft NT Process scheduler domains
need to be bounced/recycled periodically to avoid any unforeseen
performance issues with the peoplesoft jobs and also to avoid high CPU and Memory usage issues.


The Script follows the below criteria before bouncing the windows servers automatically.
1) The windows server should be bounced, only when there are no peoplesoft jobs running on NT Process Scheduler domain.

2) If there are any peoplesoft jobs running on the NT Process Scheduler domain, then the bounce activity need to wait for a predefined time, till all the jobs are completed and then initiate the windows server bounce.
  
3) If the wait is too long for the running jobs to complete, then abort the windows server bounce activity and report the event to peoplesoft administrator.

3) Once after the windows server is bounced, the NT process scheduler domain service need to be started automatically. so that, it can start processing peoplesoft jobs again.

4) Finally, Send detailed server bounce activity report to peoplesoft administrator along with the time stamp from start to finish.


Production Windows Server running PeopleSoft NT Process Scheduler Domains.
       
a)abc.200.xx.15 Bounce this windows box @9:00 PM MST on every 2nd Saturday of the month (PSNT)  
b)abc.200.yy.16 Bounce this windows box @9:00 PM MST on every 3rd Saturday of the month (PSNT2) (FSPRDPGP)
c)abc.200.zz.17 Bounce this windows box @9:00 PM MST on every 4th Saturday of the month (PSNT3)
                  

Joomla CMS For PeopleSoft Jump of Page.





Joomla CMS has come long way to help, I have been personally using joomla since version 1.5
It has great features and 3.x has enhanced it functionality and adaptability in various applications.

I too Agree, SharePoint is one another popular but pricezy $. Where as joomla CMS is ideal for organisation not going for sharepoint for smaller and simple applications like jump off page.

you can easily manage the html with out the need for any external html tools and don't need to have any prior knowledge of html / css and java scripts. It is adding lot of advantage in terms of publishing important updates during down time and version information etc.

Start adopting Joomla CMS to make a difference in your work as a peoplesoft administrator. This has been really working well for me in my jobs and got good feedback and appreciations from the client side.