Upgrade from v11.0.CR3 to v11.1.0 fails on PRIMARY KEY error on published_service_property

Products

• CA API Gateway

Issue/Introduction

When DB upgrade, it throws error,

liquibase.exception.MigrationFailedException: Migration failed for change set upgrade_11.1.00.xml::add_pk_published_service_goid_name_in_published_service_property::gateway:

Reason: liquibase.exception.DatabaseException: Duplicate entry '\xEB\xFDf\x81h\xC2\x1F\xBF\xFB\xF3.W\x9B\xB0\xC3\xFA-internal.po' for key 'published_service_property.PRIMARY' [Failed SQL: (1062) ALTER TABLE ssg_testUpgrade.published_service_property ADD PRIMARY KEY (published_service_goid, name)]

No changes have been made to the database. Please correct the problem and try again.

Cause

Duplicated records found in the table,

Resolution

Remove the duplicated Records.