PeopleTools 8.50 Known Issues - Master Note [ID 1114793.1]

Oracle has posted a Master Resolution on Metalink (Flash based: http://support.oracle.com) or Non Flash based (http://supporthtml.oracle.com).

Resolution ID: 1114793.1

It has broken the incidents into following categories.

1. Application Development
2. Install/Updates
3. Integration Tools
4. Reporting Tools
5. Server Tools
6. Open Incidents (ALL components)

 

This document will be updated frequently. Please check this document to see if your issue is already listed in it.

List of Batch Processes in queued status

The following sql will generate a list of batch processes in queued status in Process Monitor.

SELECT b.prcsinstance,
       b.prcstype,
       b.prcsname,
       (SELECT e.descr
        FROM   ps_prcsdefn e
        WHERE  e.prcstype = b.prcstype
               AND e.prcsname = b.prcsname) descr,
       b.oprid,
       (SELECT a.oprdefndesc
        FROM   psoprdefn a
        WHERE  a.oprid = b.oprid) NAME,
       runcntlid,
       (SELECT f.qryname
               || ', '
               || f.descr
        FROM   ps_query_run_cntrl f
        WHERE  f.oprid = b.oprid
               AND f.run_cntl_id = b.runcntlid) qryname,
       recurname,
       runstatus,
       (SELECT xlatshortname
        FROM   psxlatitem c
        WHERE  c.fieldname = 'RUNSTATUS'
               AND c.fieldvalue = b.runstatus)  rundescr,
       diststatus,
       (SELECT d.xlatshortname
        FROM   psxlatitem d
        WHERE  d.fieldname = 'DISTSTATUS'
               AND d.fieldvalue = b.diststatus) distdescr,
       pt_retentiondays,
       rundttm,
       rqstdttm,
       lastupddttm,
       servernamerqst
FROM   psprcsrqst b
WHERE  runstatus IN ( 5 )
ORDER  BY rundttm DESC 

Invalid signon time for user PS@xyx.com

when user tries to signon they get the following message on the Login Page.

Invalid signon time for user

 

This message is thrown due to a  blank classid row in PSROLECLASS table. Use the following SQL to determine the Cause.
select * from psroleclass where  classid = ' '

To fix this, run this SQL.
delete from psroleclass where  classid = ' '

No Appserver or Webserver bounce was required.

This was tested in 8.50.10

PeopleTools 8.4x/8.1 ERD Diagram for Security tables

On Metalink Go to Knowledgebase article : 611947.1 : PeopleTools 8.x Security Relationship Diagrams

The above document provides the ERD diagram for peopletools security table.

Run the PeopleTools 8.50 Installation in GUI mode for Linux/Unix servers

In PeopleTools 8.50, PeopleSoft does not document the command line parameter needed to run the installation in GUI mode for Linux/Unix servers. The installation defaults to console mode. To get the same GUI experience, you can use the following command line flag.

-i swing

So of you have downloaded the PeopleTools installation media to PS_INSTALL, you can run the following.

 

PS_INSTALL/Disk1/setup.sh –tempdir $HOME/tmp –i swing

(Note tempdir is a documented command line parameter to use the folder other than /tmp. It requires at least 2GB free space in temp folder).

 

--------------------------------------------------------------------------------------------------

Usage: setup [-f <path_to_installer_properties_file> | -options]
            (to execute the installer)

where options include:
    -?
            show this help text
    -i [swing | console | silent]
            specify the user interface mode for the installer
    -D<name>=<value>
            specify installer properties

--------------------------------------------------------------------------------------------------

 

I will be curious, if there is a way to do silent install by providing all the needed input in a properties file. I do not see this documented any where.

Note: This method applies to other installation type for e.g. Verity Install.

Trying to Schedule Query gives message "An error has occurred" and kicks the user back to an Error page.

I have noticed the following issue on PeopleTools 8.48.16.

1. Go to Reporting Tools -> Query -> Schedule Query -> Add a new Value –> TEST
2. Enter the query name : ERROR_QUERY and tab out of the field.
3. This displays the run time prompt page. Enter the value and hit OK or CANCEL
4. Page shows flashing Processing image and displays the page "An error has occurred" eventually. Appserver log shows that a core file is generated.

 

FIX

To fix the issue, open the query in Query Manager from PIA. Change the query properties –> Description and resave the query. This fixes the issue.

Could not sign on to database xxxx with user yyyy for app engine program

When trying to run appengine program from command line (psae), you are getting this message

“Could not sign on to database xxxx with user yyyy for app engine program”

One possible reason is that psae needs database name in upper case. If you are using lower case name then the above message appears.

Also PS_SERVER_CFG must contain the fully qualified name of a correctly configured Process Scheduler PSPRCS.CFG file

For e.g.

 

PS_SERVER_CFG=$PS_HOME/appserv/prcs/<domainname>/psprcs.cfg;export PS_SERVER_CFG

psae -CT ORACLE -CD dbname-CO userid -CP password -R runcontrolid -I 0 -AI <appengine progname>

Also When PeopleSoft Application Engine runs from the command line, it resolves %PS_SERVDIR% to the value of the environment variable PS_SERVDIR instead of the parent directory of a Process Scheduler configuration.