80 likes | 87 Views
EPA is updating SDWIS State to address security issues & ensure compatibility with Java 8. Consultation with state staff for technical fixes. Future updates for integration with "add-on" applications.
E N D
SDWIS State Update Renee Morris, Drinking Water Protection Division, Infrastructure Branch
Current SDWIS State Systems and Processes Legend Field Notebook or Mobil App Green – Primacy Agency Network EPA Network Blue – Yellow – EPA Developed Software installed on Primacy Agency Network • SDWIS • FedRep SDWIS State Application SDWIS State Database Oracle or SQL Server External System Federal Reporting Process • XML Validated File Desktop Sanitary Survey Sanitary Survey Extract XML File Data Bridge • XML File Migrate to State Drinking Lab - to - State • XML File - - XML Sampling Water Watch Data Paper State Web Site CSV XML Entry Apps Public Access to DW Data State Data Entry Operators Samples and Sample Results Submitted by Laboratories
EPA Decision with Regard to SDWIS State • EPA has decided to move forward with updating SDWIS State and its data flow components to address security issues related to outdated underlying software • This will enable primacy agencies to safely continue to use SDWIS State while we proceed with actions to assess the SDWIS Prime database issues and path ahead • We have consulted with multiple state staff to determine the technical fixes we need to address • We have requested a Level of Effort from Systalex for this update
Identified Technical Issues with SDWIS State Potential Incompatibility between Java 8 and SDWIS Products - Bulletin from SAIC about Java version 1/21/2016 • Based on limited testing of SDWIS/FedRep, SDWIS/STATE, and other SDWIS products deployed with Java 8, agencies are advised to refrain from upgrading to Java 8 and to continue to deploy these products using Java 7 • While preliminary testing appears to indicate many key functions of SDWIS/FedRep, SDWIS/STATE, and other SDWIS applications work with Java 8, there are known issues with at least the reporting functions of these applications (for example, the SDWIS/STATE Compliance Determination reports and SDWIS/FedRep reports and job listing/details functions.) • This advisory applies to the most recent releases of SDWIS/FedRep (3.51) and SDWIS/STATE (3.32), both of which used Java 7 for certification testing, as documented in the Installation Guide and Release Notes for each product
Request for the Level of Effort for SDWIS State Update • To be compatible with Java 8 or higher • Need to be able to install and run OpenJDK (Open Java Development Kit) • To be compatible with Tomcat 8.5 or higher • To be compatible with Window Server 2012/2016 • Allow cross browser compatibility (Chrome, Firefox, Edge)
Additional Considerations • Ensure updates to the core SDWIS State application will support continued integration with SDWIS State “add-on” applications: • Drinking Water Watch, XML Sampling, Migrate to State, FedRep, Data Bridge, Lab-to-State, Sanitary Survey • These “add-on” applications will also require similar updates and should be included in the LOE • Determine all the needed upgrades to do for the minimum level of stabilization/security • Identify what version of the software you recommend updating to for each of the above and why
CMDP Considerations • Ensure updates to the core SDWIS State application will support continued integration with CMDP Data Sync Engine or identify whether it is determined that updates will be needed for the Data Sync Engine
Next Steps • We expect to have an initial, draft SDWIS State update schedule over the next one to two months. • We will communicate schedule and more details about the expected updates