Task Report: SSDS Hardening

Task Start End Duration Completed Dependencies Total Cost Assigned Planned Start Start Variance Constraint Start Planned End End Variance Constraint End
0) SSDS Hardening 1/14/08 8:00 AM 11/21/08 8:00 AM 43w 4d 7.5h 0%
1) Cleanup Configuration Management 1/14/08 8:00 AM 1/16/08 2:30 PM 3d 0%
1.1) Finish build overhaul (done on Mac) to make sure SSDS can be built easily (common sense defaults) and that ll components work with JBoss/MySQL combination. 1/14/08 8:00 AM 1/15/08 3:30 PM 2d 0% Kevin Gomes
1.2) Setup JavaDoc deployment as part of the build task 1/15/08 3:30 PM 1/16/08 10:00 AM 4h 0% 1.1 Mike McCann
1.3) Verify that wrapper generator unit test are on during test target of build 1/16/08 10:00 AM 1/16/08 2:30 PM 4h 0% 1.1 Mike McCann
1.4) Create some template startup scripts and document 1/14/08 8:00 AM 1/14/08 12:00 PM 4h 0% Mike McCann
2) Internal Application Consolidation 1/14/08 8:00 AM 1/29/08 4:30 PM 2w 1d 0%
2.1) Look at SSDS_Metadata database for all urls that point to ssds.shore.mbari.org and see if we can point those to new-ssds or DODS 1/15/08 3:30 PM 1/16/08 2:30 PM 1d 0% Kevin Gomes
2.2) Look at SSDS_Metadata database for all urls that point to dods.shore.mbari.org and see if we can point those to dods.mbari.org 1/16/08 2:30 PM 1/17/08 1:30 PM 1d 0% Kevin Gomes
2.3) Shutdown web server on predator (dods too) 1/17/08 1:30 PM 1/22/08 8:00 AM 4h 0% 2.1, 2.2 Kevin Gomes
2.4) Look at all web applications on predator and see if we can simply CNAME ssds.shore.mbari.org to new-ssds. 1/22/08 8:00 AM 1/22/08 12:00 PM 4h 0% Kevin Gomes
2.5) Shutdown JBoss on predator 1/22/08 12:30 PM 1/22/08 4:30 PM 4h 0% 2.4 Kevin Gomes
2.6) Plan shutdown time for predator 1/22/08 4:30 PM 1/23/08 11:00 AM 4h 0% 2.5 Kevin Gomes
2.7) Backup files off predator (should we migrate UpdateBot and Graphing stuff to Elvis?) 1/23/08 11:00 AM 1/24/08 10:00 AM 1d 0% 2.6 Kevin Gomes
2.8) Have Pat upgrade predator to RHE 1/24/08 10:00 AM 1/25/08 9:00 AM 1d 0% 2.7 Pat Allen
2.9) Reinstall UpdateBot and Graphing software and restart. 1/25/08 9:00 AM 1/25/08 1:30 PM 4h 0% 2.8 Kevin Gomes
2.10) Figure out what ssds.mbari.org is right now, move content to web application and CNAME ssds.mbari.org to new-ssds.mbari.org (or rename new-ssd to ssds and CNAME new-ssds to ssds) 1/25/08 1:30 PM 1/29/08 12:00 PM 2d 0% Kevin Gomes
2.11) Remove MSSQL from SSDSPub 1/14/08 8:00 AM 1/14/08 12:00 PM 4h 0% Neil Conner
2.12) Verify data replication from tornado to ssdspub is turned off (remove data from ssdspub too) 1/14/08 12:30 PM 1/14/08 4:30 PM 4h 0% Neil Conner
2.13) Remove data directories on SSDSPub 1/24/08 10:00 AM 1/24/08 2:30 PM 4h 0% 2.12 Kevin Gomes
2.14) Verify the GetOriginalDataServlet on ssds.shore and ssdspub simply forward on to new-ssds 1/24/08 2:30 PM 1/25/08 9:00 AM 4h 0% Kevin Gomes
2.15) Clean everything up and look at making SSDSPub just a Tomcat installation to house web applications. 1/29/08 12:30 PM 1/29/08 4:30 PM 4h 0% 2.11, 2.13 Kevin Gomes
2.16) Remove the SSDS database from Solstice (backup first) 1/14/08 4:30 PM 1/15/08 11:00 AM 4h 0% Neil Conner
2.17) Remove the SSDS database from Fog (backup first) 1/15/08 11:00 AM 1/15/08 3:30 PM 4h 0% Neil Conner
2.18) Backup and remove all DTS's except on Fog for Solstice-SSDS_Metadata->Fog-SSDS_Metadata 1/15/08 3:30 PM 1/16/08 10:00 AM 4h 0% Neil Conner
3) Metadata Integrity Checking/Repairing/Enhancing 1/14/08 8:00 AM 2/11/08 3:30 PM 3w 4d 6h 0%
3.1) Have UpdateBot check all resources and if they do not have a ResourceType, use the file extension to map it to a MIME Type and create a ResourceType 1/29/08 4:30 PM 2/4/08 1:30 PM 3d 0% Kevin Gomes
3.2) Have UpdateBot crawl all resources and update contentLength if not specified 2/4/08 1:30 PM 2/5/08 12:00 PM 1d 0% Kevin Gomes
3.3) Lookup standard variables and standard units from UCAR and have UpdateBot mechanism add them to those without (for NetCDF, try to pull StandardVariable and update SSDS) 1/16/08 2:30 PM 1/31/08 2:30 PM 2w 0% Mike McCann
3.4) Implement a mechanism that updates the true end date/time on the DataContainer for data streams to show the latest data for each stream (should update number of records too) 2/5/08 12:30 PM 2/7/08 10:00 AM 2d 0% Kevin Gomes
3.5) Look into having SSDS create "README" type files in the same location as certain DataContainers. (These could/should be in FGDC format(?)) 1/31/08 2:30 PM 2/8/08 9:00 AM 1w 0% Mike McCann
3.6) Refactor and reinstate the SQL integrity check Rich wrote 1/14/08 8:00 AM 2/11/08 3:30 PM 3w 4d 6h 0% Rich Schramm
4) Improve Testing 2/7/08 10:00 AM 2/12/08 8:00 AM 3d 0%
4.1) Verify (unit tests) that the RecordDescription level parse regular expression works 2/7/08 10:00 AM 2/7/08 2:30 PM 4h 0% Kevin Gomes
4.2) Make sure XML dates that are coming out of XMLBuilder/ObjectBuilder cycle can be parsed by the XMLDateFormat 2/7/08 2:30 PM 2/8/08 9:00 AM 4h 0% Kevin Gomes
4.3) Check ObjectBuilder/XMLBuilder to make sure it handles URI/URL/DODSUrl/X/Y/Zoffsets correctly 2/8/08 9:00 AM 2/8/08 1:30 PM 4h 0% Kevin Gomes
4.4) Write valid unit test for Object and XMLBuilders 2/8/08 1:30 PM 2/11/08 9:00 AM 4h 0% Kevin Gomes
4.5) Make sure object schema/ObjectBuilder/XMLBuilder only use one DataContainer/DataProducer for output, input, consumer tags 2/11/08 9:00 AM 2/11/08 1:30 PM 4h 0% Kevin Gomes
4.6) Write tests for ResourceBLOB-ObjectBuilder for byte array and verify that it is working correctly 2/11/08 1:30 PM 2/12/08 8:00 AM 4h 0% Kevin Gomes
4.7) Improver Wrapper tests 2/8/08 9:00 AM 2/12/08 8:00 AM 2d 0% Mike McCann
5) Release 1 2/12/08 8:00 AM 2/12/08 8:00 AM 0% 1, 2, 4, 3
6) Enhance Access Interfaces 2/12/08 8:00 AM 3/27/08 11:00 AM 6w 1d 4h 0%
6.1) Develop web page to allow administrators to configure plot creation 2/12/08 8:00 AM 2/13/08 3:30 PM 2d 0% Kevin Gomes
6.2) Finish Implementating all DAOs 2/13/08 3:30 PM 2/20/08 8:00 AM 2d 4h 0% Kevin Gomes; Mike McCann
6.3) Verify PC02 plots are working after M0 turnaround 2/20/08 8:00 AM 2/20/08 12:00 PM 4h 0% Kevin Gomes
6.4) Add links to CVS XML on device pages 2/20/08 12:30 PM 2/20/08 4:30 PM 4h 0% Kevin Gomes
6.5) Need a mechanism for user to upload and store "Resources" in SSDS (some secure/backed up network location) and link them to other resource aware objects 2/20/08 4:30 PM 2/21/08 3:30 PM 1d 0% Kevin Gomes
6.6) In Explorer, truncate long deployment names 2/21/08 3:30 PM 2/22/08 10:00 AM 4h 0% Kevin Gomes
6.7) Implement more queries in Explorer 2/22/08 10:00 AM 2/28/08 3:30 PM 1w 0% Kevin Gomes
6.8) Migrate HOOVES to new architecture 2/20/08 8:00 AM 2/26/08 1:30 PM 1w 0% Mike McCann
6.9) Add HOOVES improvements 2/26/08 1:30 PM 3/27/08 11:00 AM 4w 2d 0% 6.8 Mike McCann
7) Develop admin application (edit metadata/relationships) 2/28/08 3:30 PM 3/17/08 2:30 PM 2w 1d 0% Kevin Gomes
8) Release 2 7/18/08 8:00 AM 7/18/08 8:00 AM 100% 7, 6
9) Improve Data Ingest Mechanisms 1/14/08 12:30 PM 3/26/08 8:00 AM 9w 4d 4h 0%
9.1) Try to change OASIS to make mooring turns less painful 1/14/08 12:30 PM 1/14/08 4:30 PM 4h 0% Mike McCann
9.2) Build non-JMS mechanism for users to send data/metadata to SSDS 3/17/08 2:30 PM 3/24/08 10:00 AM 1w 0% Kevin Gomes
9.3) Put true exception handling in SQLIngest to throw messages when the DB can't be reached (and reconnect automatically) 3/24/08 10:00 AM 3/25/08 9:00 AM 1d 0% Kevin Gomes
9.4) Change PacketSQLOutput/Input to work with any database (not just MSSQL) 3/25/08 9:00 AM 3/26/08 8:00 AM 1d 0% Kevin Gomes
10) Documentation 3/26/08 8:00 AM 4/10/08 11:00 AM 2w 1d 4h 0%
10.1) Put UML Diagram of data model on developer section of web application 3/26/08 8:00 AM 3/26/08 12:00 PM 4h 0% Kevin Gomes
10.2) Finish documenting data packet structure on web pages 3/26/08 12:30 PM 3/26/08 4:30 PM 4h 0% Kevin Gomes
10.3) Document Explorer, Admin app and HOOVES 3/27/08 11:00 AM 4/1/08 1:30 PM 2d 4h 0% Kevin Gomes; Mike McCann
10.4) Develop full system documentation 4/1/08 1:30 PM 4/10/08 11:00 AM 1w 2d 4h 0% Kevin Gomes; Mike McCann
11) Prepare for opening to community 3/26/08 4:30 PM 4/14/08 10:00 AM 2w 1d 4h 0%
11.1) Put Copyright in all SSDS source code and zip up and make externally available 3/26/08 4:30 PM 3/27/08 11:00 AM 4h 0% Kevin Gomes
11.2) Setup source on public repository 4/10/08 11:00 AM 4/14/08 10:00 AM 1d 0% Kevin Gomes
12) Release 3 11/21/08 8:00 AM 11/21/08 8:00 AM 0% 10, 9, 11