Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-359

Column datatype of instance_num column during temporary table in temporal search does not match data type of instance_num in observation_fact

Details

    • Bug
    • Status: New
    • Minor
    • Resolution: Unresolved
    • None
    • TBD
    • None
    • None
    • Windows
    • 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.

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            Unassigned Unassigned
            GeorgFette Georg Fette
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: