Saturday, 29 March 2014

RUNNING SQR on Linux/Unix OS installed on Cloud

During my recent PeopleSoft Installation on Cloud, I have experienced lot of latency issues while communicating to the database hosted on AWS from my local machine.

For Example dddaudit.sqr ran for almost 2 hours and it completed just 10 percent.

Sp it is best advisable to run all the application engines,SQR reports from the console by taking putty or SSH session of the database server..

below is the command for running the SQR:--

[/pshome] sqr $PS_HOME/sqr/setspace.sqr sysadm/XXXXXX@TESTDB -o$PS_HOME/setspace.out -i$PS_HOME/sqr/ -ZIF$PS_HOME/sqr/pssqr.unx "-f$PS_HOME/setspace.pdf" -printer:pd ORACLEDB 689 PS 

-o--> the output of the SQR file
-i--> the input directory where SQR is kept.
-ZIF--> the sqr initialization parameter file
-f--> ther eport output in the pdf format


Wednesday, 26 March 2014

BYPASS SIGNON implementation in PeopleSoft

This requirement generally arises normally  in HCM when Candidate gateway is being implemented.

The purpose of this configuration is to directly land any user over the internet to peoplesoft system, for example applying for a job posting page.

Below are the steps for bypass signon implementation:--

>> the first step is to create a new site with a different http port.

>> Go to configuration.properties of that web server domain and make the following changes:--

byPassSignOn = True

defaultUserId = <UserId>


defautltPWD = <UserPwd>

>> Login into the application and make the public access enabled for the user mentioned in the  configuration.properties.

>> Bounce the web server domains.

>> Now you use the port mentioned in the new site in the URL and you will not be asked for authentication.

Integration Broker--Domain status not purging completely

ISSUE:--Domain status not purging completely, the dispatcher handlers were not getting active even though the PUB/SUB services were up and when trying to update the domain status "Page inconsistent error was coming up"


Solution:--
>>do the ctrl+j and drill down to the page of the domain status page

>>then check the following tables PSAPMSGDOMSTAT,PSAPMSGDSPSTAT and PSAPMSGQUESTAT
the following are the core tables form where the entries of that page is coming up

>>create the script for taking the backup of these tables from datamover using PeopleSoft ID

>> Go to app designer build the following tables and also create the indexes for these tables

>> run the appmessagepurgeall.dms

>> bring down the app server and web server domain and clear the cache

>> bring up the domains with PUB/SUB services , and check the domain status page and refresh .