E-SEC: Receive SQL Error Going Into Nodes Page: "SQL error occurred during processing of the PeopleCode ScrollSelect" (Doc ID 1989494.1)

Last updated on OCTOBER 03, 2016

Applies to:

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

Symptoms


After upgrading from Tools 8.52 to 8.54, site gets a SQL error when attempting to open a node definition.
The search page retrieves the list of nodes, and after selecting a node to open, the following error is seen on the page.

Error in PeopleCode ScrollSelect processing. (2,213) PSSERVICESWRK.DETAILS_PB.FieldFormula
Name:fillroutings  PCPC:419  Statement:3
Called from:IB_NODE.GBL.PostBuild  Statement:12
 
A SQL error occurred during processing of the PeopleCode ScrollSelect (or
ScrollSelectNew, RowScrollSelect, RowScrollSelectNew) built-in function.
 
Navigation:
----------
Tools -> Integration Broker - Integration Setup - Nodes

Impact:
--------
The site cannot retrieve any nodes at all

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