After running delete_old_versions script with the current date, saving of items fails with error "Validation Error: Primary key [xxx] is locked"

Preface:

1. You ran the delete_old_versions.sh script with the current date for the --end_date parameter. The delete_old_versions.sh script has completed.

2. You try to save an existing item.

What you observe:

1. You see an error message "CWPCT0229E: Validation Errors - CWPCM9999E:Error: Error message is :Primary Key [xxx] is locked.", where "xxx" is the primary key of the item you tried to save.


2. In your exception.log you will see the following exception:
   <time_stamp> [jsp_55: /ccd_rendering/renderer.jsp] ERROR com.ibm.ccd.common.error.AustinException - CWPCM0002E:Generic error / Exception: CWPCT0059E:Invalid version information when deleting item attribute version [999999999] in catalog version [xx].,
   Exception:CWPCT0059E:Invalid version information when deleting item attribute version [999999999] in catalog version [xx].
   CWPCT0059E:Invalid version information when deleting item attribute version [999999999] in catalog version [xx].
   at com.ibm.ccd.content.common.Item.delete(Item.java:1722)
   at com.ibm.ccd.content.common.Item.attemptToInsertAll(Item.java:2674)
   at com.ibm.ccd.content.common.Item.processItemSavePartOne(Item.java:2465)
   at com.ibm.ccd.content.common.Item.toDB(Item.java:2089)
   at com.ibm.ccd.content.common.ItemSaveEntryProcessor.saveEntry(ItemSaveEntryProcessor.java:221)
   ...

Solution / workaround:

1. Manually create a new version of any catalog or hierarchy.
   Afterwards you again will be able to successfully save items.
   
   Here are the steps for how to manually create a new version:
   
   1. Open the catalog or hierarchy attributes of the desired catalog or hierarchy you intend to create a new version for.
   2. Fill the field "Add a version with the name:" with a description for the version you intend to create.
   3. Press the + (plus) button next to the field "Add a version with the name:".
2. If you are using IBM InfoSphere MDM Server for PIM version 6.0.0, replace your file $TOP/src/maintenance/delete_old_versions_localized.sh with the one attached at the end of this document.
   Please note: Once IBM InfoSphere MDM Server for PIM version 6.0.0-Fixpack 11 is available, please upgrade your IBM InfoSphere MDM Server for PIM installation to this latest fix pack.

Fix:
This issue will be resolved with

1. IBM InfoSphere MDM Server for PIM version 6.0.0 Fix Pack 11.
2. IBM InfoSphere MDM Server for PIM version 9.0.0 Fix Pack 7.
3. IBM InfoSphere MDM Server for PIM version 9.1.0 Fix Pack 1.

delete_old_versions_localized.sh