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

    XMLWordPrintable

Details

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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated: