Professional – Fixed Database Update Errors in Log Files [d55126]
Fixed a bug that resulted in errors being added to the equisdebug.log file and the database being corrupted even though the database update process appeared to complete successfully. The errors added in the log file that signified the database was not updated successfully were:
- "Unable to obtain a valid Sequence. No matching column"
- "Violation of PRIMARY KEY ... Cannot insert ... in object 'dbo.st_module'. The ... value is (-1)."
Professional – Fixed Wrong Database Used for Sequence Dictionary Issue [d55284]
Fixed a bug that, following upgrades, could display the error "Unable to obtain a valid Sequence. No matching column" when attempting to add EUID-based records if there were multiple databases on the same server with differing properties or builds.
Professional – Login to Enterprise When Redirect Occurs [d55863]
Fixed an issue in Professional where sign in would fail for Enterprise sites with a redirect enabled.
Professional – Unable to Reset Filters in Report Parameter Input Pane [d55830]
Fixed an issue in the Report Parameter Input Pane in Professional where removing a filter would not display the complete list of parameter options after filtering the list twice.
Reports – Action Level Exceedance II – Unit Conversions Not Accurate when No Unit Selected in Parameters [d56154]
Fixed a unit conversion issue for the action level(s) in the Action Level Exceedance II reports (EarthSoft.Reports.Library.51729.dll) that occurred when using a Unit Conversion Formula in the RT_UNIT_CONVERSION_FACTOR table and the report unit was not specified in the report input parameters. The fix applies to all reports in the file:
- Action Level Exceedance II with Parameters
- Action Level Exceedance II by User Report
- Action Level Exceedance II by EDD
- Action Level Exceedance II - Early Warning
- Action Level Exceedance II - Percent Variance
Reports – Analytical Results Trend Plot (Time Series) – Use Water Levels II Instead of v54.water_level [d53484]
Updated the Analytical Results Trend Plot (Time Series) report to use the Water Levels II report instead of the deprecated Water Levels report (the v54.water_level function report from the StandardReports Schema).
Reports – Downhole Point Parameters – Fixed Slow Database Performance [d55684]
Fixed an issue that caused slow report performance in the Downhole Point Parameters report when the connected database was set to a compatibility level of 140 or greater.
Republish the report assembly (EarthSoft.Reports.Library.43582.dll), if already published, following these instructions: Republishing Reports.
Reports – Publishing – Dependent Crosstab and RDL Reports Updated with Incorrect Report Parameters when Republishing [d58892]
Fixed an issue where republishing a report updated dependent reports with incorrect report parameters. Now, only new report parameters are added after republishing. Dependent user reports will not have new parameters added.
Reports – VLA (PPU) Usage Report – Template Updates [d56744]
The VLA - PPU Report (EarthSoft.Reports.Library.73174.dll) was updated as following:
- The report template was updated.
- The 'Billing Months' and 'Hosting Environment' parameters were removed.
NOTE: The report will need republishing.
Reports – Water Levels II – Fixed "loc_group" Column Issue [d55661]
Fixed the following issues in the Water Levels II report:
- Selecting a location group in the report parameters caused the "loc_group" report column to be empty.
- Report data was prevented from being returned when Subfacility was used as the Location Group.
Reports – Water Levels II – No Results for Facility Group with Task Code/Location/Location Group Selected [d55537]
Fixed an issue in the Water Levels II report where no results were returned when logged into a facility
group and a location, location group, and/or task code were selected.
Schema – Professional – Add Timezone Column to DT_FACILITY with Foreign Key to RT_TIMEZONE.TIMEZONE_CODE [d55955]
Added new field DT_FACILITY.TIMEZONE_CODE that is referenced to RT_TIMEZONE.TIMEZONE_CODE. The field data type is varchar (40).