Details
-
Bug
-
Status: New
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
None
-
Windows
-
Rank:0|i0041j:
-
Queries
-
SQL Server
-
Firefox
Description
In our ETL process some INSTANCE_NUM values are very large. As the data type of the INSTANCE_NUM column in the observation_fact table is bigint this isn't a problem. However, during the temporal search there are temporary tables created that could have a smaller value range. During the execution of the search I get an error while converting something to INT. When weset all INSTANCE_NUMs of the facts which are involved in the search to 0 the temporal query works. Therefore I think that the INSTANCE_NUM of the temporal table has the data type INT. As the temporal tables do not appear in any logs I cannot verify if my assumption is correct but the clues during my debugging have lead me to the current isssue.