Retiring (Deleting) an App Engine Process

It's easier than I suspected it would be to delete an App Engine process from your PeopleSoft environments using App Designer.   But it's not completely intuitive.  The steps to delete an App Engine, as well as what to avoid, are explained in this article.

"Invalid Value" on a PeopleSoft Page? Check the Case of the Corresponding Field Object

Have you ever had the situation where you know that the data in your lookup table is accurate, yet any time you try to select a value from that table via a drop-down list, you get the "Invalid value" error when you try to save the data?  It's most likely because your database column contains mixed-case data, but the field object that you defined in PeopleSoft App Designer to represent that data requires uppercase data. Here's how I discovered and fixed the problem.

PeopleSoft: Which Project is My App Engine In?

One of my favorite "tools" in PeopleSoft App Designer is Edit -> Find Definition References. If I'm not sure, for example, whether a page I'm working on has been included in the appropriate project, Find Definition References will help me quickly find out whether it is or not.

That doesn't work so well when I want to find which project an Application Engine program is in.

When I select Edit -> Find Definition References for an App Engine, I see something like the following.












Well, I pretty much already knew that!

There is a way that I can find which project an App Engine is included in, but it requires a database query. I can use a query similar to the following:

select * from sysadm.psprojectitem
where objectvalue1 = 'MY_APP_ENGINE';

Using the above query, if your App Engine is included in any projects, the value in the OBJECTVALUE1 column will be your App Engine name. App Engine objects have the following object types:

• 33 - App Engine Program
• 34 - App Engine Section
• 43 - App Engine Step

Occasionally, references to App Engines are stored differently in PSPROJECTITEM (if anyone knows why, please clue me in!). If the above query doesn't work, use a query similar to the following:

select * from sysadm.psprojectitem
where objectvalue1 = 'Application Engine'
and OBJECTVALUE2 = 'MY_APP_ENGINE';

Using this query, if your App Engine is included in any projects, the value in the OBJECTVALUE2 column will be your App Engine name.

With one of those two queries, you should be able to find whether your App Engine is included in the appropriate project.