Friday, 22 April 2016

UKOUG PeopleSoft Roadshow 2016

What a great day at the annual UKOUG PeopleSoft Roadshow.

My top 5 highlights include
  1. Networking with Customers, Oracle and Partners.  Discussing new stuff, sharing stories, showing our tech-scars and solving problems.  Love it!
  2. Hearing all the latest from Marc Weintraub, Director of PeopleSoft Product Strategy at Oracle.  He's an engaging speaker and covered a huge range of topics including PeopleTools 8.55 and beyond, PeopleSoft Cloud Architecture, Oracle Compute Cloud Services, PeopleSoft ERP(FSCM) and HCM application updates.  The innovations and pace of new and exciting features is quite astonishing. 
  3. From PeopleTools 8.56 the monthly patch releases will start to include feature enhancements to PeopleTools.  This is an exciting prospect.

    The engineer in me loves PeopleTools.  One of those meta data based, domain specific programming frameworks where the language is used to develop and enhance the language itself.  (For example....  Q. what is PeopleTools Query Manager written in ?  A. PeopleTools ).
  4. Oracle Compute Cloud has a Database as a Service offering.  PeopleSoft can run on this platform  Very exciting for those temporary and transient instances of PeopleSoft that you need to spin up for development, testing, training etc but you don't want to buy another RDBMS license or go to the expense and trouble of finding a server, installing and then ongoing patching and maintenance.  I'll be blogging more on this very soon.
  5. And finally... I got a chance to discuss in detail some of the learning experiences of using the new PeopleSoft DPKs on both VirtualBox and Native.  The PeopleSoft Cloud Architecture really is another game changer for PeopleSoft customers in a similar way to Selective Adoption.  I'll be blogging more on this soon too.

Friday, 1 April 2016

PeopleCode Debug a 2-tier Application Engine Process - PeopleCode Friday #6

This is not really a PeopleCode tip but rather a tip to debug PeopleCode in an Application Engine process.

I had forgotten you could do this until recently I needed to step through some code in an AE and be able to examine buffer and variable state as I went.

For PIA debugging you need the debug service and the WSL setup on the Application Server and then connect Application Designer in 3-tier mode.  My recommendation is to set this up long before you need it!  This mode, however, is only useful for debugging online PIA sessions and not Application Engine process running on the batch server.

If you can run your AE process in Application Designer then you can use this technique to step through each Section, Step and PeopleCode statement.

Just a few tips

  • Create a run control called "RUN01".  This will make life easier if you're repeatedly running the same AE during development or testing as RUN01 is the default.
  • You can enable SQL and PeopleCode trace in Configuration Manager.  This will send trace output of the actual SQL being executed and you can open this file during debugging. Very useful.
  • Don't forget to use Step Over (F10) for avoiding getting bogged down in lots of function or method code.
  • Don't use Output Log to File when you run as it will repeatedly send prompts for user interaction to the log file until your local disk is full !!!! 

Step 1 -  Setup Config Manager

In Configuration Manager > Profile > Edit > Process Scheduler > Application Engine tick the Debug option.

Step 2 - Open the Application Engine

Step 3 - Open PeopleCode section and Enable Debug

Step 4 - Set Breakpoints in PeopleCode

Step 5 - Run the App Engine process

Step 6 - Use the AE process window

Step 7 - Step through PeopleCode

Watch the whole thing here...