Real Time Indexing Errors for Ben Admin Processing Insights With: Returns SQL: Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'SYSDATE'.
(Doc ID 2947304.1)
Last updated on MAY 08, 2023
Applies to:
PeopleSoft Enterprise HCM Benefits Administration - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
After enabling Real Time Indexing for Fluid Benefits Insights, the indexing process errors with the following in the application server log:
The issue can be reproduced at will with the following steps:
- Navigate to PeopleTools > Search Framework > Real Time Indexing > Configure Real Time Indexing.
- Enable Real Time Indexing for Ben Admin Processing Insights.
- Then as a Benefits Administrator select the Manage Benefits Tile > Ben Admin Processing Insights tile
- Select the ODEM link for an existing row.
- The On Demand Event Maintenance page opens to process the event to closed.
- Review the Ben Admin Processing Insights to see there is no change to the event that was processed, it remains showing as requiring processing.
- Review the Application Server log to see the error.
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 |