PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

SR 3-20338583751 : Elasticsearch: Fatal PeopleCode SQL error occurred message - what is causing this

edited Jun 18, 2019 10:45AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered ✓

We are experiencing an issue with Elasticsearch 6.1.2 on Tools 8.56.15 as shown in the details from the SR I just opened in MOS.  Any thoughts or ideas would be greatly appreciated!

Customer Problem Description
---------------------------------------------------

Problem Summary
---------------------------------------------------
Elasticsearch: Fatal PeopleCode SQL error occurred message - what is causing this?

Problem Description
---------------------------------------------------
We are currently on FSCM 9.2 PUM 21/Tools 8.54.25. Upgrading to Tools 8.56.15

When re-testing Elasticsearch in one of our upgraded COP environments, I received the following error:

SQL error in Exec. (2,280) PTSF_SCHEDULE.PTSF_SBO_NAME.FieldFormula Name:SelecSearchDefinition PCPC:11607 Statement:152
Called from:PTSF_SCHEDULE_SI.Activate Statement:1

During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center