CaTissue Deployment Error
From Informatics
Buildfile: deploy.xml
deploy_all:
deploy_app:
assert:
init:
[echo] Initializing installation...
[unwar] Expanding: /opt/caTissue/catissuecore.war into /opt/caTissue/tempCatissuecore/catissuecore
[copy] Copying 9 files to /opt/caTissue/tempCatissuecore/catissuecore-properties
[copy] Copying 1 file to /opt/caTissue/tempCatissuecore
[copy] Copying 1 file to /opt/caTissue/tempCatissuecore
[copy] Copying 1 file to /opt/caTissue/tempCatissuecore
[copy] Copying 1 file to /opt/caTissue/tempCatissuecore
[copy] Copying 1 file to /opt/caTissue/tempCatissuecore
configure_war:
[echo] Modifying caTissueCore Configuration File...
adopter_configuration:
[echo] Updating Site Images
[copy] Copying 1 file to /opt/caTissue/tempCatissuecore/catissuecore/images
mysql_config:
[echo] Modifying caTISSUECore MySQL specific Configuration File...
configure_titli:
[echo] mysql catissuecore
build_war:
[echo] Creating New Web Application Archieve File...
[war] Building war: /opt/caTissue/tempCatissuecore/catissuecore.war
[war] Warning: selected war files include a WEB-INF/web.xml which will be ignored (please use webxml attribute to war task)
copy_files:
[echo] Copying caTISSUECore Application Components...
[copy] Copying 9 files to /opt/jboss-4.0.0/server/default/catissuecore-properties
[copy] Copying 2 files to /opt/jboss-4.0.0/server/default/deploy
[copy] Copying 2 files to /opt/jboss-4.0.0/server/default/lib
[copy] Copying 1 file to /opt/jboss-4.0.0/bin
send_mail:
[echo] Sending mail to:
[echo] Sending mail from:
[mail] Sending email: caTissue Core Successfully Deployed
[mail] Failed to send email
[echo]
[echo] Please check the Email of mhonig@c2b2.columbia.edu.
[echo] If the Deployment mail is not received please check your
[echo] email.administrative.emailAddress and email.sendEmailFrom.emailAddress
[echo] properties in caTissueInstall.properties and Re-deploy the Application.
[echo]
db_initialize:
firstUser:
mysqlFirstUser:
[echo] Encoding Password...
[unwar] Expanding: /opt/caTissue/catissuecore.war into /opt/caTissue/tempCatissuecore/catissuecore
[java] encodedPWD 66416f577265676c6f63746f
[java] Np1Or1
[java] Filename : ./catissuetmp.txt : password : magnet4us : encoded6d41615767656e6c6563746f346d75657354
[echo]
[echo] Encoded Password 6d41615767656e6c6563746f346d75657354
[echo]
[echo] Modifying caTISSUECore SQL file for user information...
[copy] Copying 1 file to /opt/caTissue/tempCatissuecore
[copy] Copying 1 file to /opt/caTissue/SQL/Common
[delete] Deleting directory /opt/caTissue/tempCatissuecore
db_initialize_mysql:
[echo] Initializing MySQL Database for caTISSUECore Application...
[sql] Executing file: /opt/caTissue/SQL/MySql/catissuecore.sql
[sql] Failed to execute: alter table CATISSUE_COLL_COORDINATORS drop foreign key FKE490E33A48304401
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_COLL_COORDINATORS' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_COLL_COORDINATORS drop foreign key FKE490E33A2206F20F
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_COLL_COORDINATORS' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_COLLECTION_PROTOCOL drop foreign key FK32DC439DBC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_COLLECTION_PROTOCOL' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_EVENT_PARAM drop foreign key FK90C79AECBC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_TRANSFER_EVENT_PARAM drop foreign key FK71F9AC103C2DAC61
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_TRANSFER_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_TRANSFER_EVENT_PARAM drop foreign key FK71F9AC1099DF0A92
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_TRANSFER_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_TRANSFER_EVENT_PARAM drop foreign key FK71F9AC10BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_TRANSFER_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_STOR_CONT_SPEC_CLASS drop foreign key FKE7F5E8C2B3DFB11D
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_STOR_CONT_SPEC_CLASS' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_COLL_EVENT_PARAM drop foreign key FKF9888F91BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_COLL_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_PASSWORD drop foreign key FKDE1F38972206F20F
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_PASSWORD' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_BIOHZ_REL drop foreign key FK7A3F5539F398D480
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_BIOHZ_REL' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_BIOHZ_REL drop foreign key FK7A3F553960773DB2
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_BIOHZ_REL' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_MOL_SPE_REVIEW_PARAM drop foreign key FK5280ECEBC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_MOL_SPE_REVIEW_PARAM' doesn't exist"
[sql] Failed to execute: #--alter table CATISSUE_STORAGE_TYPE drop foreign key FKE9A0629A81236791;
[sql] alter table CATISSUE_STORAGE_TYPE drop foreign key FKE9A0629ABC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_STORAGE_TYPE' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_STORAGE_TYPE drop foreign key FK185C50B59A3CE5C
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_STORAGE_TYPE' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_STORAGE_TYPE drop foreign key FK185C50B81236791
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_STORAGE_TYPE' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_CONTAINER drop foreign key FK49B8DE5DB097B2E
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_CONTAINER' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_CONTAINER drop foreign key FK49B8DE5DAC76C0
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_CONTAINER' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_DISTRIBUTION_SPE_REQ drop foreign key FKE34A3688BE10F0CE
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_DISTRIBUTION_SPE_REQ' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_DISTRIBUTION_SPE_REQ drop foreign key FKE34A36886B1F36E7
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_DISTRIBUTION_SPE_REQ' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SITE drop foreign key FKB024C3436CD94566
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SITE' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SITE drop foreign key FKB024C3432206F20F
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SITE' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_EMBEDDED_EVENT_PARAM drop foreign key FKD356182FBC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_EMBEDDED_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_IN_OUT_EVENT_PARAM drop foreign key FK4F0FAEB9BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_IN_OUT_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_COLL_DISTRIBUTION_REL drop foreign key FK1483BCB56B1F36E7
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_COLL_DISTRIBUTION_REL' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_COLL_DISTRIBUTION_REL drop foreign key FK1483BCB548304401
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_COLL_DISTRIBUTION_REL' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_DISPOSAL_EVENT_PARAM drop foreign key FK1BC818D6BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_DISPOSAL_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_REQUIREMENT drop foreign key FK39AFE96861A1C94F
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_REQUIREMENT' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_ST_CONT_ST_TYPE_REL drop foreign key FK703B902159A3CE5C
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_ST_CONT_ST_TYPE_REL' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_ST_CONT_ST_TYPE_REL drop foreign key FK703B9021B3DFB11D
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_ST_CONT_ST_TYPE_REL' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_PROTOCOL drop foreign key FKB8481373870EB740
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_PROTOCOL' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_FLUID_SPE_EVENT_PARAM drop foreign key FK70565D20BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_FLUID_SPE_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPUN_EVENT_PARAMETERS drop foreign key FK312D77BCBC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPUN_EVENT_PARAMETERS' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_RECEIVED_EVENT_PARAM drop foreign key FKA7139D06BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_RECEIVED_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_RACE drop foreign key FKB0242ECD87E5ADC7
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_RACE' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_CLINICAL_REPORT drop foreign key FK54A4264515246F7
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_CLINICAL_REPORT' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_COLL_SPECIMEN_REQ drop foreign key FK860E6ABEBE10F0CE
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_COLL_SPECIMEN_REQ' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_COLL_SPECIMEN_REQ drop foreign key FK860E6ABE53B01F66
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_COLL_SPECIMEN_REQ' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECI_ARRAY_CONTENT drop foreign key FKBEA9D458C4A3C438
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECI_ARRAY_CONTENT' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECI_ARRAY_CONTENT drop foreign key FKBEA9D45860773DB2
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECI_ARRAY_CONTENT' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECI_ARRAY_CONTENT drop foreign key FKBEA9D45892AB74B4
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECI_ARRAY_CONTENT' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_ARRAY drop foreign key FKECBF8B3E64B129CC
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_ARRAY' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_ARRAY drop foreign key FKECBF8B3EF8278B6
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_ARRAY' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_ARRAY drop foreign key FKECBF8B3EBC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_ARRAY' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_ARRAY drop foreign key FKECBF8B3EB3DFB11D
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_ARRAY' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_ARRAY drop foreign key FKECBF8B3EECE89343
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_ARRAY' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_ARRAY_TYPE drop foreign key FKD36E0B9BBC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_ARRAY_TYPE' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_DISTRIBUTED_ITEM drop foreign key FKA7C3ED4B60773DB2
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_DISTRIBUTED_ITEM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_DISTRIBUTED_ITEM drop foreign key FKA7C3ED4BF8278B6
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_DISTRIBUTED_ITEM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_EVENT_PARAM drop foreign key FK753F33AD60773DB2
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_EVENT_PARAM drop foreign key FK753F33AD2206F20F
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_EVENT_PARAM drop foreign key FK753F33AD8CA560D1
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_STOR_TYPE_SPEC_CLASS drop foreign key FK1BCF33BA59A3CE5C
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_STOR_TYPE_SPEC_CLASS' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_COLL_PROT_EVENT drop foreign key FK7AE7715948304401
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_COLL_PROT_EVENT' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_CONTAINER_TYPE drop foreign key FKCBBC9954DAC76C0
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_CONTAINER_TYPE' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_PART_MEDICAL_ID drop foreign key FK349E77F9A7F77D13
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_PART_MEDICAL_ID' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_PART_MEDICAL_ID drop foreign key FK349E77F987E5ADC7
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_PART_MEDICAL_ID' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_STORAGE_CONTAINER drop foreign key FK28429D01BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_STORAGE_CONTAINER' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_STORAGE_CONTAINER drop foreign key FK28429D01A7F77D13
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_STORAGE_CONTAINER' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_STORAGE_CONTAINER drop foreign key FK28429D0159A3CE5C
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_STORAGE_CONTAINER' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_CELL_SPE_REVIEW_PARAM drop foreign key FK52F40EDEBC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_CELL_SPE_REVIEW_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_DISTRIBUTION drop foreign key FK542766802206F20F
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_DISTRIBUTION' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_DISTRIBUTION drop foreign key FK542766806B1F36E7
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_DISTRIBUTION' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_DISTRIBUTION drop foreign key FK542766801DBE834F
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_DISTRIBUTION' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_DISTRIBUTION drop foreign key FK5427668060773DB2
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_DISTRIBUTION' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_PROCEDURE_EVENT_PARAM drop foreign key FKEC6B4260BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_PROCEDURE_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_DISTRIBUTION_PROTOCOL drop foreign key FKC8999977BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_DISTRIBUTION_PROTOCOL' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_EXTERNAL_IDENTIFIER drop foreign key FK5CF2FA2160773DB2
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_EXTERNAL_IDENTIFIER' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_FIXED_EVENT_PARAM drop foreign key FKE0F1781BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_FIXED_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_THAW_EVENT_PARAMETERS drop foreign key FKD8890A48BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_THAW_EVENT_PARAMETERS' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_COLL_PROT_REG drop foreign key FK5EB25F1387E5ADC7
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_COLL_PROT_REG' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_COLL_PROT_REG drop foreign key FK5EB25F1348304401
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_COLL_PROT_REG' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_FROZEN_EVENT_PARAM drop foreign key FK52627245BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_FROZEN_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN drop foreign key FK1674810456906F39
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN drop foreign key FK1674810433BF33C5
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN drop foreign key FK16748104B189E99D
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN drop foreign key FK1674810432B31EAB
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_USER drop foreign key FKB025CFC71792AD22
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_USER' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_USER drop foreign key FKB025CFC7FFA96920
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_USER' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_USER drop foreign key FKB025CFC76CD94566
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_USER' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_USER drop foreign key FKB025CFC7F30C2528
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_USER' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_TIS_SPE_EVENT_PARAM drop foreign key FKBB9648F4BC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_TIS_SPE_EVENT_PARAM' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_ST_CONT_COLL_PROT_REL drop foreign key FK3AE9FCA7B3DFB11D
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_ST_CONT_COLL_PROT_REL' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_ST_CONT_COLL_PROT_REL drop foreign key FK3AE9FCA748304401
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_ST_CONT_COLL_PROT_REL' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_COLL_GROUP drop foreign key FKDEBAF167A7F77D13
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_COLL_GROUP' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_COLL_GROUP drop foreign key FKDEBAF1674CE21DDA
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_COLL_GROUP' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_COLL_GROUP drop foreign key FKDEBAF16753B01F66
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_COLL_GROUP' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_COLL_GROUP drop foreign key FKDEBAF1677E07C4AC
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_COLL_GROUP' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_SPECIMEN_TYPE drop foreign key FKFF69C195ECE89343
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_SPECIMEN_TYPE' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_PERMISSIBLE_VALUE drop foreign key FK57DDCE153B5435E
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_PERMISSIBLE_VALUE' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_PERMISSIBLE_VALUE drop foreign key FK57DDCE1FC56C2B1
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_PERMISSIBLE_VALUE' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_AUDIT_EVENT drop foreign key FKACAF697A2206F20F
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_AUDIT_EVENT' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_AUDIT_EVENT_LOG drop foreign key FK8BB672DF77F0B904
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_AUDIT_EVENT_LOG' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_AUDIT_EVENT_DETAILS drop foreign key FK5C07745D34FFD77F
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_AUDIT_EVENT_DETAILS' doesn't exist"
[sql] Failed to execute: alter table CATISSUE_AUDIT_EVENT_QUERY_LOG drop foreign key FK62DC439DBC7298A9
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.CATISSUE_AUDIT_EVENT_QUERY_LOG' doesn't exist"
[sql] Executing file: /opt/caTissue/SQL/MySql/InitDB_CreateTable.sql
[sql] Executing file: /opt/caTissue/SQL/Common/initDB_Insert_Common.sql
[sql] Executing file: /opt/caTissue/SQL/Common/AlterTable.sql
[sql] Failed to execute: insert into catissue_user (IDENTIFIER, ACTIVITY_STATUS, CSM_USER_ID, EMAIL_ADDRESS,LOGIN_NAME,FIRST_NAME,LAST_NAME) values (1,'Active',1,'admin@admin.com','admin@admin.com','Admin','Admin')
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.catissue_user' doesn't exist"
[sql] Failed to execute: insert into catissue_password (IDENTIFIER,PASSWORD,UPDATE_DATE,USER_ID) values ( '1','6c416f576765696c6e63316f326d3365',NULL,'1')
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.catissue_password' doesn't exist"
[sql] Executing file: /opt/caTissue/SQL/Common/CDE_DummyData_Common.sql
[sql] Executing file: /opt/caTissue/SQL/MySql/csm_catissuecore.sql
[sql] Failed to execute: /*/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT ;*/ /*/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS ;*/ /*/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION ;*/ #-- Aarti Sharma : updating all dates with value '0000-00-00' to '2005-01-01'
[sql] update csm_group set update_date = '2005-01-01' where update_date = '0000-00-00'
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.csm_group' doesn't exist"
[sql] Failed to execute: update csm_protection_element set update_date = '2005-01-01' where update_date = '0000-00-00'
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.csm_protection_element' doesn't exist"
[sql] Failed to execute: #-- Remove unwanted protection groups
[sql] delete from csm_protection_group where PROTECTION_GROUP_NAME like '%_ATTRIBUTES' or PROTECTION_GROUP_NAME like 'ADMIN_DATA_USE_GROUP' or PROTECTION_GROUP_NAME like 'COLLECTION_PROTOCOL_GROUP' or PROTECTION_GROUP_NAME like 'DISTRIBUTION_PROTOCOL_GROUP'
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.csm_protection_group' doesn't exist"
[sql] Failed to execute: #-- Remove unwanted protection elements
[sql] delete from csm_protection_element where ATTRIBUTE IS NOT NULL
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.csm_protection_element' doesn't exist"
[sql] Executing file: /opt/caTissue/SQL/Common/createUser.sql
[sql] Failed to execute: insert into catissue_department values(1,'C2B2_MAGNet')
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.catissue_department' doesn't exist"
[sql] Failed to execute: insert into catissue_institution values(1,'Columbia University')
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.catissue_institution' doesn't exist"
[sql] Failed to execute: insert into catissue_cancer_research_group values(1,'Irving Cancer Research Center')
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.catissue_cancer_research_group' doesn't exist"
[sql] Failed to execute: insert into catissue_address (identifier,state,country,zipcode) values(1,null,null,null)
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.catissue_address' doesn't exist"
[sql] Failed to execute: UPDATE catissue_user SET EMAIL_ADDRESS='mhonig@c2b2.columbia.edu', LOGIN_NAME='mhonig@c2b2.columbia.edu', DEPARTMENT_ID=1, INSTITUTION_ID=1, CANCER_RESEARCH_GROUP_ID=1, ADDRESS_ID=1 WHERE IDENTIFIER = 1
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.catissue_user' doesn't exist"
[sql] Failed to execute: UPDATE catissue_password set PASSWORD='6d41615767656e6c6563746f346d75657354', UPDATE_DATE=now() WHERE IDENTIFIER = 1
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.catissue_password' doesn't exist"
[sql] Executing file: /opt/caTissue/SQL/Common/insert_default_data.sql
[sql] Failed to execute: /*********Inserting Any value in storage type tables********/ insert into catissue_container_type (IDENTIFIER,CAPACITY_ID,NAME,ONE_DIMENSION_LABEL,TWO_DIMENSION_LABEL,COMMENTS,ACTIVITY_STATUS) values ( '1',NULL,'All',NULL,NULL,NULL,'Disabled')
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.catissue_container_type' doesn't exist"
[sql] Failed to execute: insert into catissue_container_type (IDENTIFIER,CAPACITY_ID,NAME,ONE_DIMENSION_LABEL,TWO_DIMENSION_LABEL,COMMENTS,ACTIVITY_STATUS) values ( '2',NULL,'Any',NULL,NULL,NULL,'Disabled')
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.catissue_container_type' doesn't exist"
[sql] Failed to execute: insert into catissue_storage_type (IDENTIFIER) values ( '1')
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.catissue_storage_type' doesn't exist"
[sql] Failed to execute: insert into catissue_specimen_array_type (IDENTIFIER) values ( '2')
[sql] java.sql.SQLException: Base table or view not found message from server: "Table 'catissuecore.catissue_specimen_array_type' doesn't exist"
[sql] Executing file: /opt/caTissue/SQL/Common/indexes.sql
[sql] Executing commands
[sql] 3855 of 3966 SQL statements executed successfully
BUILD SUCCESSFUL Total time: 29 seconds
