Category: Uncategorized

PSPNLFIELD.FIELDTYPE

digitaleagle PeopleTools, PeopleTools Reference, Uncategorized 4 Comments

Update: These are the list of fields types in the PSPNLFIELD table.

This is a list of the Panel Field types:

  • 0:  Text
  • 1:  Frame
  • 2:  Group Box
  • 3:  Static Image
  • 4:  Edit Box
  • 5:  Drop Down List
  • 6:  Long Edit Box
  • 7:  Check Box
  • 8:  Radio Button
  • 9:  Image
  • 10:  Scroll Bar
  • 11:  Subpage
  • 12:  Push Btn/Link — PeopleCode (Thanks Robert)
  • 13:  Push Btn/Link — Scroll Action
  • 14:  Push Btn/Link — Toolbar Action
  • 15:  Push Btn/Link — External Link
  • 16:  Push Btn/Link — Internal Link
  • 17:  Push Btn/Link — Process
  • 18:  SecPage
  • 19:  Grid
  • 20:  Tree
  • 21:  Push Btn/Link — Secondary Page
  • 22:  ?? not in an HR database
  • 23:  Horizntl Rule
  • 24:  Tab Separator
  • 25:  HTML Area
  • 26:  Push Btn/Link — Prompt Action
  • 27:  Scroll Area
  • 28:  ?? not in an HR database
  • 29:  Push Btn/Link — Page Anchor
  • 30:  Chart
  • 31:  Push Btn/Link — IM Action
  • 32:  Analytic Grid

SQR Shortcut

digitaleagle SQR, Uncategorized 2 Comments

Every server should have this shortcut on its desktop:

C:\<path>\sqrw.exe  ? <db user name>/<db password>@<db name> -zifC:\<PS Home>\sqr\pssqr.ini -ic:\<PS Home>\sqr -oc:\temp\sqr.log -fc:\temp\ -printer:pd

This shortcut allows a system administrator to double click on a shortcut, enter an SQR program name, and run the program.  The output goes to the c:\temp directory — both the report and the log.

Good Habits for Consultants

digitaleagle Great Links, Uncategorized Leave a comment

I found this great link the other day about good habits for consultants.  Doing some Googling, I was able to build a quick list of posts about habits for consultants:

Here is another good tid-bit for consultants: 7 greatest challenges

In the past, I found some good jokes about consultants, but the links were broken.  Here are some more:

Log Messages in Application Engine

digitaleagle App Engine, Uncategorized 2 Comments

Here is some SQL that lists the Log Message actions in Application Programs:

SELECT A.AE_APPLID, A.AE_SECTION, A.AE_STEP,
M.AE_MESSAGE_PARMS, S.MESSAGE_SET_NBR, S.MESSAGE_NBR FROM
PSAESTMTDEFN A, PSAESTEPMSGDEFN M, PSAESTEPDEFN S
WHERE A.AE_APPLID = M.AE_APPLID
AND A.AE_APPLID = S.AE_APPLID
AND A.AE_SECTION = M.AE_SECTION
AND A.AE_SECTION = S.AE_SECTION
AND A.MARKET = M.MARKET
AND A.MARKET = S.MARKET
AND A.DBTYPE = M.DBTYPE
AND A.DBTYPE = S.DBTYPE
AND A.EFFDT = M.EFFDT
AND A.EFFDT = S.EFFDT
AND A.AE_STEP = M.AE_STEP
AND A.AE_STEP = S.AE_STEP
AND A.AE_STMT_TYPE = 'M'

libclntsh error

digitaleagle Server Administration, Uncategorized Leave a comment

I had an error with data mover:

[pshr@localhost ~]$ psdmtx -CT ORACLE -CD HRDMO -CO SYSADM -CP SYSADM -CI PEOPLE -CW PEOP1E -FP ~/test.dms
PeopleTools 8.49 - Data Mover
Copyright (c) 2008 PeopleSoft, Inc.
All Rights Reserved

dlopen in libpscompat failed for ‘libpsora.so’: libclntsh.so.9.0: cannot open shared object file: No such file or directory
PSDMTX Error: signon
Reason: Could not sign on to database HRDMO with user SYSADM.

The fix was to create a symbolic link:

[pshr@localhost ~]$ cd /home/pshr/app/pshr/product/11.1.0/db_1/lib
[pshr@localhost lib]$ ln -s libclntsh.so libclntsh.so.9.0

Resources

Unable to boot the apserver… Need to install 32 bit library for window to fix the Missing or invalid version of SQL library libpsora

Yum with Oracle DVD

digitaleagle Server Administration, Uncategorized Leave a comment

I found a great link showing how to use the Oracle Linux DVD as a repository for yum.  Although the post mentions using the DVD, you could probably setup 6 repositories with the 6 CDs to make it would for the CDs too.

Having Yum is very powerful because it figures out the prerequisites for installing software.  That is one thing I definitely miss as I am working with Unbreakable Linux.  I think next time I might try Ubuntu or Fedora just for experimenting around because the repositories are already setup and software installation is easier.