Thursday, November 13, 2014

Email Addresses in PeopleSoft

PeopleSoft stores email addresses in following tables
  1. PSOPRDEFN
  2. PS_ROLEXLATOPR
  3. PSUSEREMAIL
  4. PS_EMAIL_ADDRESES
First three are used in email notifications and it depends on the application. It is best to update all of these tables when testing a notification process so you don't spam the whole company just in case something goes south.

Wednesday, May 14, 2014

Setting up REN Server with BigIP/ F5 load balancer

Configuring BigIP for REN server is not very complicated. There are just a few steps but you need to make sure you do it right. Troubleshooting becomes more difficult especially when you do not have access to BigIP.

My configuration:
2 web servers  (Load balanced)
2 App Servers

We did not have a dedicated vip for REN server so we used the one that was load balancing web servers. This will slightly change the iRule. So, here are the steps
  1.  Create Ren Server definitions in PeopleSoft for every app server running PSRENSRV
  2. Create cluster definitions in PeopleSoft for every REN server definition  (in my case PSREN1 and PSREN2). I will not get into the pros and cons of setting up multiple clusters or single cluster with multiple members. In my experience I have found multiple clusters each with one member to be better
  3. Set REN server browser URLto your vip:port
  4. Create an iRule in BigIP 
when HTTP_REQUEST {
   if {[HTTP::uri] starts_with "/psren1"}{
       node APPSRVR1 port
     }
  elseif {[HTTP::uri] starts_with "/psren2"}{
       node APPSRVR2 port
}
else {
"you would want to forward request to your web server pool if the request is not for PSREN1 or PREN2. You would not need this step here if you have a dedicated vip for ren server".
   }
}


Clear App, Web, Process Scheduler cache and you are in business