#329 – RTI Maintenance

This week on the podcast, we talk about the RTI Maintenance job, fixing the systemd scripts from the DPK, and using the OCI-AutoScale project.

Show Notes


#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.

#318 – Open Source w/ Tim Slater

This week on the podcast, Tim Slater joins us to talk about his open source PeopleSoft projects: TraceWizard, DMS-Viewer, ProjectViewer, and Pivet.

Show Notes

#315 – DMSViewer

This week on the podcast, Dan revisits a tip for debugging Change Assistant issues and a replacement for the ls command, and Kyle talks about the new 8.59 Infra-DPK.

Show Notes


#313 – ACM Execution

This week on the podcast, Dan shares some recent bash tips he learned, and Kyle and Dan discuss different ways to execute ACM and their pros and cons.

Show Notes


#311 – Cloud Manager 13

This week on the podcast, Dan shares some new PeopleTools ideas for Change Assistant and Control-J, and Kyle and Dan talk about the new Cloud Manager 13 features.

Show Notes


#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


#301 – Inverse Square

This week on the podcast, Kyle and Dan talk about Red Hat 8, containers, some issues with the latest PUM images, and a crazy fun inverse square function.

Show Notes