E-SES/RD: SES Search Definition PTSEARCHREPORTS Fails To Crawl On MS SQL Environments

(Doc ID 1999458.1)

Last updated on JANUARY 09, 2018

Applies to:

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

Symptoms

When running a full index build for PTSEARCHREPORTS, the PTSF_GENFEED process is failing with the following SQL Syntax error:

Error
-------
File: e:\pt854-903-r1-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Positi on: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'A '. [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180 Failed SQL stmt: DELETE FROM PS_PTRS_DELETE_TBL A WHERE NOT EXISTS ( SELECT 'X' FROM PSRF_RINFO_TBL B WHERE B.PRCSINSTANCE = A.PRCSINSTANCE)


Replication steps
-------------------------
PeopleTools> Search Framework> Administration> Schedule Search Index> Run full index for PTSEARCHREPORTS 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms