PTSF_GENFEED is failing on LoadPos' 'Step02' 9700 rows inserted into HR_CD_POS_TMP

(Doc ID 2413340.1)

Last updated on JUNE 20, 2018

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

PTSF_GENFEED is failing when running Company directory search definition for full index on Elasticsearch running PeopleTools 8.55.16.

The rest of the search definitions are processing with no issue.

When running PTSF_GENFEED for a full index for the company directory search definition, the "LoadPos' 'Step02' 9700 rows inserted into HR_CD_POS_TMP" and "'LoadJob' 'Step02' 9172 rows inserted into HR_CD_JOB_TMP" would complete in a few minutes, then the instance would spin.

The instance was run on the PSUNX process scheduler server and the process monitor would still show it as processing, but the scheduler log file said that it was no longer processing or initiating.

It showed the process id number (pid) and when we killed the pid, the process would show as errored on process monitor and the rest of the processes would run as shown in message log. When in processing status on the process monitor, it was blocking all other processes from running on psunx so it would send them to psnt and they would run to error.

All other deployed search definitions ran successfully when they were run for full indexes. The search definition HC_HR_COMPANY_DIRECTORY1 has been running successfully on SES server.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms