My Oracle Support Banner

The UPG_SPL Process Fails at Step UPG_SPL.SPLA01.SPLA with Error "Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). (SQLSTATE 37000) 217" when Upgrading to Release 9.2 (Doc ID 2064456.1)

Last updated on NOVEMBER 23, 2019

Applies to:

PeopleSoft Enterprise SCM Supply Planning - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When upgrading to release 9.2, the Data Conversion Upgrade process UPG_SPL fails at Step UPG_SPL.SPLA01.SPLA005 with the following error:

Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). (SQLSTATE 37000) 217. Failed SQL stmt: UPDATE PS_PL_PROBINST SET PL_SOLVER_INT1 = 3 WHERE PL_SOLVER_INT1 = 0"


The error most notably occurs for customers NOT using Supply Planning.

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.