Scenario 1: Failed hotfix installation – Database Saver Insertfail
Installation of a hotfix or a comma-delimited list of hotfix package download (DL) file fails with an error message.
Error
Could not save rollback information for an installed hotfix: Database-Saver-Insertfail
Environment
The issue occurs in the following environments:
- Pega Platform version 7.1.8 on-premises
- Pega Platform version 7.2 on Pega Cloud 2.1
- Pega Platform version 7.2.2 on Pega Cloud 2.1
Explanation
The value of pylastreservedid of pc_data_uniqueid table is not equal to the value of HOTFIXORDER of pr_data_products table.
Solutions
Run the following query:
Select pylastreservedid from pc_data_uniqueid Where pzinskey like ‘%HOTFIXORDER-%’;
The query returns a number, for example, 12.
Run the following query:
Select pxInsName, pyproductid from pr_data_products Order By pxInsName;
The query returns a list of hotfixes installed. For example, the count of hotfixes installed is 14.
pylastreservedid should be equal to the number of hotfixes found in the pr_data_products table.
To correct the value of HOTFIXORDER of pc_data_uniqueid table, run the following query:
Update pc_data_uniqueid set pylastreservedid=14 Where pyprefix=’HOTFIXORDER-’;
Scenario 2: Failed hotfix installation – unique constraint violation
Installation of a hotfix or comma-delimited list of hotfix package download (DL) file fails with an error message.
Error
Could not save rollback information for an installed hotfix: Duplicate key value violates unique constraint “pr_data_products_pk”
Environment
The issue occurs in the following environments:
- Pega Platform version 7.2 on Pega Cloud 2.1
- Pega Platform version 7.2.2 on Pega Cloud 2.1
Explanation
The value of pylastreservedid of pc_data_uniqueid table is not equal to the value of HOTFIXORDER of pr_data_products table.
Solutions
Run the following query:
Select pylastreservedid from pc_data_uniqueid Where pzinskey like ‘%HOTFIXORDER-%’;
The query returns a number, for example, 12.
Run the following query:
Select pxInsName, pyproductid from pr_data_products Order By pxInsName;
The query returns a list of hotfixes installed. For example, the count of hotfixes installed is 14.
pylastreservedid should be equal to the number of hotfixes found in the pr_data_products table.
To correct the value of HOTFIXORDER of pc_data_uniqueid table, run the following query:
Update pc_data_uniqueid set pylastreservedid=14 Where pyprefix=’HOTFIXORDER-’;
Related Content
Product Documentation
Troubleshooting: 500 Internal Server Error when installing a hotfix (Internet Explorer)
Support Documents
Specifying the Hotfix Catalog location for Pega Hotfix Manager