Loading...
I am using Unified Navigation in my Portal (Interaction Hub) environment. When a database that is refreshed from production I needed a quick way to update the Unified Navigation configuration information with SQL. Here is the updates I have found useful in my environment. 


--Interaction Hub Unified Navigation refresh:
--Remote Content
UPDATE PS_PTUN_DDMENUCFG
SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%'), 
DESCR30 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%'),
PORTAL_OBJNAME1 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%') || ':PORTAL_ROOT_OBJECT'
WHERE MSGNODENAME = '<HR_PRODUCTION_NODE>';

UPDATE PS_PTUN_DDMENUCFG
SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%'), 
DESCR30 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%'),
PORTAL_OBJNAME1 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%') || ':PORTAL_ROOT_OBJECT'
WHERE MSGNODENAME = '<CS_PRODUCTION_NODE>';

--Message Nodes
--HCM Node
UPDATE PSUN_CFGHNODE
SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%')
WHERE MSGNODENAME = '<HR_PRODUCTION_NODE>';

--Campus Node
UPDATE PSUN_CFGHNODE
SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%')
WHERE MSGNODENAME = '<CS_PRODUCTION_NODE>';

--Structure & Content
UPDATE PSPRSMDEFN 
SET PORTAL_LABEL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%')
WHERE PORTAL_CNTPRV_NAM = '<HR_PRODUCTION_NODE>';

UPDATE PSPRSMDEFN 
SET PORTAL_LABEL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%')
WHERE PORTAL_CNTPRV_NAM = '<CS_PRODUCTION_NODE>';

--Folder Attributes
UPDATE PSPRSMSYSATTRVL 
SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%')
WHERE PORTAL_ATTR_VAL LIKE '<HR_PRODUCTION_NODE>';

UPDATE PSPRSMSYSATTRVL 
SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%')
WHERE PORTAL_ATTR_VAL LIKE '<CS_PRODUCTION_NODE>';

UPDATE PSPRSMSYSATTRVL 
SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%') || ':PORTAL_ROOT_OBJECT'
WHERE PORTAL_ATTR_VAL LIKE 'CS%ROOT%';

UPDATE PSPRSMSYSATTRVL 
SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%') || ':PORTAL_ROOT_OBJECT'
WHERE PORTAL_ATTR_VAL LIKE 'HR%ROOT%';






Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
I have been running a new VirtualBox HR PUM Image for several weeks. I've recently been unable to login into the image even though it appears to be running. I ran across an article on MOS that talked about the disk becoming full and that was my problem.

Over time you will have log and core files that will build up and not allow the PIA and other processes to start due to a lack of space for the log files. You can log in to the Image as the root user and run the "df -k" command to view available space.





The solution is to remove core dump files (core.*), trace files, log files and cache files from
the directories. I removed all of these files from the following directories:

/home/psadm2/psft/pt/8.55/appserver/APPDOM
/home/psadm2/psft/pt/8.55/appserv/prcs/PRCSDOM
/home/psadm2/psft/pt/8.55/appserv/prcs/PRCSDOM/LOGS
/home/psadm2/psft/pt/8.55/webserv/peoplesoft/applications/peoplesoft/PORTAL.war/ps/cach


I restarted the Image after I removed these files and the Application Server and PIA domain started normally. I use an FTP client to connect to the PUM Image.


Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
I recently installed Unified Navigation in a 8.55 fluid environment. I installed the workcenter from the latest IH PUM Image (Doc ID 1641843.2). Here are some import/export DMS scripts and a App Designer project to help in migrating this to your environment. Big thanks to Simon Chiu for assistance with the Unified Nav functionality.

1) Run your export script (Click here to download) in IH PUM Image 3 to create the DAT file
2) Run the import script (Click here to download) in your IH environment to import the workcenter and activity guide
3) Copy the app designer project (Click here to download) into your IH environment
4) Bounce your app/web server for changes to take effect
5) From the Navigator menu go to Portal Administration->Unified Navigation Workcenter
    -Note: You might have to add the Portal security role to your security if you get an error          
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Dan Iverson has put together a new course on the PeopleSoft DPK. He does a very nice job explaining how to build out a PeopleSoft infrastructure.

PSAdmin.io DPK course
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Update on this. In the newer images PeopleSoft has put the source files under the PS_APP_HOME directory. I've also been using FileZilla FTP client as I found that WinSCP was disconnecting me while downloading large files.

1) Log into the PUM via FTP client using the root user (I use FileZilla)
2) Navigate to the /opt/oracle/psft/pt/ps_app_home/sqr directory

I recently had a need to look at one of the delivered SQR source files in the HR PUM Image. Here is how you get there when the PUM Image is running:

1) Log into the PUM via FTP client using the root user (I use WinSCP)
2) Navigate to the /opt/oracle/psft/ptdb/apptools/sqr directory

Thanks to Sasank Vemana for the assistance on this! You can check out his blog here
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
My use of Change Assistant has increased while doing regular PUM updates in 9.2 environments. I've recently realized how to change the heap size for the Change Assistant and have seen improvement in performance. In my case I set the maximum heap size to 2048. Here's how I did it.

1) Right click on the CA desktop shortcut and choose Properties
2) In the Target text box append -Xmx2048m to the end. It will look like this:


Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
If you use Windows 7 and cannot see the share you might check the following setting on your registry:

  • Open a command prompt window and run regedit.exe
  •   Goto HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\LanmanWorkstation\Parameters
  •   Change the subkey "RequireSecuritySignature" value from 1 to 0.
  •   Reboot the machine



Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
I've been researching SAML integration with PeopleSoft. If you are new to SAML, this is a pretty good high level overview from the guys at Centrify.

https://www.youtube.com/watch?v=S9BpeOmuEz4

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
The last PUM upgrade I did using the new Change Assistant in tools 8.55. I discovered a couple new features that I really like with this version:

1) The ability to have multiple versions of CA installed. The setup program will now prompt if you want to replace or install a new version. This is nice because you will no longer have to have different versions on different machines

2)The ability to export and import configuration settings. Once you have environments setup in one CA instance you can create a zip file and then reimport those later or use with a different version.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
I've recently discovered a very cool community PeopleSoft resource. It's called psadmin.io (http://psadmin.io/).  Dan Iverson and Kyle Benson do a great job of podcasts pertaining to all things PeopleSoft. There is even a quickstart DPKcourse as well as a community forum. I would encourage everyone to check it out.
Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview