My Oracle Support Banner

E-ES: Real Time Index Is Not Working for MSS Indexes When Environment Uses DB2 13.1 or Microsoft SQL Server 2022 Databases. Error Message: "psrtisrv.hSQL error. Stmt #: 447 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Se (Doc ID 2980769.1)

Last updated on NOVEMBER 30, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.60 and later
Information in this document applies to any platform.

Symptoms

Real Time Indexing (RTI) isn't working for MSS indexes when the environment uses a DB2 13.1 or Microsoft SQL Server 2022 database (initially reported that RTI wasn't working for the EP_PO_PURCHASE_ORDERS index).  Although RTI is configured correctly and enabled it isn't working and writes error entries in the Application server log file (APPSRV_<mmdd>.LOG).

In the log file APPSRV_MMDD.LOG for PSRTISRV (<PS_CFG_HOME>/appserv/prcs/<DOMAIN>/LOGS/APPSRV_mmdd.log), the error registered is:

 

 



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.