-
Bug
-
Resolution: Fixed
-
High
-
11.0.1
-
3
-
Severity 3 - Minor
-
No
Issue Summary
It was noticed that there are missing the values 9999-12-31 00:00:00 in the feature fact valid to Column on [current_dw].[Feature History] for a few specific entries
However, many Features do not present this value on their last Feature Fact anymore but a date value instead, example below:
Steps to Reproduce
- On Enterprise Insights use the following query:
-
select max([Feature Fact Valid To]) maxBLIS, [FK Feature ID] from current_dw.[Feature History]
- Note that a few Features will present the behavior mentioned
Expected Results
Expected:
| fk feature id | feature fact id | feature fact valid from | feature fact valid to |
|---|---|---|---|
| 17721 | 137969 | 2024-06-28 18:47:56.827 | 2024-06-28 18:49:08.040 |
| 17721 | 137970 | 2024-06-28 18:49:08.040 | 9999-12-31 00:00:00.000 |
Actual Results
Actual results:
| fk feature id | feature fact id | feature fact valid from | feature fact valid to |
|---|---|---|---|
| 16861 | 133227 | 2024-02-06 20:05:58.090 | 2024-02-06 20:07:24.570 |
| 16861 | 133230 | 2024-02-06 20:07:24.570 | 2024-02-06 20:07:51.933 |
Workaround
Currently there is no known workaround for this behavior. A workaround will be added here when available
- has a regression in
-
-
- Closed
-
- is connected to
-
JARDA-5131 Loading...
- is related to
-
- links to
- mentioned in
-
-
-
-
-
-
-
-
-
-
-
- resolves
-
-
-
-
-