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

1.6 RC2 MSSQL Script for DemoData has error

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.6.00-RC2
    • 1.6.00
    • Data
    • None
    • Windows Server 2003 / MSSQL 2008 Express

    Description

      Here is the description from the ANT build script:

            [sql] Failed to execute: /* add an index on most of the observation_fact fields */ CREATE INDEX OF_IDX_ALLObservation_Fact ON Observation_Fact ( Encounter_Num , Patient_Num , Concept_Cd , Start_Date , Provider_Id , Modifier_Cd , inst
      ance_num, ValType_Cd , TVal_Char , NVal_Num , ValueFlag_Cd , Quantity_Num , Units_Cd , End_Date , Location_Cd , Confidence_Num , Sourcesystem_Cd ) [sql] com.microsoft.sqlserver.jdbc.SQLServerException: The index 'OF_IDX_A
      LLObservation_Fact' on table 'Observation_Fact' has 17 column names in index key list. The maximum limit for index or statistics key column list is 16.

      Attachments

        Activity

          Here is the part of the script which expands the index size from the previous 16 to 17

          CREATE INDEX OF_IDX_ALLObservation_Fact ON Observation_Fact
          (
          Encounter_Num ,
          Patient_Num ,
          Concept_Cd ,
          Start_Date ,
          Provider_Id ,
          Modifier_Cd ,
          instance_num,
          ValType_Cd ,
          TVal_Char ,
          NVal_Num ,
          ValueFlag_Cd ,
          Quantity_Num ,
          Units_Cd ,
          End_Date ,
          Location_Cd ,
          Confidence_Num ,
          Sourcesystem_Cd
          )
          ;
          dansullivan Daniel Sullivan added a comment - Here is the part of the script which expands the index size from the previous 16 to 17 CREATE INDEX OF_IDX_ALLObservation_Fact ON Observation_Fact ( Encounter_Num , Patient_Num , Concept_Cd , Start_Date , Provider_Id , Modifier_Cd , instance_num, ValType_Cd , TVal_Char , NVal_Num , ValueFlag_Cd , Quantity_Num , Units_Cd , End_Date , Location_Cd , Confidence_Num , Sourcesystem_Cd ) ;
          see --> instance_num
          dansullivan Daniel Sullivan added a comment - see --> instance_num
          mem61 Mike Mendis added a comment -
          Fixed in the final

          thanks
          mem61 Mike Mendis added a comment - Fixed in the final thanks

          People

            mem61 Mike Mendis
            dansullivan Daniel Sullivan
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: