We are currently on 24.2.0; as part of a planned upgrade to 25.1.0, we are attempting to upgrade our environment to 24.2.3 - the notes for 25.1.0 said we have to be on 23.1.4, 23.1.5, 24.1.3, 24.1.4, 24.2.2, or 24.2.3 before removing Hazelcast.

When the upgrade is executed, we are encountering an error: 

INFO AntScriptWrapper - [java] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'PegaRULES2423.pr4_base' with unique index 'IX_pr4_base_pyClassType'. The duplicate key value is (<NULL>, <NULL>, <NULL>).

We then remove the duplicate rows: 

SELECT * from [PegaRULES2420].[pr4_base]

WHERE pyClassType IS NULL

AND pyClassName IS NULL

AND pyRuleSet IS NULL

When we reattempt, we encounter the below error: 

INFO AntScriptWrapper - [java] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'PegaRULES2423.pr4_base' with unique index 'IX_pr4_base_pyClassType'. The duplicate key value is (DMOrg-DMSample-Work, <NULL>, <NULL>).

Looking for guidance as to address this issue.  We encountered the same issue when we subsequently tried to go to 24.2.2. In the event it matters, we also upgraded the Azure SQL DB Compatibility version as part of this upgrade process, from 150 to 160.

Edit to add: We reverted back to Azure SQL DB Compatibility version 150, and attempted to upgrade to 24.2.3 again. We are now getting a different error message:

pega-installer INFO AntScriptWrapper - [java[] Wed Oct 22 17:24:30 GMT 2025 (INFO): Thread-48 throws exception: com.pega.pegarules.util.deploy.bulkmover.exception.PegaMigrationRuntimeException: Failure while trying to execute: INSERT INTO PegaRULES2423.PR4_BASE ("pxCommitDateTime", "pxSaveDateTime", "pxCreateDateTime", "pxCreateOpName", "pxCreateOperator", "pxCreateSystemID", "pxHostId", "pxInsId", "pxInsName", "pxObjClass", "pxUpdateDateTime", "pxUpdateOpName", "pxUpdateOperator", "pxUpdateSystemID", "pyApplet", "pyAppletHarness", "pyBaseRule", "pyCategory", "pyCircumstanceDateProp", "pyCircumstanceDate", "pyCircumstanceProp", "pyCircumstanceType", "pyCircumstanceVal", "pyClassGroup", "pyClassGroupIndicator", "pyClassInheritance", "pyClassName", "pyClassType", "pyDatabaseName", "pyDerivesFrom", "pyFormType", "pyInitialVersion", "pyLabel", "pyMethodStatus", "pyPatternInheritance", "pyReportDatabaseName", "pyRuleAvailable", "pyRuleEnds", "pyRuleName", "pyRuleResolution", "pyRuleSet", "pyRuleSetName", "pyRuleSetVersion", "pzRuleSetVersionMajor", "pzRuleSetVersionMinor", "pzRuleSetVersionPatch", "pyRuleStarts", "pySortDateCircumWithinRSMajor", "pyTableName", "pzInsKey", "pzPVStream", "pzChecksum", "pzModelTableName", "pyIsCoreClass") SELECT "pxCommitDateTime", "pxSaveDateTime", "pxCreateDateTime", "pxCreateOpName", "pxCreateOperator", "pxCreateSystemID", "pxHostId", "pxInsId", "pxInsName", "pxObjClass", "pxUpdateDateTime", "pxUpdateOpName", "pxUpdateOperator", "pxUpdateSystemID", "pyApplet", "pyAppletHarness", "pyBaseRule", "pyCategory", "pyCircumstanceDateProp", "pyCircumstanceDate", "pyCircumstanceProp", "pyCircumstanceType", "pyCircumstanceVal", "pyClassGroup", "pyClassGroupIndicator", "pyClassInheritance", "pyClassName", "pyClassType", "pyDatabaseName", "pyDerivesFrom", "pyFormType", "pyInitialVersion", "pyLabel", "pyMethodStatus", "pyPatternInheritance", "pyReportDatabaseName", "pyRuleAvailable", "pyRuleEnds", "pyRuleName", "pyRuleResolution", "pyRuleSet", "pyRuleSetName", "pyRuleSetVersion", "pzRuleSetVersionMajor", "pzRuleSetVersionMinor", "pzRuleSetVersionPatch", "pyRuleStarts", "pySortDateCircumWithinRSMajor", "pyTableName", "pzInsKey", "pzPVStream", "pzChecksum", "pzModelTableName", "pyIsCoreClass" FROM PegaRULES2420.PR4_BASE