Details

    • Type: Documentation
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.6.00
    • Fix Version/s: 1.6.03
    • Component/s: Documentation
    • Labels:
      None
    • Environment:
      oracle
      linux
      1.6.01
    • Rank:
      0|i000vr:

      Description

      "Section 2.3 Upgrade i2b2crcdata tables" of this manual says:

      3. To upgrade the metadata tables and insert new, additional data for project
      'Demo' run the following:
      ant -f data_build.xml upgrade_crcdata_tables_release_1-6
      ant -f data_buid.xml upgrade_procedures_release_1-6

      The upgrade_crcdata_tables_release_1-6 does not exist in the build file. Instead one should use:

      ant -f data_build.xml upgrade_table_release_1-6

      Also there is a typo in the second line :
       
      ant -f data_buid.xml upgrade_procedures_release_1-6

      should read :

      ant -f data_build.xml upgrade_procedures_release_1-6

      not sure why the db.properties files in the upgrade directories do not have the line :

      db.project=i2b2

      by default.

      Also I get the following error when following the doc:

      Section 2.4

      7. To upgrade the metadata tables and insert new, additional data for project
      'Demo' run the following.



      [jboss@yount Metadata]$ vi db.properties
      [jboss@yount Metadata]$ ant -f data_build.xml upgrade_metadata_tables_release_1-6
      Buildfile: /home/jboss/src/Server/edu.harvard.i2b2.data/Release_1-6/Upgrade/Metadata/data_build.xml

      init:

      upgrade_metadata_tables_release_1-6:
            [sql] Executing resource: /home/jboss/src/Server/edu.harvard.i2b2.data/Release_1-6/Upgrade/Metadata/scripts/upgrade_oracle_i2b2metadata_tables.sql
            [sql] 0 rows affected
            [sql] 19621 rows affected
            [sql] 0 rows affected
            [sql] 0 rows affected
            [sql] 0 rows affected
            [sql] 0 rows affected
            [sql] 0 rows affected
            [sql] 0 rows affected
            [sql] 0 rows affected
            [sql] 0 rows affected
            [sql] 0 rows affected
            [sql] 102 rows affected
            [sql] 0 rows affected
            [sql] Failed to execute: CREATE INDEX META_FULLNAME_BIRN_IDX ON I2B2(C_FULLNAME)
            [sql] java.sql.SQLException: ORA-01408: such column list already indexed
            [sql] Failed to execute: CREATE INDEX META_APPLIED_PATH_BIRN_IDX ON I2B2(M_APPLIED_PATH)
            [sql] java.sql.SQLException: ORA-01408: such column list already indexed
            [sql] Failed to execute: CREATE TABLE ONT_PROCESS_STATUS ( PROCESS_ID NUMBER(5,0) PRIMARY KEY, PROCESS_TYPE_CD VARCHAR(50), START_DATE DATE, END_DATE DATE, PROCESS_STEP_CD VARCHAR2(50), PROCESS_STATUS_CD VARCHAR2(50), CRC_UPLOAD_ID NUMBER(38,0), STATUS_CD VARCHAR2(50), MESSAGE CLOB, ENTRY_DATE DATE, CHANGE_DATE DATE, CHANGEDBY_CHAR CHAR(50) )
            [sql] java.sql.SQLException: ORA-00955: name is already used by an existing object
            [sql] Failed to execute: create sequence ONT_SQ_PS_PRID start with 1
            [sql] java.sql.SQLException: ORA-00955: name is already used by an existing object
            [sql] 13 of 17 SQL statements executed successfully

      BUILD SUCCESSFUL
      Total time: 1 second
      [jboss@yount Metadata]$

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code