Resource Web Password decryption Error v2012
Symptoms
When attempting to save a resource after changing their web password, the following is being generated:
Error/warning messages
"Decryption failed. Ensure both key data and casing is correct"
Reason
The error is a result of the resource’s web password not having a unique key. Somehow encoded password strings have been duplicated and copied over many resources.
Resolution
For the impacted users:
1) Update their webpassword to an empty string in the resources table, using the example below.
2) Then enter a new password using the user profile page (web password field)
3) Click Save.
The password will be saved without an error being generated.
Use the following script as an example:
select* from resources where name like '%resource name%'
update resources set WebPassword ='' where ResourceId ='resourceid'