This document describes the solution for when the Last Refresh date of a cached resource is off by two days. This document pertains only to cache targets that use Microsoft Structured Query Language (SQL) Server.
In the Studio's cache tab, the "Last load time" displayed has the correct time of the last successful refresh, but the day is behind by two days.
This is a known issue that occurs when you use older versions of the Microsoft SQL Server jdbc.jar driver file in Cisco Information Server (CIS) for your datasource connection to the Microsoft database that acts as the cache target. Unfortunately Microsoft's jdbc.jar files are not clearly labeled with version information, so Cisco recommends to download the latest compatible copy from the Microsoft download site.