January 29, 2021 at 12:50 pm
I had to change a column originally encrypted as Randomized. I used the wizard and changed it to Deterministic. I saw the error below when I tried to update a row in my asp.net application. So, I changed it to plain text. Verified I could see the text in SSMS (took a back up of the records). Then encrypted it again as Deterministic.
Rebuilt my index
What I'm seeing in my asp.net application, is that sometimes I can edit the record. Sometimes it saves the record. Other times it show the error below. But after the error, if I edit again and resave there are no more errors.
This is the error.
Operand type clash: nvarchar(7) encrypted with (encryption_type = 'RANDOMIZED', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'CCCAPX1') is incompatible with nvarchar(max) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'CCCAPX1')
Any ideas of how I can fix this.
January 30, 2021 at 1:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
February 1, 2021 at 3:05 pm
As an update, I'm still seeing this sporadically. The records are being updated via an asp.net web page -- a simple update statement. Its been working fine for years prior to the change in encryption type.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply