Spotfire is showing inconsistent Data

[Karthik Bhupathy 6]

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.

[Sayali Patil]

Hello,

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.