Details
-
Documentation
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.6.00
-
None
-
oracle
linux
1.6.01
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]$
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]$