My Oracle Support Banner

E-ES: Unable to Deploy Elastic Search PTPORTALREGISTRY Error "An error has occurred" Due to Performance Issue in IB Related SQL "Stmt=SELECT TOP 1 'X' FROM PSFP_FEED WHERE PTFP_FEED_ID = :1 OR EXISTS (SELECT 'X' FROM PSAPMSGSUBCON (Doc ID 2982539.1)

Last updated on FEBRUARY 26, 2024

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.

Symptoms

When attempting to deploy PTPORTALREGISTRY search definition the page keeps loading and after a while user gets logged out of PIA with following error:

An error has occurred.

You may attempt to sign in again. If your attempt fails, please contact your System Administrator.

Steps to Replicate:

 1. Login to PIA, Navigate to PeopleTools->Search Framework ->Administration->Deploy Search Object
 2. Select PTPORTALREGISTRY search definition and click on Deploy.   

Another way to verify the issue is to observe that:
- The Deploy action does not update the ES Cluster log file (<ES_HOME>\logs\<ClusterName>.log.)
- The Deploy action does not update the Integration Broker log file <PS_CFG_HOME>/webserv/<domain>/applications/peoplesoft/PSIGW.war/WEB-INF/msgLog.html, even if ig.log.level=5 in <PS_CFG_HOME>/webserv/peoplesoft/applications/peoplesoft/PSIGW.war/WEB-INF/integrationGateway.properties.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.