Jump to content

Spotfire is showing inconsistent Data

Karthik Bhupathy 6

Recommended Posts

Hi (Attached is the query used) We have a report that is scheduled for cache at 07:05 AM everyday. The cache is suppose to load the latest data but it brings some random dates as the most recent record. This is happening bot Client and the web version. This report is using a query with multiple unions and it brings in 5M records and takes upto 45 minutes to load and at times is take over 1.5hours to cache. Question: Why is it not bringing the latest data available in DB all the time. What could have caused this inconsistency. Why is this issue intermittent. Ex: On 02/12/2019 At 8:00 am when loaded in client it pulled 02/04/2019 as the latest data but the DB has 02/11/2019 as latest data. Same day at 9:30 Am i ran the report again in Client and it pulled 02/11/2019 as the latest data as in DB.
Link to comment
Share on other sites


How are these dates passed to the queryIf its happening both in the Analyst and Web Player then it might be something to do with the design of the report.


When you load it in the Analyst check the query that Spotfire fires in the sql.log (if its an information link) and check the Analyst log if its sourced via a connector.


Please log a case with TIBCO support to troubleshoot this issue.

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...