Step By Step: PeopleTools 8.51.0 to 8.51.11

I had hoped to be able to get the PeopleTools Testing Framework posts complete before I proceeded to installing the latest update patch for PeopleTools. After constantly reading that you need to update to the latest for PTF, I decided I was being silly, and I broke down and went through the update.

Here’s what I did:

First, I downloaded the update from Oracle Support:

Update: 866843

At this point, I probably could have done the Change Assistant package. I chose to do the full install version because it would complement the instructions that I already have.

So, I downloaded 85111.zip from the PT85111UserDoc.htm page:

Stop the Services

Next, I stopped the services. For me, (since I am on a single-instance, single-user system) I just pulled my start up script out of the start up folder.

When I rebooted, everything should be stopped. To avoid rebooting, make sure that you have stopped all:

• App Servers
• Process Schedulers
• Web Servers
• PSEM Agents

Just a thought: I would clear the cache on your servers – app, batch, and web – to make sure that everything stopped as it should.  You might visually scan task manager also.

Backup

Now, keep in mind that I don’t take any responsibility for mistakes that you make or problems with anything. Hey, this is free information. So, your on your honor — back up just in case. I have a VM Instance, and I just backed up the whole machine.

Installer

Next step is to copy the install files to the machine, unzip them, and run the setup.bat file.

This brings you to the welcome screen:

Next, you have accept the license to continue:

When it asks for the license code, enter it in the blanks. If you are like me and didn’t write down the code, look up the PeopleTools license code for your platform here.

Next, you have to choose which database you currently have installed:

Then, you choose which pieces of the system you want in this particular install. For me, because it is a single server installation, I need all of the pieces.

Now, choose your current PeopleSoft home directory:

If you wish, enter your email for security updates:

I just chose all of the features:

Now, review your selections …

And, you should be off to installing:

After a short amount of time, you should see the completion screen:

Stamping New Version in Database

Next, you need to stamp the database with the new PeopleTools version to show the file system and database are in sync. You simply run the ptpatch.dms data mover script in the scripts directory of your PeopleSoft Home. (I just logged in as PS, not boot strap mode).

Then, I opened the script: \scripts\ptpatch.dms

Now, click the green light run button to execute the script.

Database Changes/App Designer Project

The next major step is to install the App Designer project. This is copying the meta data into the database.

So, log into App Designer and choose Copy Project from File — Tools > Copy Project > From File:
Copy Project > From File in the menu” width=”356″ height=”208″ />

Now, navigate to \projects and Select the PTPatch851 project in the area below. Once select, just hit the Select button:

Next, I accepted the default options here, and proceeded to copying the project:

Once it is loaded, Build the project. You should be able to use the Build > Project option.

For some reason, that option wouldn’t work for me. So, I just built each record manually. Here are the records I had to build:

• PRCSDEFN
• PSDSSECMAPMAIN
• PSGATEWAY
• PSPMSYSDEFAULTS
• PSTRIGGERDEFN
• QUERY_RUN_CNTRL
• SCHDLITEM

Note: if you select Build project, you should see the full list of records in the Scope.

Loading Messages

Messages from the message catalog do not copy via a project when copying from a file. So, we have to use this data mover script.

The instructions say to use bootstrap mode. So, you need to login as your database owner:

Then, open <PS Home>\scripts\msgtlsupg.dms.

Finally, click the green light run button to execute the script.

Reinstalling Tools

First, I unstinstalled Change Assistant:

PIA: I had just deleted the whole PIA Home thinking that I was going to reinstall.  I wish I had just deleted the cache and used the re-deploy option.  Oh, well.

Next, I uninstalled and re-installed the PeopleTools Test Framework.

Clear Rowset Cache with <PS Home>\scripts\clear_rowset_cache.dms

Then, clear App Server cache. Since I did that at the beginning, I don’t have to worry about that.

Finally, I placed my boot script back in the Startup directory, and I was good to go after a reboot.

Now, I have a 8.51.11 instance!