Azure Cache for Redis not updating for table with image data type

Alan Bott 1 Reputation point
2022-08-12T14:37:20.787+00:00

Regis in Azure is working for all SQL table updates except for one. The one table not working is the only table with an image column. I tried changing it to a varbinary(max) just to make sure but that fails to cache updates to the image column too.

Is there an issue with Azure Regis for this data type?

When I add a record through the application that seems to work fine. It is saved and retrieved without issue. When I edit that report and change the report via the application it updates the image and other fields in the table correctly. However, when doing the preview function and using Azure Regis it pulls the original report image, not the one currently in the table. It is updated in the SQL table so must not be in cache. I am not getting any errors. If I change the applications config to not use Regis caching and do the print preview, then I see the updated report.

I'm pretty new to Azure and never did anything with Azure Cache for Redis before. I'm trying to troubleshoot code that at least is not completely new to me although I've never looked at the caching before. At this point I am not sure how to troubleshoot this further. Any suggestions?

The application is running up in a datacenter and uses AppFabric there for caching and there are no issues with that. Via the application config if I set it to not use caching it also works fine as far as updates. We are trying to get this same application running in Azure and another team added caching code for Azure Regis. That looks to be working for all tables except for the one with an image data type.

Azure Cache for Redis
Azure Cache for Redis
An Azure service that provides access to a secure, dedicated Redis cache, managed by Microsoft.
251 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.