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.

#308 – DDDAUDIT Mod

This week on the podcast, Dan talks about some changes to the DDDAudit report to generate SQL, and some changes in refresh scripts for 8.58. Kyle discusses ways to test and validate Integration Broker messages after a refresh.

Show Notes


#218 – 8.58 DPK


This week on the podcast, Kyle and Dan talk about the benefits of blogging for yourself, a fun SQL murder mystery game, and then they dive into the changes in the DPK for PeopleTools 8.58.

Show Notes

#111 – ACM Plugins

This week on the podcast, Kyle and Dan revisit the ACM (Automated Config Management). We discuss what the ACM is, how ACM works with the DPK, building custom ACM plugins and how to share ACM plugins.

Show Notes

  • Revisiting ACM @ 1:00
  • Using ACM with the Search Framework @ 5:00
  • ACM and the DPK @ 9:00
  • Building ACM Plugins @ 13:30
  • Plugins that are missing @ 21:45
  • GitHub Repository to Share ACM Plug-ins @ 30:00
  • IDEA – More options for “Copy to File”

#82 – Embracing Fluid Navigation

This week on the podcast, Kyle and Dan revisit Fluid Navigation and why they are fans of the new navigation model. Kyle shares his experiences working with the DPK and his method for managing the YAML and Puppet files on servers. Dan shares a top-notch “Dad Joke”.

Show Notes

#57 – REST Services

This week on the podcast, Dan and Kyle talk about Elasticsearch, using Powershell with SSH libraries, why the DPK doesn’t merge Hiera data, and how they format SQL files. Then Dan explains a new REST-based web service he built with new features in PeopleTools 8.55.

We want to make this podcast part of the community discussion on PeopleSoft administration. If you have comments, feedback, or topics you’d like us to talk about, we want to hear from you! You can email us at podcast@psadmin.io, tweet us at @psa_io, or use the Twitter hashtag #psadminpodcast.

You can listen to the podcast here on psadmin.io or subscribe with your favorite podcast player using the URL below, or subscribe in iTunes.

Podcast RSS Feed

Show Notes

TraceMagic

TraceMagic is a utility that gives PeopleSoft system administrators, programmers and support engineers the ability to quickly isolate performance bottlenecks in SQL Statements and/or PeopleCode functions. It accomplishes this by turning the text-based, time-ordered tracesql file into a sortable-grid display, allowing the user to quickly locate system performance issues.

TraceMagic is a great tool for reading .tracesql files. The ability to group SQL by SELECT statements and see all the tables queried in the trace are great for debugging issues.