[CORE-60] Data_Upgrade_Guide.pdf errors Created: 20/Dec/11 Updated: 05/Jun/14 Resolved: 21/Dec/11 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | Documentation |
| Affects Version/s: | 1.6.00 |
| Fix Version/s: | 1.6.03 |
| Type: | Documentation | Priority: | Major |
| Reporter: | George Kowalski | Assignee: | Janice Donahoe |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
oracle linux 1.6.01 |
||
| Rank: | 0|i000vr: |
| Participant/s: |
| 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]$ |
| Comments |
| Comment by George Kowalski [ 20/Dec/11 ] |
|
Also in section 2.5 -> 3 The line : 3. To upgrade the pm tables by running the following: ant –f data_build.xml upgrade_pmdata_tables_release_1-6 should read : ant -f data_build.xml upgrade_pm_tables_release_1-6 |
| Comment by Mike Mendis [ 21/Dec/11 ] |
| thanks for the updates, I have updated the docs with the fixes |