Cleanup of Legacy LIMS Code

In preparation for migrating our database from Oracle to Postgres, the AppDev team is undergoing a widespread cleanup of old code and unused database tables. This cleanup will reduce the total size of our database and make the migration much easier. All aspects of this cleanup have been vetted by members of AppDev, and are not expected to affect anyone's current daily work. This cleanup is scheduled to occur early next week, and we will be watching closely for any unexpected fallout. The broad categories for which we are removing code include:

  • mp_grande and primer design
  • Code / tables related to oligo ordering
  • The concept of creating "validation" work orders (i.e. work orders created specifically for primer design, not for sequencing). The old work orders will continue to exist, but will not be displayed specially by the code any longer.
  • The concept of "importing" sequence tags (i.e. gene annotations from ensembl, genbank, etc). We are no longer supporting the tables where this data used to be stored.
  • 3730 sequencing
  • 454 sequencing
  • Support for 'pooling' of capture probes (i.e. merging BED files). Please see (/wiki/spaces/IT/pages/180466677) for information about how to use GMS for these needs.

As always, please place a service desk ticket if you have any questions or notice anything unusual as a result of this cleanup.