General Notes

Structure Changes

Structure changes are not implemented automatically when updating the EQuIS 5 applications.

Before updating any existing databases; 1) consult your Database Administrator and 2) backup exiting database(s).  Existing databases can be updated using the File > Configure > Databases option for SQL Server or running the update script for Oracle.  For more detail on updating an Oracle database please review the EnterpriseInstall.pdf available from the EarthSoft Help Desk.

Tables:

Rt_result and rt_qualifier - Change dt_result.qualifier and rt_qualifier.qualifier to handle multi-character qualifiers and combined qualifiers (changed CHAR(2) to VARCHAR(2)).

Reports/Queries:

            Added a new report called Basic_results which queries data from the dt_basic_results table.

Known Issues:

·         EZEDD format is not creating test level records correctly for EQuIS 3.  This only affects clients using this format to import data using EDP2EQ3 and the EZEDD format.  This format does work correctly when importing into EQuIS 5.  The suggested work-around would be to use the EZEDD format distributed with EQuIS 3 for importing.

·         EFWEDD format is not creating test and results records correctly for EQuIS 3.  This only affects clients using this format to import data using EDP2EQ3 and the EFWEDD format.  This format does work correctly when importing into EQuIS 5.  The suggested work-around would be to use the EFWEDD format distributed with EQuIS 3 for importing.

·         Enterprise FTP Retrieval service returns error and does not retrieve EDDs from remote server.  This only affects the FTP Retrieval service and does not preclude use of FTP delivery on system hosting EarthSoft.Workflow.Service.exe

Resolved Cases

9987: EDD not showing on "All EDDs" after rollback

If an EDD is loaded into the database using EQuIS Enterprise EDP., it generates a notice showing that the data were loaded.  However, if the EDD is subsequently rolled back (using EDP), the EDD no longer shows up on the "All EDDs" list in EQuIS Enterprise.

The ebatch_rollback procedure was inadvertently deleting the record from st_file_registration during the rollback - which is why the EDD no longer shows up on the "All EDDs" list.  The ebatch_rollback procedure has been modified to skip all st_ tables so the EDD will remain in the list.

NOTE: This fix requires a database update.

9695: Create EPAR4 format file for EDP

Modified EPAR4 format as per EPAR4 specs.  Added enumeration list xsd.

7315: Add User-Role and User-Facility-Subscription to User Management (Add, Edit) page

Create/Edit user pages include an option to assign one or more user roles.

10696: Equis 5 Enterprise "Register New Account"

Comment section has been added to the 'register new account' screen.

5821: Reject a duplicate EDD submittal

Workflow now sends notice "EDD File {EDD File Name} Rejected - Duplicate Submission"

7819: No data check on subfacility

WVDEP modified their XSD such that:

WV_SITE_V2.subsite_id against dt_subfacility and removing the mapping
WV_SITE_V2.site_id a lookup to dt_facility.facility_code and remove the mapping

6669: Edit appearance of Manage Environmental Information Agents page

Added status/remove and create buttons

10071: Implement "Reader" role

Implemented new user role in EQuIS Enterprise es-webapp, "Reader".  This role implements the EZView only features in a site licensed for EIA and EDP.  Members of the Reader Role may access My Notices, a limited Dashboard, Facility Manager, Build Reports, and Pick Reports.

MSSQL Server schema for this release does not include data to implement role.  Database Administrators wishing to implement reader role should a add record to table st_role. 
Insert into st_role (role_id,role_name) values (3, 'Reader');

10695: EQ 5 Enterprise user information

Additional user information now stored and visible on User - Edit page, including first and Last name.

7023: es-reports URL is hard-coded to http://localhost/es-reports/...

Case 7023:  es-reports URL is no longer hard-coded as http://localhost/es-reports/

The URL for es-reports used by es-webapp is now configurable by the system administrator.  Versions prior to es-webapp 2.0 must edit the configuration file WEB-INF/web.xml and alter the value of env-entry reportServerUrl.  Starting with release 2.0 this string is configurable on the setup.jsp administration form.  The es-webapp context must be reloaded or restarted for the change to take effect.

5816: New agent name should default to pick report name

When a new EIA is created, the name of the Agent is defaulted to pick report name.

9906: Add Related Table - parent table

In addition to browsing related child tables, you can now also browse related parent tables.

9898: Dashboard lists reports for all facilities

Dashboard will now display Notices and Reports for the 'current' facility rather than for all facilities at once.

10803: Removing a table from the workspace causes an error when you've added a child table and a grandchild table

You can now successfully remove a table from the workspace (by right-clicking on the table name and selecting "Remove Item") even if multiple generations of related tables have been added to that table.

10664: Error when removing item from workspace

If you open a data table in EQuIS 5 Professional, then remove the table from the workspace, and error would occur.  This error would only occur if you tried to remove the table from the workspace after using the "Find/Replace All" tool on that table.

This issue has been resolved - you can now successfully remove a table from the workspace even after using the "Find/Replace All" tool.

9527: UpdateOracle revisions

Client reported an error in the Oracle migrate scripts.  An alter table statement was executed in the context of the service account.

There are two issues that were resolved:
1. Fixed the 2.0.5 distribution to prevent this error from occurring again.
2. Revise the Oracle scripts so that client DBAs need only choose between new install or migrate existing install.  The goal here is for the CreateOracle script and MigrateOracle script to call the same component scripts as necessary. 

CreateOracle will call create scripts then call all /migrate/ scripts to apply subsequent updates to the schema until it's up to date.

MigrateOracle will examine the database schema and call /migrate/ scripts as necessary to bring a database up to date.  Early releases of Enterprise did not utilize the st_version table so we'll need to examine the schema directly.  Starting with 2.0.5, updates will be logged to st_version and the contents of that table will be used by MigrateOracle to apply updates.

10270: Related Tables: Top-level rows won't expand after adding grandchild table

If you used "Add Related Tables" to add a child table, followed by a grand-child table, the rows in the original table would no longer expand.  This has been resolved.

9905: ReportGrid: Add-Related Table: drop-downs, column info on child tables

When adding a related child table, the column drop-downs and header information (required fields, etc.) was not being displayed.  This issue has been resolved so the child tables are now displayed as expected.

6022: Client Accounts/ Client Management

Removed reference to depreciated 'Client ID' data field in Administrators 'Edit User' and 'Edit Facility' forms

10973: Facility groups not working in enterprise

An error was received while creating facility groups.  Updated files resolved the error.

8345: JDBC Not Resolving host names

JDBC connection for MS SQL Server and Oracle now correctly resolved database host by IP, localhost, or fully qualified domain name.

8347: java.io.FileNotFoundException: ..\logs\webapp.log

resolved configuration error in ./WEB-INF/classes/log4j.xml that prevented the Tomcat application log for es-webapp from being created.

10215: Manage Facility Paging error

An error was reported when managing facilities in an Oracle database containing over 100 facilities. Enterprise now correctly handles over 100 facilities ( > 2 * 'Report Result Page Size' )

8364: Create New Report Agent Error - Oracle

Error message no longer appears when creating new EIA in EQuIS 5 Enterprise for Oracle.

8363: Dashboard does not display reports

Fixed an error in the dashboard reports section that prevented publication of reports for facilities other that facility_id=1

8377: Invalid Date Format '$select'

The message "Invalid Date Format '$select'" no longer appears when using the calendar button (during the creation or edit of a report) to set the value of a date parameter.

7459: Agents fail in MSSQL

Resolved syntax error causing Information Agents associated with the arrival of a new EDD to appear to hang in MS SQL Server.

9423: Preferences page - HTML Form mismatch

User preferences form was limiting input for password, email and ftp address to string lengths less than allowed in the database schema.  HTML Form field maxlength attributes now match database schema.

9425: Pick Reports - HTML form mismatch

Fixed error that occurred when editing the report name of a pick report to be longer than the 64 character limit imposed by the database

9419: Sign In page - HTML Form mismatch

es-webapp login form fields limited input to string lengths shorter than allowed in the database schema.  Form input field maxlength attribute now matches database schema.

9420: Register New Account - HTML Form mismatch

User registration form allows Username, Email, and Password string lengths to match database field lengths. Previously the fields limited strings shorter than allowed in the schema.
Correct field lengths are:
Username 128 characters
email_address 100 characters
password 64 characters

9421: My Notices - filter problems

Search results are returned for only non-archived records when 'show archive' box is checked. Search string (and resulting record set) now remains intact regardless of sorting or paging through results.

9422: All Notices - filter problems

The search filter results will now persist while changing the sort order or while paging.

7026: Activation and role assignment Notification

Notifications for EQuIS 5 Enterprise user registration are delivered to user defined in 'Admin Name' column for 'Email Delivery Service'.

10651: Remove "verify.valid-package" notice from EarthSoft.Workflow.Clients.Default.dll

EQuIS 5 Enterprise is no longer sending out notices regarding EDDs being received/processed prior to the final accept/reject notice.

9563: Show Table, Facility, and Database options for views

The following three display options were added to Views:

Table
Table (All rows in facility)
Table (All rows in database)

9564: Locations from all facilities passed to GIS

When viewing locations in ArcGIS, all locations in the database were being displayed.  With this release, only the locations for the selected facility are displayed.

9875: Various problems in Group Maintenance grids

Resolved error when double clicking group members. Can now add group members using drag and drop from available member list (or right click menu).

11146: EIA: Push reports selecting data for wrong facility.

Some push reports were selecting data for the wrong facility.  This issue has been resolved - so the push reports now select data for the proper facility.

10800: Column Chooser menu needs to be combined with existing context menu

Added "Column Chooser" to the existing context menu and also added it to the package tab.

10913: Error on .klm and .shp files

If running against Oracle, the user would get an exception:

System.FormatException: Input string was not in a correct format.

When trying to view a database report as *.klm (Google Earth) or .shp (Shapefile). This issue has been resolved.

10726: Report_Result_Text Not Exported to Excel as A Text Field

The Crosstab tool in EQuIS 5 Professional now exports the report_result_text records as text.

10773: Crosstab Date/Time format

New functionality has been added so that when a real time value is included in a date/time field (i.e. it is not the default "12:00:00 AM"), then this time is included in the Crosstab and when exporting to Excel.

10910: Open All Tables in Database Issue Revisited!

The select 'Table: All Rows in Database' was not returning all rows in the database.  This has been fixed. 

11360: Implement warnings in EDP

Warning message for negative result value added to EZEDD

11286: Data specific error messages

Functionality has been added to EDP so custom handlers can optionally create data-specific error messages.  For example, the error message could contain the actual data value causing the error.  This is done by passing the row and column to the custom handler and letting it construct a customized error message.

These customized error messages will be displayed to the user as tool tips in EDP, as well as in the error log.

10999: Show the correct version of the application

es-webapp displays the correct software version on Welcome, Home, and Error pages.

11441: Error with several EDP formats using EQ5 Pro 2.1.1.34 install

Resolved error with formats.  The custom handler needs to be recompiled if the EDP code changes.  All formats have been recompiles and are working as expected

11359: Recompile the custom handler if the EDP code has changed

Prior to this case, the EDP custom handler was only recompiled if the .vb file itself had changed.  Now the code will check the .vb file but it will also check the EarthSoft.EDP.dll.  If either of those are newer, then the custom handler will be recompiled (i.e. a new format.dll in the temp folder).

11280: R4 coordinate data truncated

Resolved issue with coordinates being truncated in ArcGIS

9487: Ent 2.0 Home Page not role compliant

Access to upload EDDs is now limited to members of the USER role.  This is in compliance to the Enterprise Workflow logic which limits processing of EDDs to members of the USER role.

Members of the MANAGER role have access to the All EDDs page.  Members of the Admin role do not have access to the EDD pages.

11139: EQuIS 5 Enterprise - My Notices page, Archived records issues

Added ability to view all records, archived or unachieved at once. When "Show Archive" > Refresh is selected, archived records are shown in blue shading.

11495: Scrolling through the facility list automatically opens selected facility

Double-clicking the scroll bar while selecting a facility would automatically open whichever facility was currently selected in the tree.  This has been resolved so double-clicking the scrollbar will not automatically select a facility.

9834: Loading an .xls then saving as a .zip does not save correctly

Corrected 'Sign and Submit' functionality so that data files within .zip are delimited appropriately.

10635: Enterprise preferences prompts are off by one row

Resolved display anomaly in User Preferences page.

9239: EFWEDD-creating lab_samples in the field_sample table. Hartford Database

The EFWEDD 4 file format was incorrectly populating both the dt_field_sample and dt_sample table for all samples including lab samples.  The logic was changed so that it is consistent with the logic in the EQuIS 3 product.

The code looks at the sample_type_code listed in the data, then take the sample_type_class for the sample_type_code listed.  So if the data lists a sample_type_code = "N" then the code looks up the sampl_type_class which would equal "NF", that value determines how to populate the tables.

10681: EPAR5 enumeration file

Created an enumeration list for the EPAR5 format.

9657: ESBasic.EDD historical input - total v dissolved

(1) add fraction to the end of the ESBasic format and the field defaults to "N"
(2) added sample_souce to the format and the field defaults to "Field"

11345: Export to Excel makes Temp Folder - Would like Option to select export location

When exporting a grid from EQuIS Professional to Microsoft Excel, the *.xls file was automatically created in the user's temporary folder using a default file name. 

Now the user will be prompted to choose a path and filename where the file will be stored.  The default path will be in the user's working folder for the current facility.

9200: Equis 5 GeoSampleParameter import update request

Added measurement_date to GeologyEDD.GeoSampleParameter format in EDP

9341: Request to Add "connectionOptions" to EQuIS.exe.config File

The EQuIS.exe.config file now has an additional property called connectionOptions.  By default this value is empty, but individual users can customize this value to control specific options of the database connection that is used within EQuIS.  For example, a client who frequently gets "timeout" errors while connecting to a SQL Server database may use:

    <add key="connectionOptions" value="Connection Timeout=300;" />

To increase the timeout value (and reduce/eliminate the timeout errors). 

11055: Create Excel charts with Syncfusion instead of Excel automation

Improved performance when exporting charts to Excel

11342: EIA: Have the report attachment named after the agent, not the report name.

In previous versions of EQuIS Enterprise, the automated reports (produced by EIA) were named after the original report name (i.e. "analytical_results_20060612.pdf").  This led to confusion because the user could not easily decipher what the report actually contained (i.e. which Environmental Information Agent generated the report).

Now the reports are named after the agent instead of the original report name.  In addition, the text of the email containing the automated report is configurable in Notification.xml.

11840: EPAR5 Format loading problem with EQ5 Pro

The EPAR5 format now includes a separate enumeration list file (EPAR5-enum.xsd) which gets installed with release 2.2.2.52

11554: Exception occurs during "Create" if the format has no custom handler

For EDP formats without a custom handler (such as the WaterLevel format), the "Create" step in EDP causes an error. 

This issue has been resolved and the "Create" step works as expected.

11555: Trendplots ignoring NULL y values

When creating a trend plot in EQuIS 5 Professional, any null "Y" values were being ignored.  A null value is actually meaningful in a trendplot (a gap in the trendline).  This issue has been resolved and the null "Y" values are no longer ignored (the trendline will show a gap for null Y values).

11136: EQuIS 5 Enterprise - User options

Assignment of users to facilities may now be performed from the Edit User Profile page by members of the Admin role.

12193: EarthSoft.style not working correctly when you start ArcMAP from within Pro

After first installing EQuIS Professional and starting ArcMAP from the EQuIS Professional toolbar, symbols were not displaying correctly because the EarthSoft.style (symbols, labels, renderers, etc.) file was not correctly copied into the appropriate ArcGIS \Styles folder.

EQuIS Professional will check (upon clicking the ArcMAP button) to see whether the EarthSoft.style file exists in the ArcGIS \Styles folder.  If it does not, it will be copied into the \Styles folder so the symbols display correctly.

12137: ArcGIS - RockWorks Interface

Resolved issues with creating 3D cross-sections in both Oracle and SQL Server

8735: EFWEDD Format - Preservative Field

The preservative field was changed from text 50 to text = 20.

11715: EZEDD add defaults same as in EQ3 format

This format is mapped to EQuIS 3 and EQuIS 5.

The following defaults exist in the EQuIS3 format:
Test_Batch_Type = PREP
Test_Type = Initial
Reportable_Result = Yes
organic_yn = Y
Column_Number = NA

There are other defaults listed but they are all fields available in the format.  So they will not be defaulted here.

9278: Need to remove enumeration list from EPAR5.xse

The EPAR5.xse included an enumeration list for the qualifier fields, so the RVF file was not utilized.  The reference to the enumeration list was removed from the EPAR5.xse file.

12161: ArcGIS EZView Save pick report Error: "Failed to Convert Parameter Value..."

Resolved error message'ArcGISSavePickReportError.jpg' that was displayed when clicking the save icon next to the pick report name.

11551: ArcGIS EZView

Issue with exporting EZView query results using the 'database connection' option resolved.

9160: LicenseException on exhausted network licenses

When all network licenses are in use, EQuIS Professional now displays a registration dialog with the message:

"All concurrent licenses are in use, please contact sales@earthsoft.com to purchase additional licenses."

12129: Labels in ArcGIS Interface - Pie Charts

To create labels for Pie Charts in the EQuIS 5 for ArcGIS interface follow these steps:

1.  EQuIS > EZView > Other (Users will receive an error that may be ignored 'The module was expected to contain....')
2.  Run the Analytical Results (Aggregate) (or other report as desired) > Select 'Go'
3.  Select the CrossTab button
          Column Header: Chemical Name
          Row Header: X_coord, Y_coord, Sys_Loc_Code, unit, and other as desired
          Tabbed Data: Report_Result_Numeric (Or other as desired)
          Row: Chemical Name
4.  Select 'Open in ArcGIS' after crosstabbed (appears on right side of crosstabbed data)
5.  Close the original query window > Pie Charts are added
6.  Use Feature Selector and select one location
7.  Right Click on feature > Select Project View
8.  Right Click on layer name and select 'Label'

11537: Subfacility Groups Don't Go From Enterprise to Professional

When a facility sub-group was created using EQuIS Enterprise, that sub-group did not show up when using EQuIS Professional.  This issue has been resolved so sub-groups created in EQuIS Enterprise will now show up as expected in EQuIS Professional.

10827: EQuIS.AutoUpdate error when using support.earthsoft.com/equis

Auto update corrected so that all files are updated from remote Folder instead of displaying error. If EQuIS.exe and EQuIS.exe.config are placed into an empty folder and the remote Folder is set correctly, EQuIS.exe will launch and obtain all of the missing files.

10891: Facility Selection screen disappears behind other windows

The facility selection screen now appears in the task bar.  In some cases, this screen was disappearing behind other windows (from other applications).  In the event that other windows hide this screen, the user can simply click the button on the task bar to switch to active this screen.

11291: EFWEDD Format - Subsample Amount Error

The EFWEDD Format was not checking EFW2LabTST sample_amount after an EDD was cleared and re-opened.  The error that should have appeared is 'Subsample_amount and subsample_unit cannot be null when sample_type = N, FD, FR, FS, LR, MS, SD, or MSD.'  This issue has been resolved in the latest release.

9324: Horz axis not correct when trendplots are stacked

Corrected problem that occurred when stacking graphs.
Specifically, when stacking graphs the horizontal axis was not always represented accurately and all series had the same endpoint.  This behavior was corrected to reflect the actual horizontal data value.

11106: rt_qualifier.qualifier in eq5testing

RE: "Case 7365: Change dt_result and rt_qualifier to handle multi-character qualifiers and combined qualifiers."

This feature now implemented when updating an existing EQuIS Schema in Oracle

11726: Column chooser doesn't work with Oracle reports

Trying to use the "Column Chooser" on a report grid from Oracle was causing an error.  This is because the report name (e.g. "reports.analytical_results") contained a period.  The "Column Chooser" misinterprets the period. 

With this release, EQuIS Professional uses the display name (e.g. "Analytical Results") instead of the database object name.  As long as the display name does not contain a period, then the "Column Chooser" now works as expected.

11802: EQuIS ArcGIS Extension Error: On creation of Geodatabase layer from Pick Report

Creation of an EZView layer in the EQuIS for ArcGIS Interface no longer results in an error when selecting export format as 'shapefile'

11553: "DataReader currently open" exception when creating a new database

When creating a new database, an error message would appear stating that a DataReader is currently open for the connection.  The database was still created successfully.

This issue has been resolved and the error message no longer occurs.

11483: .NET code using ArcObjects 9.1 not backwards compatible with 9.0

Previous releases of EQuIS for ArcGIS were not compatible with both ArcGIS 9.1 and ArcGIS 9.0. 

This release of EQuIS for ArcGIS is compatible with ArcGIS 9.1 SP2 and ArcGIS 9.0 SP3 (requires SP3).  In either case, you must install the .NET components of ArcGIS.  If you do not have a folder called "C:\Program Files\ArcGIS\DotNet" containing several .dll files, then you need to install the .NET component of ArcGIS.  This can be done by clicking "Change" in Add/Remove Programs and using the installation wizard to install the .NET component.

9859: LogPlot Create Log - ArcGIS

KNOWN ISSUE:  In the Oracle EQuIS For ArcGIS interface, the LogPlot interface is currently exporting Lithology Data incorrectly. This is a known issue.

9903: ReportGrid: "Add Related Table" should only be visible for tables (not views or reports).

When viewing data and reports in EQuIS Professional, the "Add Related Table" context menu is only applicable to tables (not views or reports).  The "Add Related Table" context menu is now only visible for tables.

9812: Make web app work with SQL Server 2005

We changed the webapp so it uses the JDBC driver.  We also removed the non-ANSI outer join syntax.  It now works with both SQL Server 2000 and SQL Server 2005.