Solved

Gap in system-versioned data

  • 19 December 2022
  • 2 replies
  • 75 views

Userlevel 4
Badge +13

Something seems to have gone wrong in a temporal table. There’s a gap between the current record and the previous record that’s now in the history table. This gap looks like this:

Query:

select *, tsf_valid_from, tsf_valid_to
from adres for system_time all
where adres_id = 51714

It’s as if the history data is no longer complete but we never manually deleted this data. This is a problem because we use this data for historical records such as invoices.

What could cause such a gap in temporal data?

icon

Best answer by Anne Buit 20 December 2022, 13:03

View original

This topic has been closed for comments

2 replies

Userlevel 7
Badge +5

Hi Roland, looks to me like the record was deleted for a while and then recreated.

Userlevel 4
Badge +13

Hi Anne. Yes indeed. A procedure wrongly created a long list of records in this table that we deleted after we discovered the error. It turns out that this particular address id is now used again correctly and with entirely different data. Until now I just never realized that this would indeed create a gap in the history of that particular record. We keep learning. 😎