#326 – Portal Registry Migration Fixes

This week on the podcast, Kyle and Dan talk about what they learned about migrating Portal Registry objects.

Show Notes


Portal Registry Migration Fix

Sometimes when migrating Portal Registry objects I find that they do not show up in the Navigator, or even Structure and Content, until I clear cache, run VERSION, or even make a nominal change to the Portal Registry. We talked about this on the podcast in episode #303. I took Kyle’s idea of adding a sibling record in Structure and Content and traced what SQL was changing when saving the sibling record. There were INSERT statements for the new CREF, but there are also some important VERSION updates.

  1. Update overall VERSION to track the new changes
  2. Update the VERSION specifically for the Portal Registry object types
  3. Update the VERSION for the parent Portal Registry folder (in my case, the Root folder)

Below is a script I use with Phire; we execute this script after the object migration to make sure our new CREFs are visible.

-- Update overall VERSION for SYS and PRSM types
update PSVERSION set VERSION = VERSION + 1 where OBJECTTYPENAME in ('SYS','PRSM');

-- Update VERSION for Portal Registry objects
UPDATE PSLOCK SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME = 'PRDM';
UPDATE PSLOCK SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME = 'PRSM';

-- Update CREF Parent - Change PORTAL_OBJNAME as needed
UPDATE PSPRSMDEFN SET VERSION = (select VERSION from PSLOCK where OBJECTTYPENAME = 'PRSM'),  LASTUPDDTTM = TO_TIMESTAMP(sysdate,'YYYY-MM-DD-HH24.MI.SS.FF')  WHERE PORTAL_NAME = 'EMPLOYEE' AND PORTAL_REFTYPE = 'F' AND PORTAL_OBJNAME = 'PORTAL_ROOT_OBJECT';

commit;

Thanks for Andy Dorfman for catching a change in my original SQL. The first statement should include both the SYS and PRSM types.

#303 – Portal Registry Migrations

This week on the podcast, Kyle talks about challenges with migrating Portal Registry objects, getting free OCI training and certification, and some tips for making SQL Developer faster.

Show Notes


#188 – Maintenance Tiles


This week on the podcast, Kyle follows up on his Maintenance Tiles work and explains why he rewrote it using Portal Registry APIs. Kyle also shares an issue with Rich Text Editor images and Dan shares another “Adventures in MOS”.

Show Notes

#154 – Portal Registry Security


This week on the podcast, Dan shares some tips on monitoring Tuxedo domains and Kyle discusses how to secure portal registries when accesses externally.

Show Notes

  • Data Mover Follow-up @ 3:00
  • PeopleTools POC Business Case Document @ 5:45
  • Tuxedo Service Monitoring @ 7:30
    • PS_HOME/utilities/psautolog.sh
  • Limiting Access to Portal Registries @ 17:45
    • GreyHeller/Appsian
    • Role Flipping
    • Separate Registry and Obscurity
    • LB/RPS/WL Filter Security
    • VPN Access
    • Conditional Navigation