+------------------------+---------------------------------------------+
| ![](m                  | ![](medi                                    |
| edia/image1.wmf){width | a/image2.jpeg){width="1.4583333333333333in" |
| ="2.104861111111111in" | height="0.7916666666666666in"}**SDWIS/XML   |
| height="1.1875in"}     | Sampling 1.0.3 for Windows 2000 and Oracle  |
|                        | 9i Release Notes**                          |
| United States          |                                             |
| Environmental          |                                             |
| Protection Agency      |                                             |
|                        |                                             |
| Office of Ground Water |                                             |
| and Drinking Water     |                                             |
|                        |                                             |
| Contract No.           |                                             |
|                        |                                             |
| EPA BPA OARMSC-SYS-04  |                                             |
|                        |                                             |
| SDWIS Project          |                                             |
|                        |                                             |
| Product Control No.    |                                             |
|                        |                                             |
| Sy                     |                                             |
| stalex-SDWIS-01-13.d1a |                                             |
|                        |                                             |
| []{.mark}              |                                             |
|                        |                                             |
| April 30, 2007         |                                             |
+------------------------+---------------------------------------------+

**SDWIS/XML SAMPLING 1.0.3 for WINDOWS 2000 and ORACLE 9i RELEASE
NOTES**

**CONTRACT NO. EPA BPA OARMSC-SYS-04**

**SDWIS PROJECT**

**Prepared for:**

**United States Environmental Protection Agency**

**Office of Ground Water and Drinking Water**

**Drinking Water Protection Division**

**1200 Pennsylvania Ave., NW**

**Washington, DC 20460**

**Contracting Officer Representative**

**Edward Cottrill**

**Prepared by:**

**SAIC Solutions Delivery Center**

**Science Applications International Corporation**

**6565 Arlington Boulevard**

**Falls Church, VA 22042**

**CONTENTS**

[1.0 SDWIS/XML SAMPLING 1.0.3 Overview
1](#sdwisxml-sampling-1.0.3-overview)

[2.0 DEPLOYMENT INSTRUCTIONS 1](#deployment-instructions)

[2.1 Primacy Agency With Current SDWIS/XML Sampling 1.0.2 Installation
1](#primacy-agency-with-current-sdwisxml-sampling-1.0.2-installation)

[2.2 Primacy Agency Performing Initial SDWIS/XML Sampling Installation
1](#primacy-agency-performing-initial-sdwisxml-sampling-installation)

[2.3 SDWIS/XML Sampling 1.0.3 for Oracle Installation
2](#sdwisxml-sampling-1.0.3-for-oracle-installation)

[2.4 Execute the XMLSampling_1.0.3_Oracle.SQL
7](#execute-the-xmlsampling_1.0.3_oracle.sql)

[3.0 SDWIS/XML Sampling 1.0.3 Software Incident Reports RESOLVED
8](#sdwisxml-sampling-1.0.3-software-incident-reports-resolved)

[3.1 Event 13680 8](#event-13680)

[3.2 Event 13880 and 14649 8](#event-13880-and-14649)

[3.3 Event 14313 8](#event-14313)

[3.4 Event 14323 8](#event-14323)

[3.5 Event 14736 8](#event-14736)

[4.0 advisories 9](#advisories)

[4.1 Event 13809 9](#event-13809)

[4.2 Event 13892 9](#event-13892)

[4.3 Event 14050 9](#event-14050)

[4.4 Event 14754 9](#event-14754)

[5.0 file listing 9](#file-listing)

This page is intentionally left blank.

# SDWIS/XML SAMPLING 1.0.3 Overview

SDWIS/XML Sampling 1.0.3 resolves six defects uncovered since the August
2006 release of SDWIS/XML Sampling 1.0.2. SDWIS/XML Sampling 1.0.3 is
delivered as a XMLSampling_1.0.3_Oracle.EXE installation wizard that
installs two application components: a XMLSampling.war file and a
XMLSampling folder, and one database script component,
XMLSampling_1.0.3_Oracle.SQL file.

-   Section 2.0 describes a simple deployment process. Your site
    procedure for software deployment should be followed where
    appropriate.

-   Section 3.0 describes the corrections in this release.

-   Section 4.0 contains advisories.

-   Section 5.0 contains the application file listing.

# DEPLOYMENT INSTRUCTIONS

Download the XMLSampling_1.0.3_Oracle.zip file. Extract the
XMLSampling_1.0.3_Oracle.EXE, XMLSampling_1.0.3_Oracle.SQL and
CreateXMLSamp_Tables.DDL. Place the XMLSampling_1.0.3_Oracle.SQL into
your SSWR10 database utilities folder, which is commonly defined as
c:\\SSWR10_DbUtilities\\DbaScripts.

## Primacy Agency With Current SDWIS/XML Sampling 1.0.2 Installation

If you have already installed SDWIS/XML Sampling 1.0.2, continue with
this guide. However, please ignore the CreateXMLSampling_Tables.DDL file
included in this package for the convenience of primacy agencies who are
installing SDWIS/XML Sampling for the first time.

## Primacy Agency Performing Initial SDWIS/XML Sampling Installation

If you are installing SDWIS/XML Sampling for the first time, download
the XMLSampling_Docs_Oracle.zip to obtain the SDWIS/XML Sampling Release
1.0.1 Installation Guide. Use this SDWIS/XMLSampling_1.0.3 installation
package but follow the instructions detailed in the SDWIS/XML Sampling
Release 1.0.1 Installation Guide to install and configure your SDWIS/XML
Sampling software. After you complete the installation, please return to
Section 2.4 of this guide and follow the instructions for applying the
XMLSampling_1.0.3_Oracle.SQL script changes to your database. Place the
CreateXMLSamp_Tables.DDL into your SSWR10 database utilities folder,
which is commonly defined as c:\\SSWR10_DbUtilities\\DbaScripts.

## SDWIS/XML Sampling 1.0.3 for Oracle Installation

Install SDWIS/XML Sampling Release 1.0.3 for Oracle by following these
steps. Consult your System Administrator and site procedures for
specific instructions you may need to follow. These instructions use
c:\\tomcat-5.0.28 as the example Tomcat installation folder; please
adapt this to your installation.

Before proceeding to install, make sure Tomcat server is shut down by
stopping Apache Tomcat service using Control Panel\>\>Services (or by
double-clicking shutdown.bat located under Tomcat Home\\bin folder). At
this point, it is assumed you have downloaded, unzipped, and extracted
the *SDWIS/XML Sampling Release 1.0.3 for Oracle* installation package
(XMLSampling_1.0.3_Oracle.EXE).

Two files contain parameters you customized during your initial
installation of XML Sampling: the scheduler.bat and the
SystemProperty.txt. To avoid losing those customizations, you should
create a backup copy of each file that you will reinstate after
installation; **otherwise you will need to reconfigure theses files with
your customized parameters.**

1.  Open the
    C:\\tomcat-5.0.28\\Webapps\\XMLSampling\\WEB-INF\\classes\\com\\sdwis\\XMLSampling\\Utilities
    folder.

2.  Copy the SystemProperty.txt file temporarily to another folder
    outside of Tomcat.

3.  Open the C:\\tomcat-5.0.28\\Webapps\\XMLSampling folder.

4.  Copy the Scheduler.bat file temporarily to another folder outside of
    Tomcat.

5.  Open the c:\\tomcat-5.0.28\\webapps folder.

6.  Delete the XMLSampling folder.

7.  If there is an XMLSampling.war in the webapps folder, delete it.

8.  Exit the folders.

9.  Double-click the XMLSampling_1.0.3_Oracle.EXE installation package.
    The Installation Welcome display depicted in Exhibit 1 will be
    presented.

Click the **Next** button. Otherwise, click **Cancel**.

![](media/image3.png){width="5.197222222222222in"
height="3.9472222222222224in"}

**Exhibit 1.** SDWIS/XML Sampling1.0.3 Oracle Installation Welcome
Display

10. Exhibit 2 displays the default destination folders to be used for
    installing the XMLSampling.war and the other executable and
    configuration files.

> If you have a current SDWIS/XMLSampling Release installed, SDWIS/XML
> Sampling Release 1.0.3 for Oracle must be installed in the same
> folders as the SDWIS/XMLSampling Release 1.0.2 for Oracle
> installation.

-   The first XMLSampling Application Folder path is for the war file
    installation. Use the **Browse** button to modify this path if the
    default is not correct.

-   The second XMLSampling Application Folder is for the
    executables/configuration file folder and should be directed to your
    current SDWIS/XMLSampling 1.0.2 folder. Use the **Browse** button to
    modify this path if the default is not correct.

> For first time installations, follow the instructions in the
> SDWIS/XMLSampling Release 1.0.1 for Oracle Installation Guide.
>
> []{.mark}

![](media/image4.png){width="5.197222222222222in"
height="3.9368055555555554in"}

**Exhibit 2.** SDWIS/XML Sampling 1.0.3 Oracle Destination Location
Display

11. The SDWIS/XML Sampling Release 1.0.3 Oracle Start Installation
    display will be presented as depicted in Exhibit 3. Click the
    **Next** button to start the installation. Click **Cancel** to
    terminate the installation.

![](media/image5.png){width="5.197222222222222in"
height="3.9472222222222224in"}

**Exhibit 3.** SDWIS/XML Sampling1.0.3 Oracle Start Installation Display

12. The SDWIS/XML Sampling Release 1.0.3 Oracle Successfully Installed
    display will be presented as depicted in Exhibit 4. Click **Finish**
    to run the register.exe and exit the installation.

![](media/image6.png){width="5.197222222222222in"
height="3.9472222222222224in"}

**Exhibit 4.** SDWIS/XML Sampling1.0.3 Oracle Successfully Installed
Display

13. Press any key to continue after the register.exe (Exhibit 5) runs.

![](media/image7.png){width="5.995138888888889in"
height="2.9652777777777777in"}

**Exhibit 5.** SDWIS/XML Sampling1.0.3 Oracle File Registration Display

14. Restart Tomcat and wait for the start to complete entirely before
    proceeding to the next step. To verify that Tomcat has fully
    completed the startup process, check the stdout.log file located
    under c:\\tomcat-5.0.28\\logs or your Tomcat console (if you are
    running Tomcat as a batch process).

15. Open the
    C:\\tomcat-5.0.28\\Webapps\\XMLSampling\\WEB-INF\\classes\\com\\sdwis\\XMLSampling\\Utilities
    folder.

16. Replace the SystemProperty.txt file with your saved copy that
    contains your customized parameters.

17. Open the SystemProperty.txt file in a simple editor (such as
    Notepad) and modify the parameter called XMLSamplingVersion to be
    1.0.3.

18. Exit and Save the SystemProperty.txt file.

19. Open the C:\\tomcat-5.0.28\\Webapps\\XMLSampling folder.

20. Replace the Scheduler.bat file with your saved copy that contains
    your customized parameters.

21. Execute the SchemaUtility.bat from the same folder by
    double-clicking on it.

22. Stop and Restart Tomcat.

23. Launch the SDWIS/XML Sampling Home Page. The Home Page will reflect
    SDWIS/XML Sampling Release 1.0.3.

## Execute the XMLSampling_1.0.3_Oracle.SQL

1.  Start a SQL Plus session. Connect as a DBA user (e.g., System). Run
    the script XMLSampling_1.0.3_Oracle.SQL to modify the TMGERROR
    table. The following is a sample command syntax to run the script at
    the SQL Plus command prompt (SQL\>):

**SQL\>@C:\\SSWR10_DbUtilities\\DbaScripts\\XMLSampling_1.0.3_Oracle.SQL**

2.  Type in name of the schema (e.g. ILR10) when prompted.

3.  The database is now ready to run SDWIS/XML Sampling 1.0.3.

#  SDWIS/XML Sampling 1.0.3 Software Incident Reports RESOLVED

## Event 13680

Description: In the scenario where the Lab Sample No. has been reused by
a given water system, the sample collection date is not being used in
the retrieval of the parent sample when adding a sample analytical
result.

Resolution: This repair has been made. The TMGSAR.b_collection_end_dt is
now being populated during the staging process enabling it to be used in
the identification of the exact Sample for the lab, water system, and
lab sample no.

## Event 13880 and 14649

Description: The sample analytical result b_lab_rejection_reason (aka
interference) is not being accepted unless the microbial indicator is
'P' (present).

Resolution: When a sample analytical result record is submitted with a
null microbial indicator, the TSAMAR record is created and populated
with the provided values, including the lab rejection reason (aka
interference).

## Event 14313

Description: The text of message #125 in the TMGERROR table is
incorrect.

Resolution: Message has been changed to say: REJECT: Inconsistent result
data: Presence Indicator is \"P\" (present) and Count Value is \"0\".
(SAMPLE RESULT).

## Event 14323

Description: Total Coliform Rule samples of type SP (special) should not
be accepted with for-compliance indicator = 'Y'. (Note: Total Coliform
Rule Samples are TC samples collected at the distribution system.)

Resolution: When a TCR Coliform sample with of type SP is submitted with
for-compliance indicator = 'Y', it will be change to for-compliance =
'N' and flagged as changed on the error report.

## Event 14736

Description: When a Sample Result is presented on the Error Detail
report, the analyte code was omitted from the display.

Resolution: Analyte Code is now included in the display of rejected
Sample Results. Additionally, the source input file name has been added
to the top of this page.

# advisories

Please note the following advisories originally documented in previous
SDWIS/XML Sampling release notes, reprinted here for your convenience.

## Event 13809

The job delete function from within an email does not function unless
you are directly logged into the server. The workaround is to use the
SDWIS/XML Sampling Web interface to delete the jobs.

## Event 13892

Method Code is part of the uniqueness check for Sample Analytical
Results. The absence of a method code for an existing sample analytical
result may result in the appearance of a duplicate result for the same
sample and analyte if the subsequent result includes a method code.

## Event 14050

A sample input file, whether it be EDI or XML, must contain sample
reports for one and only one Laboratory.

## Event 14754

The Sampling via EDI flag message indicating that a Sample Result is
over the MCL is not present in SDWIS/XML Sampling.

# file listing

04/26/2007 05:30 PM 8,443,686 XMLSampling.war

[]{.mark}

04/23/2007 04:27 PM 1,846 XMLSampling_1.0.3_Oracle.SQL

12/29/2005 01:20 PM 86,687 CreateXMLSamp_Tables.DDL

[]{.mark}

[]{.mark}

All client/server files:

12/28/2005 04:45 PM 16,479 MIG0500E.dde

12/28/2005 04:55 PM 219 MIG0500E.DEF

10/17/2002 05:10 PM 31,004 CSUMG65N.DLL

10/17/2002 05:12 PM 151,552 WRL650N.DLL

04/14/2005 02:16 PM 94,208 IEFMBT.DLL

08/24/1996 11:11 AM 924,432 MFC40.DLL

09/26/1998 12:00 AM 995,383 MFC42.DLL

12/28/2005 04:55 PM 2,166,784 CASCADE.DLL

10/17/2002 05:10 PM 35,452 CSUVN65N.DLL

09/24/2004 03:16 PM 152,352 CSU65N.DLL

04/16/2007 03:37 PM 1,556,480 MIG0500E.DLL

05/29/2001 03:39 PM 45,056 wrguin.dll

06/14/2005 01:19 PM 917,504 WRG650N.DLL

09/24/2004 03:18 PM 81,920 WRF650N.DLL

06/17/1998 12:00 AM 77,878 MSVCIRT.DLL

07/29/1998 06:00 PM 266,293 MSVCRT.DLL

08/24/1996 11:11 AM 253,952 MSVCRT20.DLL

05/31/1998 12:00 AM 326,656 MSVCRT40.DLL

08/31/1999 04:55 PM 598,288 OLEAUT32.DLL

08/31/1999 04:55 PM 164,112 OLEPRO32.DLL

10/17/2002 05:12 PM 24,576 WRE650N.DLL

09/24/2004 03:16 PM 28,747 REQTOK65N.DLL

10/17/2002 05:19 PM 36,864 WRC650N.DLL

05/29/2001 03:39 PM 32,768 wrc600n.dll

09/22/1998 11:08 AM 76,288 SSFM1032.DLL

04/12/2005 04:46 PM 286,720 WRU650N.DLL

04/24/2006 03:21 PM 20,480 MIG0500E.EXE

11/09/2004 05:31 PM 61,440 REGISTER.EXE

03/02/2001 10:42 AM 33,483 CODEPAGE.INI

10/01/1998 12:20 PM 518,512 SSCALA16.OCX

10/01/1998 12:43 PM 684,832 SSCALA32.OCX

05/22/2000 12:00 AM 1,066,176 MSCOMCTL.OCX

10/23/2001 10:24 AM 825 WROAF.REG

12/28/2005 04:55 PM 1,295 MIG0500E.reg

05/29/2001 03:37 PM 34,880 WROF0000.TLB

05/29/2001 03:21 PM 130,244 WROA0000.TLB

36 File(s) 11,894,134 bytes