My Oracle Support Banner

HCM 9.2: Microsoft SQL Server - Unable to Crawl Recruiting Search Indexes HC_HRS_RCMNT_ALL and HC_HRS_RECRUITER_RCMNT_ALL: "(SQLSTATE 22007) 241 (2,298) HRS _INDEX_CONTROL.RecruitmentIndex.Incremental.OnExecute" (Doc ID 2946953.1)

Last updated on JANUARY 26, 2024

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to crawl the Search Indexes HC_HRS_RCMNT_ALL and HC_HRS_RECRUITER_RCMNT_ALL in a Microsoft SQL Server Database, the following error occurs in the Application Engine Server Log:

Steps to replicate the issue:
1. Navigate to PeopleTools >  Search Framework > Administration > Deploy Search Objects: Deploy both Search Definitions : HC_HRS_RCMNT_ALL and HC_HRS_RECRUITER_RCMNT_ALL 
2. Navigate to PeopleTools > Search Framework > Administration > Schedule Search : Crawl the 2 Indexes HC_HRS_RCMNT_ALL and HC_HRS_RECRUITER_RCMNT_ALL 
Notice: The Application Engine Program PTSF_GENFEED runs to No success with the above Error in the Message Log

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.