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

          Ascending order - Click to sort in descending order
          dansullivan Daniel Sullivan created issue -
          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
          )
          ;
          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 ) ;
          dansullivan Daniel Sullivan added a comment -
          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
          mem61 Mike Mendis made changes -
          Field Original Value New Value
          Fix Version/s 1.6 [ 10051 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Workflow classic default workflow [ 10155 ] i2b2 Issues [ 10377 ]
          jmd86 Janice Donahoe made changes -
          Component/s Data [ 10024 ]
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          jmd86 Janice Donahoe made changes -
          Workflow i2b2 Issues [ 10377 ] i2b2 Issues Workflow [ 10550 ]
          jmd86 Janice Donahoe made changes -
          Component/s Data [ 10050 ]
          Component/s Data [ 10024 ]
          Fix Version/s 1.6.00 [ 10141 ]
          Fix Version/s 1.6.00 [ 10051 ]
          Key LEOPARD-73 CORE-44
          Project i2b2 [ 10000 ] i2b2 Core Project [ 10034 ]
          Affects Version/s 1.6.00-RC2 [ 10137 ]
          Affects Version/s 1.6.00-RC2 [ 10032 ]

          People

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

            Dates

              Created:
              Updated:
              Resolved: