E.8 Updating the Collection Page and Pagelet Node

The content provider Navigation pages and pagelets are delivered to render out of the content provider database. This is determined by the content reference node name. Since the full navigation exists in the new site, you must set the published navigation pages and pagelets to render out of the PeopleSoft Portal Solutions database, not the PeopleSoft content provider.

To update the Navigation Collection page and PeopleSoft pagelet content provider node:

1. Use a SQL query and update tool to access the PeopleSoft Portal Solutions database.

2. Run the following SQL query statement to check the rows that you will be updating.

   Replace the string <MY_NEW_SITE> with the portal name of the site created.

   Replace the string <PREFIX> with the prefix used on delivered PeopleSoft Portal registry objects.

   For example, HC, EP, CR, PF.

   SELECT * FROM PSPRSMDEFN 
   WHERE PORTAL_NAME = '<MY_NEW_SITE>'
   AND PORTAL_OBJNAME LIKE '<PREFIX>%' 
   AND PORTAL_PRODUCT = 'CFAN' 
   AND PORTAL_CREF_USGT <> 'LINK' 
   AND PORTAL_REFTYPE = 'C'
   

3. Run the following SQL update statement to update the published Navigation page.

   Replace the string <MY_NEW_SITE> with the portal name of the site created.

   Replace the string <PREFIX> with the prefix used on delivered PeopleSoft Portal registry objects.

   For example, HC, EP, CR.

   UPDATE PSPRSMDEFN SET PORTAL_CNTPRV_NAM = 'LOCAL_NODE'
   WHERE PORTAL_NAME = '<MY_NEW_SITE>'
   AND PORTAL_OBJNAME LIKE '<PREFIX>%'
   AND PORTAL_PRODUCT = 'CFAN' 
   AND PORTAL_CREF_USGT <> 'LINK' 
   AND PORTAL_REFTYPE = 'C' 

4. After you update the PeopleSoft portal registry structures, you must delete the application server cache.

5. Stop and restart both your web server and your application server.