Upgrade App Engine UPG_AUC Abends at Step UPG_AUC.AUCC10.Step02 (SQL) (Doc ID 1605234.1)

Last updated on JUNE 09, 2017

Applies to:

PeopleSoft Enterprise SCM Strategic Sourcing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Upgrade app engine UPG_AUC abends at step UPG_AUC.AUCC10.Step02 (SQL) with the following error:

Error: 

File: e:\pt85306c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]String or binary data would be truncated.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated. (SQLSTATE 01000) 3621
Failed SQL stmt: UPDATE PS_AUC_BIDDER_HDR SET ADDL_COMP_LBL = AUC_COMPANY_NAME

A new field ADDL_COMP_LBL is only 30 bytes and AUC_COMPANY_NAME is 40 bytes, this is causing SQL server 2008 to abend.

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