Change Assistant unable to connect target database

Change Assistant unable to connect target database

While configuring change assistant with target database it is failing to query database and does not show any error message.

PeopleTools 8.60

Resolution 

Make sure you have updated tnsnames.ora with target database details in Oracle 19c client present in db folder of dpk and in oracle client. 

CHECK APPSERVER LOGS. THE SITE BOOTED WITH INTERNAL DEFAULT SETTINGS, BECAUSE OF: bea.jolt.ApplicationException: TPESVCFAIL - application level service failure

After hitting PeopleSoft login page in browser getting following message

CHECK APPSERVER LOGS. THE SITE BOOTED WITH INTERNAL DEFAULT SETTINGS, BECAUSE OF: bea.jolt.ApplicationException: TPESVCFAIL - application level service failure

-->

App Server logs does show following message

PSAPPSRV.7524 (4) [XX GetCertificate] - - - (1) (NET.502): PTWEBSERVER@HOSTNAME is an Invalid User ID, or you typed the wrong password.  User ID and Password are required and case-sensitive.  Make sure you're typing in the correct upper and lower case.  

Based on these issue is with PTWEBSERVER User .

1. User account PTWEBSERVER is locked, and if it is then unlock the PTWEBSERVER account :

UPDATE PSOPRDEFN SET ACCTLOCK=0 WHERE OPRID=’PTWEBSERVER’;

2. User password is not matching with encrypted value.

Navigate to 

$PS_CFG_HOME/webserv/<DOMAIN_NAME>/peoplesoft/applications/peoplesoft /PORTAL.war/WEB-INF/psftdocs/<DOMAIN_NAME>/configuration.properties

Look for parameter WebPassword

If you know existing password then use pscipher utility to check encrypted value of it and see if it matches with above WebPassword value. If not then reset it.

on command prompt type follow to get encrypted value

>pscipher password

Error in document delete process (262,2031)

 Elastic Search Indexing Application Engine process failure Error in document delete process (262,2031)

Search Indexing Process failure with following errors -

Message Log-

Error in document delete process (262,2031)

.log File -

Process XXX ABENDED at Step PTSF_GENFEED.INDXDATA.Step01 (PeopleCode) -- RC = 24 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

.Trc File-

Direct Transfer Parameters: URL= http://HOSTNAME/_bulk Handle Count=50 Process Instance = XXX SBO Name = INDEX NAME Max Error = 100 

Solution ---->

PeopleTools ->Search Framework ->Administration ->Search Options

Update Attachment handlers from default 50 to 20

ApplySession::apply failed: oracle.glcm.opatch.common.api.install.HomeOperationsException: A failure occurred while processing patch

 Weblogic 14.1.1 patch failure with following error -

UtilSession failed: ApplySession failed in system modification phase... 'ApplySession::apply failed: oracle.glcm.opatch.common.api.install.HomeOperationsException: A failure occurred while processing patch: 33791665'

Log file location: X\bea\cfgtoollogs\opatch\opatch20X_09-X-04AM_1.log

OPatch failed with error code = 73

Solution ->

Apply patch with -invPtrLoc

D:\33791665>D:\X\bea\OPatch\opatch apply -invPtrLoc D:\X\bea\inventory

Unable to get PeopleSoft landing page after sign in due to error CPCServletService::DoService -> nPcmReturn=24: Failed to start the Java Virtual Machine.

Unable to get PeopleSoft landing page after sign in due to error CPCServletService::DoService -> nPcmReturn=24: Failed to start the Java Virtual Machine.

If you get following set of errors even after application services bounce then please try this solution.

Error:

PSAPPSRV.29571 (13) [2021-07-08T06:41:20.869 XXX@172.IP (IE 11.0; WIN10) ICScript] OYwwgOA89L98oA 3980798699840058369 XXXX(1) Could not load the JavaVM library jvm
PSAPPSRV.29571 (13) [2021-07-08T06:41:21.161 XXX@172.IP (IE 11.0; WIN10) ICScript] OYwwgOA89L98oA 3980798699840058369 PEOPLE1 (1) CPCServletService::DoService -> nPcmReturn=24: Failed to start the Java Virtual Machine. (2,766) PT_SECURITY.iScript.OnExecute  Name:getSIDHTML  PCPC:199  Statement:6
Called from:PT_FAV.AddToFav.OnExecute  Name:getSIDHTML  Statement:32
Called from:PT_FAV.AddToFav.OnExecute  Name:setHTML  Statement:120
Called from:PT_FAV.AddToFav.OnExecute  Name:AddToFav  Statement:23
Called from:PT_POPUP.Popup.OnExecute  Name:Popup  Statement:15
Called from:PT_BRANDING.IframeHeader.OnExecute  Name:setAddToFavPopupHTML  Statement:101
Called from:PT_BRANDING.IframeHeader.OnExecute  Name:SetAddFav  Statement:98

Solution ->

First check the what JAVA_HOME is set. Make sure JAVA_HOME directory exists.

Check PATH, LIBPATH and Shell profile ( of Linux server) and make sure jdk path is accurate.

Update correct JDK path , exit from your id and login back and rev-verify if environment variables are pointing to correct JAVA_HOME path.

Shutdown App services , configure App Server, clear cache and bring up services.

This should fix the issue.

Integration Gateway Message Unmarshalling: Could not Parse the XML message String. (158,10415)

Integration Gateway Message Unmarshalling: Could not Parse the XML message String. (158,10415) 

You will notice following error while pinging / testing node from Integration Gateway or Node definition. If you see following error in Logs then this solution will work. 

errorLog.html :

com.peoplesoft.pt.common.XmlException: [Parsing error] msg: Fatal Error: at file null line: 2 column: 359 message: An invalid XML character (Unicode: 0xb) was found in the CDATA section. 

Solution: 

Simply remove special characters from password and try again. It will work.

Unable to open opatch lsinventory due to error is not accessible. Please set appropriate JAVA_HOME and run again.

  Error :
    Unable to open opatch lsinventory due to error <JDK> is not accessible.
    Please set appropriate JAVA_HOME and run again.
     
  Solution:
      This error occurs when listing Weblogic Patches.
      This error occurs because of invalid path of JAVA_HOME.
      TO fix this change JAVA_HOME path in hidden file .globalEnv.properties present at $ORACLE_HOME/oui
     
      JAVA_HOME=<Latest JAVA_HOME Path>
   JAVA_HOME_1_8=<Latest JAVA_HOME Path>