Step 4: Create Data Repository (CRC) Stored Procedures


The fourth step in the Crcdata installation process is to create the stored procedures for the demodata tables


If performing a new install of i2b2 v1.7.13 on SQL Server, there is an issue in installing some of the stored procedures through the ant command. Before this step, you will need to edit edu.harvard.i2b2.data/Release_1-7/NewInstall/Crcdata/data_build.xml, line 49. Under the target “create_procedures_release_1.7” change delimiter=”;” to delimeter=”GO”.



Select the command line that is appropriate for your environment.



ant -f data_build.xml create_procedures_release_1-7





%ANT_HOME%\bin\ant.bat -f data_build.xml create_procedures_release_1-7




If the command %ANT_HOME% does not work it may be because you did not set your environment variables as suggested in the Requirements Chapter. If you do not wish to set this variable then you will need to replace %ANT_HOME% with the full path to your Ant directory.