Andrew Fontenot Posted June 2, 2020 Share Posted June 2, 2020 I have successfully setup two (MS SQL) condition queries in the SQL Connector V2 JSON file. When I add these conditions to a trend, the last capsule shows "In Progress" in the Capsules table although the SQL does return an end date for this capsule. The capsule at the top of the trend does end at the correct time, but it is hollow as if the capsule is in progress. Any help on this would be appreciated, Andrew Link to comment Share on other sites More sharing options...
Seeq Team Corinne Posted June 2, 2020 Seeq Team Share Posted June 2, 2020 This behavior is expected. Seeq caches data to improve performance. If data in a region might change, that data is deemed uncertain. Uncertain regions are not cached so that changes to that data aren't missed. The cursor marks the boundary between certain and uncertain data. A hollow capsule means that the capsule is in an uncertain region. The cursor is just before the start time of the most recent capsule and therefore the last capsule is always uncertain. Conditions can have overlapping capsules. Events (capsules) may not be published to the datasource until they are finished. Event A might start at time 1 and end at time 6. Event B might start at time 5 and end at time 10. Event B is published later than Event A. Therefore, the region of Event A remains uncertain (uncached) so that Event B isn't missed. Link to comment Share on other sites More sharing options...
Andrew Fontenot Posted June 3, 2020 Author Share Posted June 3, 2020 I understand the uncertainty aspect, but showing a capsule which does have an end time as "In Progress" is not correct. Thank you for the information. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now