E-RTI: / E-ES: Real Time Indexing (RTI) Not Working For Environments on MS SQL Server Due To Oracle Specific Syntax - Errors Such As "Invalid column name 'SYSDATE'" or "'TO_CHAR' is not a recognized built-in function name" Are Observed in Logs (Doc ID 2969645.1)

Last updated on AUGUST 22, 2023

Applies to:

Symptoms

Real Time Indexing (RTI) is not working for environments on MS SQL Server due to Oracle specific syntax.

Errors are observed in the APPSRV_MMDD.LOG log file of the Process Scheduler (<PS_CFG_HOME>/appserv/prcs/<DOMAIN>/LOGS), such as:

In the log file, those are reported as in the examples below:

File: E:\PT859P13B_2209272133-retail\peopletools\src\psrtisrv\psrtisrv.hSQL error. Stmt #: 11871  Error Position: 0  Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'TO_CHAR' is not a recognized built-in function name.

File: E:\PT859P13B_2209272133-retail\peopletools\src\psrtisrv\psrtisrv.hSQL error. Stmt #: 11871  Error Position: 0  Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'SYSDATE'.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.