Delete the PUM Bug from target database

 

Sample command : 

 

 delete from PS_PTIASPLOGTGT where PTIASPRPTNO='26642047' and DBNAME='FSDMO';

Command to test sample email & printer settings OS Level

 

 

Command to check email command :

 

sudo chattr -i /etc/hosts

 

TEST Email from servers :

 

echo "This is test"| mailx -S smtp=smtpgw1.xxx.com -v -s "TEST" abcd@rtgc.com

 

=====================================================================================

 

 

 

To Check the printer configured on server :

 

[psoft@vxxxxxx1 pscfg]$ lpstat -p

 

printer datadistck1 is idle.  enabled since Wed 20 Nov 2019 04:13:26 PM PST

 

working printers in HRTST, datadistck1 & movemain1

How to increase the mail attachment size at OS level

 

Increase the  message_size_limit at OS level.

 

 

root@vxxxxx postfix]# postconf | grep message_size_limit

 

message_size_limit = 20480000

 

[root@vxxxx postfix]# postconf -e message_size_limit=52428800

[root@vxxxx postfix]# postconf | grep message_size_limit

message_size_limit = 5242880

Commands to test load balance connectivity

 Commands  to test load balance connectivity :

openssl s_client -connect finesupgd.abc.com:443 -tls1_2

Test-NetConnection finp.abc.com -Port 443

Invoke-WebRequest https://fin.abc.com/

DPK Installation failed with this error "Weblogic install failed "OraWL12213Home -executeSysPrereqs false -silent true -noconsole '

 

 Solution 1:

Follow the oracle doc

E-DPK: PeopleTools 8.55- 8.57+ DPK Install - Weblogic install failed "OraWL12213Home -executeSysPrereqs false -silent true -noconsole ' returned 4294967295" (Doc ID 2573791.1)

 Or In case in details logs if you found any error leading to below . Make sure

 

>>> Could not execute /tmp/OraInstall2021-06-04_01-22-31AM/install978559936385842063.sh 

Solution 2:

Unset "noexec" on the /tmp folder:

To perform this action consult your System Admin.

Example command to temporarily disable the noexec flag:

$ mount -o remount,exec /tmp

The file /etc/fstab should be updated, if relevant, to permanently remove the noexec flag.

SQLExec with a LONG Field Caused an Application Server Crash after PT8.58 Upgrade

 SQLExec with a LONG Field Caused an Application Server Crash

 

 Solution : Doc ID 2720046.1

LONG fields have been deprecated in PT8.58 and should no longer be used.  If you need to use a LONG field, you will need to set the following parameter in the app server config file:
[Database Options]
OracleUseLobLocators=0

As a workaround the LONG field can be converted to CLOB.

 

 To update IB node property

 

UPDATE SYSADM.PSNODECONPROP SET PROPVALUE='http://abcd..com/abcd.PeopleSoft.Messaging.REST/psapi/Message' WHERE MSGNODENAME = 'PS_CUST' AND PROPID = 'PRIMARYURL';