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 |