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';