Upgrade to Crucible 2.3.x Loses Patch Diff Data
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
After upgrading to Crucible 2.3.x, viewing the diff of a patch file that's attached to a review will cause the diff to be reported as No Change.
Cause
The upgrade process updates the cru_stored_path table and adds unnecessary new line characters to the cru_path column.
Resolution
To resolve this issue please follow these steps:
Shut down Crucible.
Perform a backup of your database.
Login to the database and run the following SQL:
UPDATE cru_stored_path SET cru_path = replace(cru_path, '\n', '');Start Crucible and ensure your diff data for patch reviews have been restored.
This issue is also being tracked as a bug in CRUC-3710.
Was this helpful?