E-SES/RD: SES Search Definition PTSEARCHREPORTS Fails To Crawl On MS SQL Environments
(Doc ID 1999458.1)
Last updated on DECEMBER 06, 2019
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.54 and laterInformation 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
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 |