Configure Change Assistant to Apply Patches

1. Configure PSEMHub
2. Configure PSEMAgent
3. Configure Change Assistant
4. Validate the environment
a. through change assistant
b. through PSEMViewer
5. Upload your environment
6. Download the patches / bundles suggested
7. Apply the downloaded bundles/patches.

Configure PSEMHub
PSEMHub gets configured when you build your PIA
Start you PIA and you PSEMHub will be accessible
:/PSEMHub">http://:/PSEMHub

Configure PSEMAgent
1. Configure configuration.properties
\PSEMAgent\envmetadata\config\configuration.properties
2. change the hub url and port and directories to crawl
#hubURL= this is the host and port the agents talk to
hubURL=http://Site:port>/PSEMHUB/hub
agentport=5283
#ping interval in milliseconds for the peer to contact the hub for new
#messages pinginterval=10000
#Windows directories need to use the forward slash ('/') character.
#For multiple directories, use a '' character as separator
windowsdrivestocrawl=d:
Start the Agent : \PSEMAgent\startagent.bat recrawl -- recrawl the dir's
\PSEMAgent\startagent.bat --start the agent
Configure Change Assistant
1. Open Change Assitant - Tools - Options
2.
a.Apply Application Updates
b.Directory to download updates
c.PSHome
d.Staging and output directory
e.Enivronment Management Hub -

Upload the environment
1. Give metalink connection details and follow the screens.
checking the environment
1. Validate the environment from the change assistant - Tools -> Validate
2. PSEMViewer - \PSEMViewer\geteninfo.bat
3. Supply the http port to the web port and detailed
4. under the \PSEMViewer\envmetadata\data directory viewer.html
will be generated
Important things to note.
1. Configure GUID
For fresh installation - PSOPTIONS.Guid field is going to be blank so configure and boot
the application server or process scheduler and guid column will be updated.
For a cloned database update psoptions set guid = ' ';
reboot the application server or process scheduler.
2. Clearing cache:
PSEMHUB/envmetadata/Scratchpad
PSEMHUB/envmetadata/PersistentStorage
PSEMHUB/envmetadata/transactions (if it exists)
PSEMHUB/envmetadata/data/*.* (files and directories. Don't delete the data directory itself)
DO NOT DELETE THE MATCHERS.XML

Change Package for Migrating Customization

Using Change Assistant to Migrate Customization between PeopleSoft Environments

Following are the basic steps involved
1. Create a new Project in PeopleSoft Application Designer
2. Navigate to Project Properties and specify the project to be Change Project.
3. Add all the necessary object to the project, include he file reference if any
4. Use Change Packager to generate Change assistant template
5. Finalize the change package using finalise change package option which generates a zip file

What to expect when you run the change packager?
1. Manifest – xml document that contains information about the package.
2. Manifest would have information about update id included in the package, pre-requisites if any, user information , manual steps , definition type wise count of objects
3. All with this it would create folders for
o Change Assistant Template
o Documentationo File References
o Project Folder
o 8.44 project folder
What to expect when we finalize the change project.
1. Zip file in the staging directory in the following format
Package

Step by Step document to follow. . . .

Exporting Projects definition from datamover

Following tables are used to extract projects definition . We need to add the appropriate where clause.

1 PSPROJECTDEFN 
2 PSPROJECTITEM 
3 PSPROJDEFNLANG 
4 PROJECTNAME
5 PSPROJECTDEP
6 PSPROJECTINC
7 PSPROJECTMSG
8 PSPROJECTSEC

UpgCount

set serverout on size 1000000
DECLARE
CURSOR C1 IS
SELECT RECNAME, SQLTABLENAME FROM PSRECDEFN WHERE RECTYPE = 0 ORDER BY RECNAME;

VAR_COUNT NUMBER;
VAR_REC_COUNT NUMBER :=0;
VAR_SQLTEXT VARCHAR2(32000);
VAR_RECNAME VARCHAR2(64);
VAR_PAD VARCHAR2(100);
VAR_DATE DATE;

BEGIN

SELECT SYSDATE
INTO VAR_DATE
FROM DUAL;

DBMS_OUTPUT.PUT_LINE('Report for Record Rowcount');
DBMS_OUTPUT.PUT_LINE('START DATE AND TIME:'TO_CHAR(VAR_DATE,'MM/DD/YYYY HH24:MI:SS'));

DBMS_OUTPUT.PUT_LINE('RECNAME Row Count');
DBMS_OUTPUT.PUT_LINE('============================== =========');

FOR CUR_REC IN C1
LOOP


--VAR_PAD := RPAD(' ',31 - LENGTH(CUR_REC.RECNAME));
IF SUBSTR(CUR_REC.SQLTABLENAME,1,2) = 'PS' THEN
VAR_RECNAME := CUR_REC.RECNAME;
ELSE
VAR_RECNAME := 'PS_'CUR_REC.RECNAME;
END IF;

--IF NVL(LENGTH(RTRIM(CUR_REC.SQLTABLENAME)),0) = 0 THEN
-- VAR_RECNAME := 'PS_'CUR_REC.RECNAME;
--END IF;

VAR_REC_COUNT := VAR_REC_COUNT + 1;

BEGIN

VAR_SQLTEXT := 'SELECT COUNT(*) FROM 'VAR_RECNAME;
EXECUTE IMMEDIATE VAR_SQLTEXT INTO VAR_COUNT;

DBMS_OUTPUT.PUT_LINE(CUR_REC.RECNAME' 'VAR_PADVAR_COUNT);

EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(CUR_REC.RECNAMEVAR_PAD'ERROR - 'SQLERRM);

END;
END LOOP;

DBMS_OUTPUT.PUT_LINE('============================== =========');
DBMS_OUTPUT.PUT_LINE(' ');
DBMS_OUTPUT.PUT_LINE('Total Number of Tables = 'VAR_REC_COUNT);

SELECT SYSDATE
INTO VAR_DATE
FROM DUAL;

DBMS_OUTPUT.PUT_LINE('END DATE AND TIME:'TO_CHAR(VAR_DATE,'MM/DD/YYYY HH24:MI:SS'));
END;