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

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