#13 – PeopleTools Patching

This week, Kyle shares his lessons learned from a recent PeopleTools patching project, we discuss the pro’s and con’s of Unified Navigation, new PeopleSoft Rundeck plug-ins, and changes to the 9.2 upgrade with PeopleTools 8.55.

We want to make this podcast part of the community discussion on PeopleSoft administration. If you have comments, feedback, or topics you’d like us to talk about, we want to hear from you! You can email us at podcast@psadmin.io, tweet us at @psa_io, or use the Twitter hashtag #psadminpodcast.

You can listen to the podcast here on psadmin.io or subscribe with your favorite podcast player using the URL below, or subscribe in iTunes.

Podcast RSS Feed

Show Notes

What’s New in PeopleTools 8.55 Video

If you haven’t visited the homepage, you may have missed our first video. We’ve been working with 8.55 and wanted show you some of the best new features. In this free 30 minute talk, we discuss some of the biggest changes, like the Peoplesoft Cloud Architecture, that affect PeopleSoft Administrators. We also cover features that weren’t promoted but could substantially change the way we approach customizations. There are 4 demos in the video, including a demo that shows how to use the new Deployment Kits to build a web, app and batch server.

Sign up to receive a FREE 30 minute video to learn about PeopleTools 8.55.

 

#12 – Migrations

This week on The PeopleSoft Administrator Podcast we dig into migrations. Kyle shares everything he likes about Phire and the benefits of a version control tool. Dan discusses an alternative to Phire and Stat – Change Assistant. We also discuss the new Native Push Notifications update in PeopleTools 8.55.

We want to make this podcast part of the community discussion on PeopleSoft administration. If you have comments, feedback, or topics you’d like us to talk about, we want to hear from you! You can email us at podcast@psadmin.io, tweet us at @psa_io, or use the Twitter hashtag #psadminpodcast. You can listen to the podcast here on psadmin.io or subscribe with your favorite podcast player using the URL below, or subscribe in iTunes.

Podcast RSS Feed

Show Notes

8.55 – Log Analyzer

The Log Analyzer is a new PeopleTools 8.55 tool that helps you get more information from App Engine trace files. Log Analyzer is specific to analyzing App Engine traces. It feels like a simplified version of TraceMagic (a good thing!). If you have used TraceMagic for PeopleCode, or the Trace2SQL utility to parse .tracesql files, Log Analyzer feels like the two tools combined.

Trace Settings

You need to set the App Engine trace settings to at least these values in the psprcs.cfg file for the Log Analyzer to work:

  • Trace SQL: 3
  • Trace PC: 64

If you are using Config Manager, that translates to these options:

PeopleCode Trace

  • Trace Start of Programs

App Engine Trace

  • Step
  • SQL

Last, you can set them at the process level:

  • -TRACE 3 -TOOLSTRACEPC 64

You can use higher trace values, but these are the minimum for the Log Analyzer to correctly parse your files. Make sure to specify the App Engine SQL trace. If you select the PeopleTools SQL trace, you won’t get an *.AET file when the app engine runs. You can generate a SQL trace (.tracesql) and an App Engine trace (.AET). But at a minimum, you need an *.AET file. Log Analyzer also uses the .TRC PeopleCode trace file.

Log Analyzer GUI

The Log Analyzer tool is a separate java application located under PS_HOME\bin\client\winx86\AELogAnalyzerTool. To launch the tool, run the runTraceAnalyzer.bat batch script. After launching the tool, you’ll see an empty screen. You need to load in an *.AET file.

Screen Shot 2015-12-30 at 1.38.48 PM

Once you load an *.AET trace file, the Log Analyzer will display the heirarchy of the trace program in the lower window. You can expand each section and click on the SQL steps. To view the associated SQL and parameters, click on the “View Details” button. You can also look at the trace in execution order (without the parent/child nesting) by clicking on the “Linearize” button.

Load PeopleCode

If you generate a PeopleCode .TRC trace file, you can import the .TRC file into Log Analyzer. If the trace file has the “Trace Start of Programs” lines (value 64), Log Analyzer will correlate the PeopleCode statements to the app engine step. In the lower window, you can click on the PeopleCode step and view the PeopleCode much like the SQL.

Apply Filters

Log Analyzer has different ways to filter and view your trace file. There are four options to view the different SQL operations: insert, select, update, delete. You can also filter the log output based on a text value, the duration of the step (useful for tuning), or by the number of rows updated.


Log Analyzer feels like a new tool. It functions are still limited (you can filter, but not search), but I think it will be a great tool to add for admins and developers. If you have used TraceMagic, Log Analyzer will be easy to pick up.

#11 – Fluid Navigation

This week on The PeopleSoft Administrator Podcast, we talk about Fluid Navigation. Dan shares his dislikes (and likes) of the default navigation style in PeopleTools 8.55. We also talk about new PeopleTools 8.55 features like Log Analyzer, CORS support and Log Correlation.

We want to make this podcast part of the community discussion on PeopleSoft administration. If you have comments, feedback, or topics you’d like us to talk about, we want to hear from you! You can email us at podcast@psadmin.io, tweet us at @psa_io, or use the Twitter hashtag #psadminpodcast.

You can listen to the podcast here on psadmin.io or subscribe with your favorite podcast player using the URL below, or subscribe in iTunes.

Podcast RSS Feed

Show Notes

8.55 – Cross-Origin Resource Sharing

In PeopleTools 8.55, Cross-Orign Resource Sharing (CORS) is now supported. Don’t know what CORS allows? Here is a good primer on the topic.

The Same-Origin Policy restricts the browser from performing certain actions by scripts or documents based on the origin. The origin is everything in the URL before the path (for example, http://www.example.com). For certain actions, the browser will compare origins and, if they don’t match, won’t allow things to proceed. For example:

  • A parent document can’t access the contents of an that comes from a different origin. This prevents a malicious site from opening up your bank’s website and stealing your credentials, as an example.
  • While one document can send information to another via a form post, AJAX requests across origins are generally disallowed.

The Same-Origin Policy is a vital piece of web security architecture, but it also poses a problem. What happens when you want to allow a site with a different origin to access your content?

Here is a great example of where CORS support can benefit PeopleSoft. In Enterprise Learning Management, you can link to hosted web-based training. Often, that web-based training is on a different domain. With CORS support, you can add in remote sites in the Web Profile and display remote courses in your ELM environment.

To enable Cross-Origin sites, open your Web Profile. There is a new tab, Authorized Site, that lets you list many sites to support.

#10 – Documentation and Tools Part 2

This week on The PeopleSoft Administrator Podcast, Part 2 of the Documentation and Tools episode. In Part 2 we talk about our favorite text editors, password safes, frameworks, utilities, graphing scripts, browser extensions, plug-ins, and a whole lot more! There is a wealth of information in this podcast and you’ll find at least one software tool that is new to you! The show notes have links to all the tools, so make sure to download and try anything that sounds useful to you.

We want to make this podcast part of the community discussion on PeopleSoft administration. If you have comments, feedback, or topics you’d like us to talk about, we want to hear from you! You can email us at podcast@psadmin.io, tweet us at @psa_io, or use the Twitter hashtag #psadminpodcast.

You can listen to the podcast here on psadmin.io or subscribe with your favorite podcast player using the URL below, or subscribe in iTunes.

Podcast RSS Feed

Show Notes

VERSION Run Control Options

I have to keep looking this up, so I’m writing it down to make it easier to find next time! There are three modes for the VERSION app engine:

  • Report Mode
    Evaluates the VERSION counters and reports any changes needed; does not change data.
  • Classic Mode
    Resets all the VERSION counters to their starting value (1)
  • Enhanced Mode
    The default mode – it will “advance VERSION counters in a preditable manner” according to Oracle Support.

The name of your run control is how you change the behavior of the VERSION app engine.

  • Report Mode: REPORTONLYxxx – The run control must start with the REPORTONLY value (not case-sensitive)
  • Classic Mode: RESETVERSIONSxxx – The run control must start with the RESETVERSIONS value (not case-sensitive)
  • Enhanced Mode: Any value other than the two above will trigger Enhanced Mode

There is much more to running VERSION, but I’ll save that for another post.

#9 – Tools and Documentation Part 1

This week on The PeopleSoft Administrator Podcast we talk about documentation, how we like to document, what has worked for us and some of our documentation pet peeves. We also share all of our favorite tools that make the PS Admin job easier. This topic was so much fun, we had to make it a 2 part episode. Enjoy Part 1 this week. We’ll release Part 2 next week.

We want to make this podcast part of the community discussion on PeopleSoft administration. If you have comments, feedback, or topics you’d like us to talk about, we want to hear from you! You can email us at podcast@psadmin.io, tweet us at @psa_io, or use the Twitter hashtag #psadminpodcast.

You can listen to the podcast here on psadmin.io or subscribe with your favorite podcast player using the URL below, or subscribe in iTunes.

Podcast RSS Feed

Show Notes