Tricks
View Memory Cookies PDF Print E-mail
Written by David Vandiver   
Thursday, 28 April 2011 03:22

There are two kinds of cookies; file-based and memory.  PeopleSoft stores information in memory cookies that could assist with knowing which web server your user has connected to.

While on a PeopleSoft page, type the following in the url to see your memory cookies:

javascript:alert(document.cookie);

 

This is handy when your system has more than one web server, and you believe that the issue happens on one or a portion of your web servers.

 
Step Through PeopleCode PDF Print E-mail
Written by David Vandiver   
Thursday, 28 April 2011 02:54

In PeopleTools 7.5, we had Application Reviewer for debugging PeopleSoft. For PeopleTools 8.4x and 8.50, since the panels are now pages on the browser, how do we debug peoplecode (interactively)? The answer follows:

How to Step Through PeopleCode

To step through PeopleCode that is running on the browser, do the following. The first four steps will be handled by your PeopleSoft Administrator.

  1. Ensure the appropriate PSDBGSRV Listener Port is specified on the App Server.
  2. At least two PSAPPSRV processes should be configured on the App Server.
  3. The Service Timeout parameter should be set to zero.
  4. The “Enable PSDBGSRV Server Process” should be set to Yes on the App Server.
  5. Launch Application Designer on the workstation. Log in using 3-tier and your userid.
  6. Under menu item Debug, select “Enter Debug Mode”.
  7. Launch PeopleSoft through the browser, and use the same userid as in step 5.
  8. Go the page needing review.
  9. On the debug menu in App Designer, select either debug at start or create new breakpoints (similar to 7.5).
  10. Go back to the browser and trigger the PeopleCode. Once the breakpoint is triggered, the App Designer will wait for you to respond. The web browser will appear to be loading the next page (“Processing” might flash).

 

Special Notes

  1. May not work on Windows 95 and 98 machines.
  2. Debug will slow performance.
  3. Debug should not be run in Production.
  4. Use a user id that is not being shared (use your own id, not VP1).
  5. Some clients have seen connection problems for other users after the debug has been performed. If this happens, perform debugging in the evening or during times that few users are in the database. If the connection problem occurs, then reboot the Application and Web Servers. Since the debug should not be run in Production, this minor occurrence can be handled by rebooting the proper servers/services.

 

Last Updated on Thursday, 28 April 2011 02:57
 
Tracing on Application Engine PDF Print E-mail
Written by David Vandiver   
Thursday, 28 April 2011 02:50

How to turn SQL Trace and PeopleCode Trace on an Application Engine

 

  1. Go into the process definition of the Application Engine.
  2. On the “Override Options” tab, on the parameter list, choose APPEND and enter the following:

    -TRACE 7 -TOOLSTRACEPC 3596 -TOOLSTRACESQL 131

    Change the numbers to reflect the level of tracing you desire.

  3. Run the App Engine through the normal processing pages. In the process monitor, you can retrieve the SQL and PeopleCode trace files with the logs.
  4. Once you are finished, change the settings back (most likely it was originally set as NONE).
Last Updated on Thursday, 28 April 2011 02:54
 
Compare Reports Made Easy PDF Print E-mail
Written by David Vandiver   
Wednesday, 27 April 2011 19:55

Whether applying a patch or upgrading an entire PeopleSoft application, this article is for you.

When you run the compare reports, most developers cringe at the pain-staking task of reviewing what was changed in order to do the retrofits.

This attached zip document should ease that pain.  Utilizing an SQR to Excel utility I wrote (www.SQRTricks.com), I pull the project items from the database and export them into an easy to read Excel file, complete with developer names.  The zip file contains a Word document that will assist in the required steps to get this to work.

Last Updated on Wednesday, 26 October 2011 17:47
 
Commitment Control ERD PDF Print E-mail
Written by David Vandiver   
Wednesday, 27 April 2011 19:55

Sometimes having an ERD for a set of tables makes life easier.  Attached are Commitment Control ERDs I created for version 8.4.  These are still relevant as of 9.1.

There are two downloads; the first one is in Word format, and the second one is in Visio.

 

Word Format

Visio Format

Last Updated on Wednesday, 27 April 2011 20:10
 


RocketTheme Joomla Templates