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.
Just a quick note: I added a few tables to the PeopleTools Tables list:
SQL Definitions
I also updated the Application Engine section with some links to related posts.
Here are the values for the AE_STMT_TYPE field. This is useful if you are looking for an Application Engine with a certain type of action.
AE_STMT_TYPE:
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:
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'
This is a continuation of my virtual PeopleSoft installation. In this step, we will discuss how to install the PeopleTools home filesystem. To see the complete list of steps, click here.
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
Before you can use any object you must instantiate it first. This means that you must create the memory for object. See the Wikipedia for more information.
The instantiation applies to both regular PeopleTools objects and custom Application Packages. Here is an exploration or documentation of how you would do it.
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.
This is a continuation of my virtual PeopleSoft installation. In this step, we will discuss how to install the Oracle database. To see the complete list of steps, click here.