Symptoms:
In 5.6.1, is is possible to crop PSD files, but only those uploaded after the upgrade.
Pre-upgraded PSDs cannot be cropped because "The crop button is not shown because the asset has no width and height. These dimensions were not added to the asset table before 5.6.1."
[RNDS-1540] Make it Possible to crop Old PSD assets in 5.6.1 - Jira (atlassian.net)
Download The One-Off application
Unzip on DC server
Run as Administrator
Select DC site that should be updated
Click Process
the application will handle both UNC and Azure stored assets, but the user that runs the application needs read access to the unc storage area (normally true)
SQL used to identify assets that should be processed
select
a.assetid,
a.asset_type,
al.destinationid,
al.location
from
dbo.asset a
inner join
dbo.asset_location al on a.assetid = al.assetid
where
al.location_state = 111001
and a.deleted=0
and a.asset_type in (4,15,16)
and (
a.OrigMimeType in ('image/psd','image/photoshop')
or al.location like '%.psd'
)
and (
nullif(a.image_height,0) is null
or nullif(a.image_width,0) is null
)
order by a.assetid