• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
  • Database Findings: caTissue Plus DB IS Not Identical to Open Specimen DB

    Hello Sri, Poornima,

    I was curious to see why we cannot import the data from caTissue Plus database to the new one Open Specimen database, the answer is clear, the 2 databases are different. Although there are some tables that are common to both, there are tables that are in the caTissue Plus that are not in the Open specimen, and vice versa. Moreover there are some tables named: de_e_1227->de_e_1847 in caTissue Plus, not sure if these corresponds to some of the tables in Open Specimen. So although they are similar but they are not identical databses. I thought of a way to merge them, take the union of both databases, but decided against it.

    Findings:
    20 tables in caTissue Plus, which are not in Open Specimen
    67 tables are in Open Specimen but are not in caTissue Plus
    128 tables in caTissue Plus, named: de_e_1227->de_e_1847 which are not in Open Specimen. My hunch is that some, of those may correspond to some of the tables that are in Open Specimen but not in caTissue Plus.

    Nadia

    Why are you trying to ‘import’ the data in instead of just doing an ‘upgrade’?

    Hi John,

    Thank you for your post.

    I thought to do a complete fresh install. Would it solve the problem, if I do an upgrade? Did you try it yourself going from Plus to OS without losing any data?

    Thanks

    Nadia

    I just tried it, to upgrade, it did not work getting an error message, check below:

    C:\OSv1>ant upgrade -Dfrom.version=v32 -Dusername=“nahalabi@utmb.edu” > OSbuildO
    ct24.txt

    BUILD FAILED
    C:\OSv1\build.xml:2163: The following error occurred while executing this line:
    C:\OSv1\build.xml:5523: liquibase.exception.MigrationFailedException: Migration
    failed for change set ./SQL/liquibase_xml/DBUpgrade_v33.xml::2::catissue:
    Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TA
    BLE CATISSUE_STOR_CONT_UTILIZATION ADD CONSTRAINT FK_STORAGE_CONTAINER_ID FO
    REIGN KEY (STORAGE_CONTAINER_ID) REFERENCES CATISSUE_STORAGE_CONTAINER (IDE NTIFIER): Can’t create table ‘openspecimen.#sql-3434_22e’ (errno: 150):
    Caused By: Error executing SQL ALTER TABLE CATISSUE_STOR_CONT_UTILIZA TION ADD CONSTRAINT FK_STORAGE_CONTAINER_ID FOREIGN KEY (STORAGE_CONTAINER_I D) REFERENCES CATISSUE_STORAGE_CONTAINER (IDENTIFIER): Can’t create table ’
    openspecimen.#sql-3434_22e’ (errno: 150):
    Caused By: Can’t create table ‘openspecimen.#sql-3434_22e’ (errno: 150
    )

    Total time: 1 second