E-QR: Wrong Output Is Generated When Running PSQuery Using Email Type

If you have  files in the following folder $PS_CFG_HOME/appserv/prcs/<dbname>/files with extension xls, cxv , pdf and you try to schedule a query using Schedule Query (PSQUERY), and select email option, you may get incorrect file emailed to you.

 

Workaround: Delete the files in $PS_CFG_HOME/appserv/prcs/<dbname>/files folder that has extension xls, csv or pdf.

This is a bug introduced in 8.50.08 and as of 8.50.12 not yet resolved.

See My Oracle Support resolution ID: 1186374.1

PS resolution says this happens when you have PS_FILEDIR is setup in the Process scheduler box, but this was not the case in our environment.

Error getting report repository location. (63,85)

If you are getting this message when running a new Report, and all the configuration settings are correct then the issue is due to incorrect initialization of psreports or SchedulerTransfer servlet. This issue was resolved in 8.48.16 but appeared again in 8.50.10. To fix this simply do the following.

 

From the IE browser, just paste the following URL.

If using NON SSL

http://xyz.com:port/psreports/ps/

if using SSL

https://xyz.com:port/psreports/ps/

Replace xyz.com with the actual Report repository web server name and port with actual port number used. Also if you use non default site, then replace ps with the actual pia site name.

See the Metalink resolution :

E-RD: Reports do not post initially when the Web Server is bounced [Video] [ID 660253.1]  

Other Option is to open a previously successful report that invokes the psreports servlet.

This could be specific to WebLogic version and Patch applied.

WebLogic 10.3.2 32 Bit on Red Hat Linux 5.3 64 bit

JrockIT JRE

java version "1.6.0_17"

Java(TM) SE Runtime Environment (build 1.6.0_17-b04)

BEA JRockit(R) (build R27.6.6-28_o-125824-1.6.0_17-20091214-2104-linux-ia32, compiled mode)

PeopleTools : 8.50.10

All the patches applied using WebLogic Smart Update Utility: bsu

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.