Oracle PeopleSoft

PeopleCodeTools – Syntax Highlighting for Sublime Text

I’ve had a few requests from people to document how I use the  PeopleCodeTools syntax highlighter in Sublime Text. Here’s a quick overview. Firstly, the source code is freely available on github, for those that would like to contribute to it. And for those unfamiliar with installing this plugin using Sublime Text, all you need to do is first install Package Control, and then install the ‘PeopleCodeTools’ plugin from Package Control. The plugin should work for PeopleCode…

Continue reading

Oracle PeopleSoft

Extracting the call stack from a PeopleCode trace

I’ve added another tool to the PeopleCodeTools Sublime Text plugin that allows you to extract the call stack from a PeopleCode trace. You can find it on the PeopleCodeTools repository on github along with the syntax highlighters for PeopleCode and PeopleSoft trace files. For those unfamiliar with installing this plugin, please see my previous post: PeopleCodeTools – Syntax Highlighting for Sublime Text This tool only applies to PeopleSoft Trace Files that have at a minimum the following trace…

Continue reading

Oracle PeopleSoft SQL Performance Tuning

PeopleSoft Trace Settings

Update: I have changed this post based on Graham’s recent comments regarding Trace Magic since the trace settings that I recommended were not actually compatible with Trace Magic. Please see the following link for information regarding Trace Magic: https://communities.oracle.com/portal/server.pt?open=514&objID=224&mode=2&threadid=382561 However, when manually reading a trace file (e.g. in Sublime Text, Notepad++, etc.) I would recommend the following trace settings: -TRACE 135 -TOOLSTRACESQL 31 -TOOLSTRACEPC 4044 I still find these settings useful for non-performance related debugging issues.

Continue reading

Oracle PeopleSoft Windows

Identifying the cause of high CPU utilisation for process oracle.exe on a Windows environment

I was running a PeopleSoft Application Engine process that I suspected was hogging the CPU on a Windows environment. I wanted to see whether this process was in fact the cause of the CPU intensive activities on the database. Interestingly, I discovered that on a Windows environment, an Oracle instance is composed of one oracle.exe process with many different threads. Each thread represents either a background process (PMON, SMON, etc.) or a foreground user session.…

Continue reading

Oracle VirtualBox

VirtualBox error – UUID already exists

I wanted to utilise the following setup: 1. Base VM (Eg. Base) that is used as a template 2. Copies of that VM (eg. JayVM, JayVM2) Since Base VM was not registered in VirtualBox, I was successfully able to create JayVM by copying the vmdk files (Windows_XP.vmdk) from Base VM to a new folder C:\hosted images\JayVM. However, I soon encountered the following error when copying the vmdk files of Base VM into new folder c:\hosted…

Continue reading

Oracle PeopleSoft

PeopleTools 8.5x – Windows – Missing or invalid version of SQL library PSORA (200,0)

I encountered the following error when trying to launch Peoplesoft applications such as Application Designer and Data Mover on my Windows 7 (64-bit) virtual machine:

My machine had Oracle Server 10.2.0.2 (64-bit) installed. I discovered that while PeopleTools 8.5x has been certified to run on 64-bit Windows platforms, the program itself is 32-bit. Thus, any library it needs to load also needs to be 32-bit. In this case, the Oracle server lib ‘PSORA’ must…

Continue reading

Oracle PeopleSoft

Application Engine: Releasing Temporary Tables

I was trying to debug an Application Engine and noticed that the debugger had hung. I restarted Application Designer and re-ran the debugger for the Application Engine. Since there was only one instance assigned to each temporary table, I noticed that the previous failed run had not released the temporary tables. I managed to work around this by deleting from the following tables:

The following are the SQL Statements that I used:

If…

Continue reading

Oracle PeopleSoft

Using Find Definition References for Impacts

If you are performing an impact analysis using Find Definition References, and are changing Record-Field PeopleCode, then you first need to determine whether the underlying Record for the Record-Field is a derived record. If the record IS a derived record, then you can use Find Definition References on the Record-Field. However, if the record IS NOT a derived record, then you need to use Find Definition References on the Record as all of the fields of the record…

Continue reading

Oracle PeopleSoft

Can no longer run Application Engine programs from Application Designer

I wasted a good couple of hours trying to figure out why my application engine programs would no longer run in Application Designer (two-tier). I have concluded that it is due to a PeopleTools bug in Application Designer. Something was causing the App Engine program to run in an infinite loop. I had to manually close the psae.exe process, and observed that the log file couldn’t even execute the first step of MAIN: PeopleTools 8.51.03…

Continue reading