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

PeopleSoft

Application Designer: Cannot build records

I blindly added the environment variable PS_SERVER_CFG to my environment as I read somewhere that it should be set to a path similar to the following:

Believe it or not, but after I set this option, I discovered that I was no longer able to build records in my project! The following is the error I encountered: “Please select at least one action: Create Tables, Create Indexes, Create Views and/or Alter Tables. (76,41)” And…

Continue reading

PeopleSoft SQL Validator

SQL Validator corrupts Application Designer

I’ve noticed that when I run SQL Validator over a project or single SQL statement while Application Designer is still running, I later experience issues in Application Designer. I usually experience a shared key or shared cache error. In some cases I find that I have to purge the cache (using Configuration Manager) before I’m able to successfully run Application Designer again. I’m pretty sure that the problems all relate to the fact that SQL…

Continue reading

PeopleSoft

PeopleCodeTracing

There’s a simple way to turn peoplecode and SQL tracing on and off using peoplecode, rather than having to set the trace values when you login or via PeopleTools > Utilities > Debug. You can use these commands to trace/debug only the peoplecode you’re interested in. For peoplecode tracing, you set the trace flags using the SetTracePC() function. e.g

… will set the trace flags as per the defaults on the Trace Peoplecode page.…

Continue reading

PeopleSoft

Application Engine debugging issues – ParseXmlFromURL

I was trying to debug an application engine process in Application Designer, and the following line (in bold) would throw an exception and prevent me from debugging any further

The value of &sTmplFile was:

I finally discovered that the ParseXmlFromURL method requires a fully qualified path. For example:

My environment was not prepending the drive component because it did not have the PS_SERVDIR environment variable defined. Once I set this variable, everything…

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

VMWare

Moar VMWare ESXi problems

For some unknown reason, I was also not able to convert my VMWare images using the VMWare vCenter Converter. I figured out that the problem was with a particular datastore on the ESXi server. When having a look at the datastore on the ESXi server, I discovered that the datastore was reporting ridiculously high capacities (eg. 600 TB; at one time it even went negative!!). I ended up enabling SSH on the ESXi server and…

Continue reading