STORET Warehouse Change Log
This change log details the status of bugs and issues in the STORET Warehouse. Matters of contention that are resolved are listed as completed,while ongoing issues are listed as open.
|Issue Number||Title/Description||Proposed Fix||STORET Helpdesk Tracking #(s)||Fix Date||Status||Received Date|
|artf6271||Project Document/ Graphic and Project/ Document URL fields are not being returned from the Warehouse|
From the Warehouse query application, Project Document / Graphic URLs are blank when returned in the downloaded text file.
|The maximum Project Document / Graphic unique identifier from WQX must be placed in the correct table and column within the STORET Warehouse, and the refresh process will confirm this unique ID is getting populated and the URL is populating the "Project Document/Graphic" data element in the STORET Warehouse.||1292, 1473, 725||Closed||2/2/2011|
|artf7800||Data Elements Result Depth and Result Depth Unit are not available in the STORET Warehouse|
Result Depth and Result Depth Unit are data elements available in WQX, but not queriable through the STORET Warehouse.
|artf6279||STORET Warehouse counts and EPA web services counts for Results and Stations should match|
STORET Warehouse query counts and STORET web services counts for results and stations do not match. When results or stations are queried with EPA web services, counts do not match replicate queries in the STORET Warehouse query application.
|artf6027||Characteristic Name is not populated when Category-Rep Num is Routine Habitat|
From the Storet warehouse, the Characteristic Name field is not populated when Routine Habitat is indicated for the field Category-Rep Num. This issue only relates to distributed STORET data.
|artf6996||Activities repeated multiple times|
Activity ID's are repeated multiple times for results queried from the WQX web services.
|artf7431||STORET Warehouse is not returning results with result comment fields that exceed 3000 characters|
Results with an extensive amount of characters in the result comment fields are not being returned from the STORET Warehouse. This issue only affects result comment fields exceeding 3900 characters.
|artf6628|| Activity Groups are not available out of the STORET Warehouse|
Activity group is a data element available in WQX, however not out of the STORET Warehouse.
|artf6705|| WQX -- STORET Warehouse issue with repeating projects|
When the STORET GetResults web service is called (http://iaspub.epa.gov/webservices/StoretResultService/), the returned data file sometimes contains repeating Project IDs.
|Evaluate the extent of the issue to determine if this is an issue with all GetResults service calls or only a few organizations. Make any needed revisions to the GetResults service code.||1289||Closed||5/17/2011|
|artf7143||Missing Activity Attached Documents|
From the Warehouse query application, Activity Document / Graphic URLs are blank when returned in the downloaded text file.
|The maximum Activity Document / Graphic unique identifier from WQX must be placed in the correct table and column within the STORET Warehouse, and the refresh process will confirm this unique ID is getting populated and the URL is populating the "Activity/Result Document Graphic" data element in the STORET Warehouse.||1292, 977||Closed||9/14/2011|
|artf7158||Projects and Monitoring Locations are not being deleted out of the Warehouse.|
There is currently not a way to delete projects or monitoring locations from the STORET Warehouse.
|Develop scripts to mirror actions executed in WQX deleting Monitoring Locations and Projects to concurrently perform the same actions in the STORET Warehouse.||1351||Closed||9/17/2011|
|artf6338||Alternative Monitoring Locations to Warehouse Station Alias Table|
The STORET Warehouse is not serving out Alternative Monitoring Locations when queried.
|artf7429||Activity comment field truncation|
The Activity Comment field is being truncated at 256 characters for biological results only. It should be 4000 characters.
|artf7432||Detection Limits/Upper and Lower Quantification Limit|
Non detect values for characteristics are not consistently displayed out of the Warehouse.
|791, 644, 1128, 1477||Closed||10/26/2011|
|artf6337||Detection Limits Handling|
It appears that the Warehouse is currently not able to report all detection limits associated with a result in separate columns (WQX data). For example, when data has an Upper Quantification Limit, that value is being reported in both the “Detection Limit” field as well as the “Upper Quantification Limit” field when exported from the Warehouse.
|791, 644, 1128, 1477||Closed||2/16/2011|
|artf7448|| Characteristic names are duplicated when the activity is data logger (historical results)|
Data Logger results are duplicated for historical STORET data
|artf7672||Results associated with EPA Beaches data are duplicating|
EPA Beaches results data is duplicated when downloaded from the STORET Warehouse.
|artf6730||Activity Media Name field is returning incorrect values for QC submissions|
WQX data submitted with Activity Types containing the phrase "Quality Control" are not being consistently stored as QC data in the STORET Warehouse.
|Explore the universe of data that falls within a QC media within the STORET Warehouse. Explore alternative ways of serving out QC data in order to preserve the original activity media submitted by users.||420, 1174||Open||5/23/2011|
|artf6272||Map scales for some Monitoring Locations have extra decimal places when downloaded from the STORET Warehouse|
Some Monitoring Location map scales are being assigned extra decimal places when downloaded from the Warehouse.
|This has been fixed.||725||Closed||2/2/2011|
|artf6203||WQX toxicity data is improperly mapped to STORET regular results|
Much of the toxicity data in WQX is getting improperly mapped to the STORET regular result fact table instead of the biological result fact table where it should be mapped to. This behavior is not consistent; the WQX data with "Count" as the characteristic is getting placed in the STORET biological result fact table, but none of the other records are.
|Data is currently stored as biological results if the activity media is biological. Data will now be mapped as biological results if the activity media is biological, and/ or Biological Intent is not null, and /or Taxonomic IAd is not null.||Open||1/19/2011|
|You will need Adobe Acrobat Reader to view the Adobe PDF files on this page. See EPA's PDF page for more information about getting and using the free Acrobat Reader.|