SAP Knowledge Base Article - Preview

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.


Read more...

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 ONE Support launchpad (Login required).

Search for additional results

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