Home : Release Notes - Hach WIMS Server Setup for Microsoft SQL
Q10019 - INFO: Release Notes - Hach WIMS Server Setup for Microsoft SQL

Version 8.2.4 (Pending)

  • Fixed: Complete support for user set OPSDBA Password

Version 8.0.8 (Released Oct 11th, 2021)

Version 8.0.0 (Released May 18th 2021)

  • Ability to restore SQL Server backup files(.bak) added.
  • Now uses Spread 8 control

Version 7.8.2 (Released March 27th 2020)

  • Enforce business rules for facility Unique ID.  Only Alpha characters and numbers allowed.  24 max.

Version 7.7.6 (Released May 29th 2019)

  • Updated some messages from OPS to WIMS. 

Version 7.7.2 (Released Sept 5th 2018)

  • Update for 7.7.2

Version 7.7.0 (Released Jan 29th, 2018)

  • Added support for Microsoft SQL Server 2017

Version 7.6.6 (Released 7/10/2017)

  • Added support for Microsoft SQL Server 2016.

Version 7.6.4 (Build 459, Released on 3/30/2016)

  • Users receive error "Cannot alter the server role 'processadmin', because it does not exist or you do not have permission" when trying to create a new facility (or import an OPS32 database). Fixed. (4715)

Version 2.3.5 (Build 451, Released on 10/28/2015)

  • Miscellaneous ( 4651, 4652)

Version 2.3.4 (Build 436, Released on 7/8/2015)

  • Miscellaneous ( 4593, 4614)

Version 2.3.3 (Build 385, Released on 9/15/2014)

  • Support for Hach WIMS Database version 1.4.0 (4488)
  • MS SQL Express Data folder now saved to ServerSetup.ini (4475)
  • Removed Upload to OPS Systems FTP Server button as it is no longer used (4366)

Version 2.3.2 (Build 338, Released on 4/16/2013)

  • Fixed a bug within SQL Server setup where the 2012 sa password was not accepted for database management such as update/restore (4312)

Version 2.3.1 (Build 337, Released on 5/7/2012)

  • Added Support for MS SQL 2012 DB Support (4195)

Version 2.2.2 (Build 333, Released on 3/27/2012)

  • Support for Hach WIMS Database Version 1.3.9
  • Fixed issue. It now will import large comments when upgrading a OPS32 database.

Version 2.2.0 (Build 330, Released on 5/23/2011)

  • Support for Hach WIMS Database Version 1.3.9
  • Fixed issue. Now cleans up appropiate tables when removing a facility. (2743)

Version 2.1.0 (Build 306, Released on 7/30/2010)

  • Support for Hach WIMS Database version 1.3.8
  • All new facility databases as well as new OPSROOT are created using Simple Recovery Model (3117)

Version 2.0.6 (Build 290, Released on 8/28/2009)

  • The CALCERRORLOG table is now truncated during DB upgrades (2929)
  • OPSSQL Spread reports with prompts that have NULL default values are now properly imported (2881)

Version 2.0.5 (Build 179, Released on 5/5/2009)

  • Fixed "Error 400 - Form already displayed - cant show modally" error that sometimes happened during a database restore (2516)
  • Fixed issue with text boxes for the username and password being incorrectly limited to 12 ad 15 characters, respectively. (2542)
  • Server setup now will change the sa user password at login if necessary to reflect move to SQL Server 2005 express (2545)

Version 2.0.4 (Build 172, Released on 4/14/2009)

  • Fixed a bug that caused ss3 files to be stored in OPSROOT instead of facility database when importing OPS 32 facilities (2500)
  • Fixed a bug that caused crash when clicking on "Change SQL Server 2005 Express Data Dir" button when using restore console (2484)

Version 2.0.2 (Build 168, Released on 4/1/2009)

  • Fixed a bug when restoring database backups due to SQL Server data directory path issues (2464)
  • Fixed bugs where incorrect an SA password was used with the SQL Server Express instance when restoring backups (2465)

Version 2.0.1 (Build 161, Released on 3/12/2009)

  • Added support for silentUpgrade.exe and for more than 99 multi-part RAR files upload (2414)

Version 2.0.0 (Build 160, Released on 2/10/2009)

  • Added support for Microsoft SQL Server 2008
  • Now contains Database upgrade fuctionality, which was removed from Hach WIMS Client
  • Support for Hach WIMS Database version 1.3.7 (Version 1.4.4 was the last one to be called OPS SQL Server Setup. It is now called Hach WIMS Server Setup for Microsoft SQL.)

Version 1.4.4 (Released on 11/27/2007)

  • Fixed a bug in import from OPS 32 that occured in DRG conversion when a name of the report was longer than the maximum number of characters for a report name and was reported as Multi-step operation generated errors (1379)

Version 1.4.3 (Released on 11/14/2007)

  • Added ability to import data records in a specified date range in MSSQL version. Go to Advanced Options under Import from OPS32 (1192)
  • Added ability to import data records without importing the first Audit Trail record, thus saving 1/2 of space requirement in Express and Lite editions. Go to
  • Advanced Options under Import from OPS32 (1193)
  • Import from OPS32 no longer imports orphaned data records, thus saving space in target OPS SQL databases (1195)
  • Fixed a bug in OPS32 import that caused Server Setup to crash when TimeOfDay field of the 15 minute data contained incorrectly formatted time (1163)
  • Fixed a bug in OPS32 import that caused Server Setup to crash when AuditUser data was more than 12 characters long (1239)
  • Fixed a bug that caused the ROUND Math Toolbox Function to be imported incorrectly (1162)

Version 1.4.0 (Released on 5/23/2007)

  • Application now supports upload of patches to database for all OPS SQL services (829)(831)
  • Fixed a bug that caused invalid equation translations when importing from OPS32 equations that were not supported in Server Setup at the time of Database version 1.1.5. Used to be translated to BLANK, now transated to SKIP. (424)
  • Added support for Database Version 1.3.4

Version 1.3.2 (Released on 1/11/2007)

  • Added a special FIX/iFIX interface structure definition on the MSSQL/MSDE side (525)
  • No change for the Oracle version.

Version 1.3.1 (Released on 11/16/2006)

  • Fixed a bug that misreported facility Unique Identifiers for environments with more than 100 active facilities (390)
  • Facilities are now shown in alphabetical order.

Version 1.3.0 (Released on 10/31/2006)

  • Restore Console now allows one-click database restore. This feature is will only work on Express and Lite editions. You also must be running Server Setup on the same computer as is running your MSDE OPSSQL database. (245)
  • Restore Console also allows you to one-click upload of an opssql_backup file onto the OPS Systems FTP site.
  • Added a way to change facility name. Available in MSSQL/MSDE version.
  • No change for the Oracle version.

Version 1.2.7 (Released on 10/9/2006)

  • Fixed a bug that occured in rare situations when importing OPS32 records from the GraphSample table

Version 1.2.5 (Released on 8/11/2006)

  • Support for Microsoft SQL Server 2005

Version 1.2.3 (Released on 5/6/2005)

  • Import of OPS 32 databases now handles Null values in the data table better
  • Import of OPS 32 databases now handles import of invalid Historical equations

Version 1.2.2 (Released on 1/27/2005)

  • Symbols are not added to the OPSROOT.SYMBOL table when importing an OPS 32 database.
  • OPS 32 databases with ShortNames (Headings) longer than 12 characters now works correctly.
  • Program now appears in Status Bar when running.

Version 1.2.1 (Released on 9/10/2004)

  • Import from OPS32 Version 3x.  No longer supports import from 2x databases.
  • Additional table added to create the ability to import from any 3x database.

Version 1.1.2 (Released on 10/10/2003)

  • Database vs. Application version check has been removed.
  • Import of OPS32 Hourly Data has been optimized.

Version 1.1.1 (Released on 04/04/2003)

  • Now fully supporting Microsoft SQL 2000 in addition to Oracle.
  • Users can upload client upgrades even if the server setup application and database version do not match.
  • Users can enable/disable client logins.
  • Minor bug fixes.

Version 1.1.0 (Released on 11/25/2002)

  • Minor bug fixes.

Version 1.0.8 (Released on 8/20/2002)

  • Application can now only manage OPS SQL databases that has the same version as the application.
  • Upload Client now detects the version of the client being uploaded.

Version 1.0.7 (Released on 7/31/2002)

  • 'Remove from List' Action button was added.
  • Updated OPS SQL facility structures.
  • A new performance boost added (Automatic update done by Client version 5.0.7).

Version 1.0.2 (Released on 7/11/2002)

  • OPS32 security import now includes facility access import
Related Articles
Q10018 - INFO: Release Notes - Hach WIMS Client
Q10020 - INFO: Release Notes - Hach WIMS AdoCalc

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 12/16/2003 12:46 PM.
Last Modified on 12/20/2023 7:21 AM.
Last Modified by Steve Fifer.
Article has been viewed 21718 times.
Rated 6 out of 10 based on 11 votes.
Print Article
Email Article