8.54 PreRelease Notes Available

The PeopleSoft Technology Blog has announced the availability of the PreRelease notes for 8.54:

Some observations as I skimmed the document are:

  • Oracle Linux 6, Win 2012, and Win 2012 R2 support added, Win 2008 (R1 not R2) dropped
  • Client OS Windows 8.1 added, Windows 7 (32 bit) dropped
  • WebLogic 12.1.2 added, 10.3.6 dropped
  • Oracle 12, MSSQL 2014 added, Oracle 10.2.0.5, 11.2.0.3, and MSSQL 2008 dropped
  • Current browsers available added (Chrome, Firefox, IE 11, Safari), IE 8 Firefox 17 dropped
  • Tuxedo 12.1.1.0 added, Tuxedo 11gR1 dropped
  • Still uses Java 7
  • SES is 11.2.2.2, SES 11.1.2.2 dropped
  • Excel 32-bit dropped
  • New Fluid User Interface: moves away from ridge page layouts enhancing the use of CSS3, HTML5, and JavaScript.  Supposed to “scale gracefully between devices”.  Fluid page definitions are maintained within App Designer.  Adds Fluid Homepages, Tiles, Notification Framework, PeopleSoft Navigation Bar
  • Mobile Application Platform: Similar to the Fluid User Interface but utilizes RESTful web services
  • 64-bit Development environment!  App Designer, Data Mover, Change Assistant, the whole lot of them all now 64-bit.  Explains the dropped Win 7 (32-bit).
  • App Designer will have improved search functionality (reference, text), code auto-completion for PeopleCode, and new toolbar buttons to improve productivity
  • Enhancements to App Engine tracing: split files, naming convention, program section trace, combined output of PeopleCode and SQL into the AE trace file
  • Portable PS_HOME: Hard-coded paths and sym links within PS_HOME have been removed to further consolidate and allow a single PS_HOME to be shared across multiple environments
  • Two new metaSQL enhancements for Oracle added.  %SqlHint and %SelectDummyTable
  • Also you can now use Oracle Global Temporary Tables, Materialized Views, and the new 12c container/pluggable databases which allow multiple PS databases in the same instance, some may have used GTTs and Materialized Views in the past, but now App Designer will handle them.  Also, App Designer can now be used directly to partition tables and indexes on Oracle.
  • Domain caching changes allowing automatic monitoring and adjusting?  I’ll have to look into that one more.
  • A Push Notification Event Framework, maybe we can finally broadcast a message to all users via the system.
  • Several security enhancements, Oracle Secure Files for the report repository is one that jumped out at me.
  • There’s a lot of other stuff, Just go read it !

Read the foll post here, or find the notes directly on MOS here

Monitoring Tool updates

I have finally uploaded some updated versions of my monitoring tools. I’ve made only minor updates to the Weblogic monitoring tool. I created versions that work with Weblogic 9.2 and Weblogic 8.1, but they will be available by request only.  The viewer has had a few items added and can now be used to open the files generated from the newly released (but not really new) app monitoring tool.  Continue reading

Setup AWStats on IIS

AWStats is a great tool for parsing web server access logs of any kind.  If you are not familiar with it, I recommend checking out the Live Demo to see what kind of data it can provide. I’ve been using it for a long time to provide stats on all sorts of different websites and applications (including PeopleSoft). It’s just another great tool for in any Admin’s toolbox.  Normally I run it on Linux but recently I setup AWStats on IIS which was actually pretty painless.  Here is what I did.

What you need:
IIS, Perl, AWStats Continue reading

nVision going to Error

I ran into this problem with nVision a little while ago.  nVision processes were going to error status on the process scheduler.  A quick glance at the logs made it look like either the process was crashing or not starting at all.  I logged into the Windows Process Scheduler server to take a look at Excel.  Logging in as the service account that is used to run our process scheduler I looked at task manager and saw two copies of Excel which had been running, however no jobs had been run for quite a while.  I killed the processes and tried to start Excel by hand and began to wait.  Several minutes later Excel popped up a window stating it was starting in safe mode, probably because I killed the processes I assumed.  Once it started I went ahead and closed it cleanly and tried again.  Again about four minutes later it finally opened.  However, this time it opened with the recover lost files pane open and displayed what I would estimate was 1500+ recovered files.  I closed the pane not saving any and removing them which took some more time.  Eventually I was able to shutdown Excel again.  The next time I opened it, it started right up in a second.  I proceeded to disable the AutoRecover feature in the Save settings in Excel Options (for 2007).

I’m not sure what caused them to show up, or if they were there all along and just finally got to the point where Excel took too long to open. Like many, inherited this environment, but now I have one more thing to add to my environment assessment checklist for the next time.

PeopleSoft Test Framework: Process.Run

The Basics:

Process.Run is a great feature of the PeopleSoft Test Framework.  Using this option wraps the running of a process up into just a few easy steps making the test script a lot easier to maintain.  In this post I use a Object Type dot Action notation which corresponds to how a step would be entered in PTF.  Before the period is the Type field, after is the Action field.  I’ve previously written a post on PTF installation and how to record a simple script, if you need to start from the very beginning.

PTF notation
Pseudo code to run a job looks like this: Continue reading

Oracle posts SES install tips

I’ve been really busy lately and have not been able to find the time to finish up my troubleshooting post on SES yet.  Hopefully I’ll have more time for writing posts again in a few weeks.  I did want to bring attention though to a post I noticed a few weeks ago on the PeopleSoft Technology Blog.   It speaks to the platform support of SES 11.1.2.2, the future support of SES 11.2.2.2 for PeopleTools 8.53, and also provides additional good reasons to keep your SES installs on separate hardware/vm’s than your existing PeopleSoft infrastructure.

Read the full blog post here.

Part 2: PeopleSoft SES Configuration

Previously in Part 1, I wrote about the steps to install Oracle Secure Enterprise Search for use with PeopleSoft and I reviewed some considerations for PeopleSoft Admins.  Part 2 covers the integration configuration required to have PeopleSoft communicate with SES.  On the PeopleSoft side we must setup Integration Broker properly.  On the SES side we need to configure Identity Management for PeopleSoft.

Continue reading

SES for PeopleTools 8.53 Installation

There is a lot of information to cover about Oracle Secure Enterprise Search and PeopleSoft.  As I was writing this I decided it became too much for a single post, so I’ve decided to break it into at least three posts and maybe four:

  • Part 1 – SES Installation:  Installing the SES product for PeopleSoft
  • Part 2 – Integration Configuration:  Configuring PeopleSoft and SES to communicate properly
  • Part 3 – Administration:  How to administer the PeopleSoft/SES functionality
  • Probably Part 4 – PeopleSoft/SES troubleshooting:  Troubleshooting tips and methods for the SES/PeopleSoft relationship

Background:

Oracle Secure Enterprise Search is now the new standard search engine for PeopleSoft with the release of the PeopleSoft 9.2 applications.  SES support was introduced in PeopleTools 8.52 with the new PeopleSoft Search Framework.  You can use SES with older applications, however you may need to create search indexes yourself because only the newest Feature Packs may include delivered indexes, HCM 9.1 FP 2 for example.

The PeopleSoft Search Framework provides a standardized method for creating and maintaining search indexes for PeopleSoft that should be considered an improvement over what was required previously.  Very briefly, the Search Framework Designer is used to create a search definition based on PeopleSoft Query.  In the definition you can implement security, data mapping, categories, and related searches for example.  The search is then deployed to Oracle SES through the Search Framework Administration pages.  You then run an AE which will create your index and publish a feed for Oracle SES and initiate the crawler on the SES side.  All the interaction between PeopleSoft and Oracle SES is via Integration Broker.

Verity is no longer supported for the 9.2 applications or later but is still supported in 8.53 for older applications.  SES is a separate product that can be used to index and search just about anything.  According to documentation no additional licenses are needed to use SES with PeopleSoft, so a limited use licenses is probably wrapped into the standard PeopleTools agreements for 8.52+.  SES includes Weblogic, Oracle Database Server, and the SES Application itself.  From my understanding Oracle does not support the separation of these components and has stated “SES is packaged as a ‘software appliance’ where Oracle database, mid-tier, and the SES application are all tightly integrated and shipped in a single bundle”.

When planning your deployment of SES into your environment consider the following. Continue reading