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.
DB2 LUW (DB6)
Software Update Manager
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 pageThis 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.