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';