My Oracle Support Banner

E-UPG: When Doing a PeopleTools Upgrade, the Step “Generating the Updated PeopleTools Script” Failed with “Error: Alter Failed – More Than One LONG Found in PTSF_ES_DT_ERR and Only One per Table Is Allowed on This Platform. PPT (76,62)” (Doc ID 2596383.1)

Last updated on OCTOBER 10, 2019

Applies to:

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


When doing a Peopletools only upgrade for a PeopleTools system database from PT8.53.11 to 8.56.10, the step "Generating the Updated PeopleTools Script" failed with the following error:

Error: Alter failed - More than one LONG found in PTSF_ES_DT_ERR and only one per table is allowed on this platform. PPT (76,62)

The issue can be reproduced at will with the following steps:
1. Setup the environment to perform a Peopletools upgrade from 8.53.11 to 8.56.10
2. Run the step "Generating the Updated Peopletools Script" in Change Assistant




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

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