2738127 - SQL0542N error during Upgrade in phase MAIN_NEWBAS/PARCONV_UPG

Symptom

You're upgrading using SUM and encounter the following error on table "/FRE/FRPOO_BUF", MAIN_NEWBAS/PARCONV_UPG phase.

2WETP000 06:16:44: Retcode 1: error in DDL statement for "/FRE/FRPOO_BUF " - repeat
2EETP345 06:16:56: Retcode 1: SQL-error "-542-SQL0542N The column named "LOCFR" cannot be a column
2EETP345 of a primary key or unique key constraint because it can contain null values. SQLSTATE=4
2EETP345 2831" in DDL statement for "/FRE/FRPOO_BUF

The same error is typically seen with the CRMD_PML_ELE table for the MAIL_GUID column. The same resolution steps outlined below apply.

Environment

SAP Netweaver
DB2 LUW (DB6)
Software Update Manager

Product

SAP NetWeaver all versions ; SAP Supply Chain Management 7.0

Keywords

SUM Upgrade Netweaver SQL0542N -542 Unique Primary Key NULL MAIL_GUID CRMD_PML_ELE , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-UPG , Upgrade SAP System , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.