E-SEC: Receive SQL Error Going Into Nodes Page: "SQL error occurred during processing of the PeopleCode ScrollSelect"
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.
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.
Tools -> Integration Broker - Integration Setup - Nodes
The site cannot retrieve any nodes at all
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