Jump to content

STALE data issue

Igor Cherkashyn 3

Recommended Posts

  • 4 weeks later...

This sounds like you're caching to Teradata. In this situation it's critical to ensure uninterrupted connectivity to your cache target during a refresh. A failed refresh will result in the cache getting into a STALE state as there's old data.

Here are a few simple options to consider:


Consider configuring a connection validation query on your cache data source to allow TDV to confirm that the connection in the pool is still valid prior to attempting the cache refresh

Look into setting up a notification event when a cache refesh operation fails to allow your team to cache the stale data faster. Options include SNMP trap notifications, custom even driven notifications of the alerts available in the Center of Excellence (CoE) assets available from Tibco PSG

If you don't want users to see stale data ever, you can change the Cache Clears property to clear the cache when a refresh fails. This will take the cache down when a refresh fails.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...