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

Data_Upgrade_Guide.pdf errors

    XMLWordPrintable

Details

    • Documentation
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.6.00
    • 1.6.03
    • Documentation
    • None
    • 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

            jmd86 Janice Donahoe
            kowalskg George Kowalski
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: