E-RTI: Real Time Indexing (RTI) Not Working RTI With Microsoft SQL Server "'GREATEST’ Is Not a Recognized Built-In Function Name" and "Incorrect Syntax Near ’A'"
(Doc ID 3013417.1)
Last updated on APRIL 04, 2024
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.60 and laterInformation in this document applies to any platform.
Symptoms
After implementing Real Time Indexing (RTI) for the delivered Search Definitions, RTI wasn't working and the following error messages were written to the APPSRV_MMDD.LOG log file (<PS_CFG_HOME>/appserv/prcs/<DOMAIN>/LOGS) of the Application Server that the Process Scheduler was connected to:
Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'GREATEST' is not a recognized built-in function name
Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'A'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180
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 |
Cause |
Solution |
References |