Thursday 28 April 2016

Process Scheduler Reports showing status as NOT POSTED

After the refresh of the PeopleSoft database with production backup, process scheduler reports were not posting to the report repository.

DSTAGNT_0428.LOG was showing the error as below.

PSJNI: Java exception thrown: javax.net.ssl.SSLHandshakeException:
java.security.cert.CertificateException: Untrusted Server Certificate Chain

PSDSTSRV.28584 (21) [2016-04-28T14:09:08.659 PostReport](3)     HTTP transfer error.
PSDSTSRV.28584 (21) [2016-04-28T14:09:08.659 PostReport](3)      Post Report Elapsed Time: 0.0200

The issue is caused by the digital certificates for the web server which were not loaded in the PeopleTools Security tables. Digital certificates can be loaded in PeopleSoft from the following navigation PeopleTools Security > Security Objects > Digital Certificates

As a solution to the issue, 

1. Export certificate from the browser padlock icon.
2. save certificate to the file.
3.  Navigate to PeopleTools > Security > Security Objects > Digital Certificates 
4. Click the + sign to add new record where Type = Root CA
5. Give the name for the certificate.It can be any name as per your convinence.
6. Open the saved certificated file in notepad and copy the entire text into the Detail field of the new Root CA. Ensure no carriage return at the end of the file.
7. Stop and restart the process scheduler server.


Solution helped in posting the reports successfully to the report repository.


No comments:

Post a Comment