Crucible review doesn't show the diff but a link to download the file is available
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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
Problem
In a review, can not view the text contents or the diff is not available. Crucible requests the reviewer to download the source code instead.
Cause
SVN treats the file as binary if there are any non-UTF-8 characters. For more details please see how Svn identifies the binary file.
If SVN identifies the file as binary then it will set mime type as application/octet-stream, by setting a property svn:mime-type which causes Fisheye not show the diff.
For example:
PT$ svn proplist -vv testfile.sql Properties on 'testfile.sql': svn:mime-type application/octet-stream
To identify the binary content
PT$ grep -axv '.*' testfile.sql ??/**************************************************************************************************************** PT$
Resolution
svn:mime-type is a versioned property, so if the file is already committed then that should be removed and committed again as a new version. If you are adding a new file either remove these characters or remove the property svn:mime-type after adding the file.
A versioned property from svn can be delete as below.
PT$ svn propdel svn:mime-type testfile.sql
property 'svn:mime-type' deleted from 'testfile.sql '.
PT$ svn commit -m "deleting the prop" testfile.sql
Adding testfile.sql
Transmitting file data .done
Committing transaction...
Committed revision 10.