Version 4.2.12 o Added - Redundancy option to keep projects warm - avoids unnecessary OPC subscribes/unsubscribes that cause problems on some servers. o Fixed - Manually configured remote opc servers showing up under every remote host instead of just the local list. o Fixed - More explicit object disposal while working with internal databases in order to reduce locking issues. o Fixed - Problem with delayed alerts occasionally causing non-delayed messages to block. o Fixed - Incorrect syntax in Oracle translator for more than one column modification. o Fixed - Digital "alert on change" mode not present in CSV export. Version 4.2.11 o Fixed - Async writes to opc servers failing while using polled reads. o Fixed - In rare cases calculating tag hash causes overflow exception leading to bad SQLTag quality. o Fixed - When using the same tag in both a polled read and normal subscription group, the tag in subscription group may only update according to the polled reads. o Fixed - CSV import not reading all analog alert states on items. o Fixed - Folder naming/number incrementing now smarter - previously creating incorrect folder names for names with padded numbers. o Fixed - 'Prevent trigger caused by group start'not being included in CSV import/export. o Changed - Action items that target OPC items writing individually, changed to write in array in order to improve performance. Version 4.2.10 o Fixed - Polled read option with DA2 servers creating unnecessary subscription, leads to incorrect error detection. o Fixed - Block group CSV export not including action item data type, writeback path. o Fixed - CSV export missing failure handshake settings. o Fixed - Progress screen during save occasionally stays open. o Added - new expression functions for retrieving data cache row count. Version 4.2.9 o Fixed - Available DSNs for ODBC connections aren't populated from remote service. o Fixed - Frontend errors not logging to internal database correctly. o Fixed - Relative tag paths not always resolving correctly in SQLTag references. o Fixed - Inefficiency in OPC subscription system causing SQLTags systems with many tags to load slowly. o Fixed - SQLTags evaluating alerts on external tags (tags executed by other FSQL instances) when it shouldn't, leading to multiple log entries. o Fixed - Copy/Paste Alert settings menu items not working correctly. o Changed - thread synchonization on startup dialog potentially causing critical error. o changed - MySQL db definition file now uses "CURRENT_TIMESTAMP" instead of "now()" in order to be closer to the standard. Version 4.2.8 o Added - New trigger option to prevent execution caused by group startup. o Changed - Block group table will now be created with an index on block id. o Changed - External & DBStatic SQLTags now read current data quality, though dbtags are always "good". o Fixed - Problem with Windows event log source naming causing tray application to quit unexpectedly on some systems. o Fixed - Syntax errors in distribution list group expressions cause alert email send to fail. o Fixed - Distribution group expressions not receiving database connection reference (for use with database expression functions). o Fixed - Some group settings lost after editing program setting with group selected. o Fixed - OPC server monitoring system errors out if internal server object has been removed by a different mechanism (instead of detecting server failure). o Fixed - Scaled items not scaling value when quality is bad. Version 4.2.7 o Fixed - Analog alert configuration screen being cut off in GUI. o Fixed - Buffered writing settings not being saved/loaded correctly on Service Settings screen. o Added - New SQLServer 2005 database translator which should make it easier to connect to some configurations of SQLServer. Version 4.2.6 o Added - New audio alert feature. o Added - Email alert send delay. o Added - Item up/down buttons to explicit segment editor for block group items. o Fixed - DB connection status screen now shows current primary for aggregate connection. o Fixed - Block group CSV not exporting "item property" setting. o Fixed - CSV import doesn't work after opening file in OpenOffice Calc. o Fixed - Time negotiation problem in buffered write system causing incorrect timestamps to be stored in certain cases. o Fixed - Error writing strings when using buffered writing on SQL Server "Non variable strings must have a length" o Fixed - Selecting multiple groups with triggers set causes loss of setting. o Fixed - In redundant setup, SQLTags system often fails to initialize with the message "database connection not available". Version 4.2.5 o Fixed - Failure to re-add OPC item subscriptions after reconnect in the case of error while creating opc subscription. o Fixed - SQLTag alarm point references not proactively executing referenced tags. o Fixed - Occasional 'collection modified' error while loading SQLTag config changes. o Fixed - Cast exception when multiplying multiple Int2 values in action items. o Fixed - Switch function not coercing data types correctly, required manual cast. Version 4.2.4 o Added - ToChar function to base library. o Fixed - Errors executing SQLTags occasionally causing entire scan class to fail. o Fixed - Hardware activation key occasionally reporting "feature not found". Version 4.2.3 o Added - Ability to start groups when table cannot be verified. o Fixed - Problems with cached project after starting redundancy with db connection down. o Fixed - "Redundant Project Empty" dialog occasionally shown when the project isn't actually empty. o Fixed - Changing the prefered database translator doesn't immediately take effect. o Fixed - Non 0 alert deadband causing problems for some digital alerts. o Fixed - Problems with booleans and Postgres connector/ ODBC connector. o Fixed - Config change count on SQLTags status window not accurate. o Fixed - Block group set to insert with quality code option always writes quality of 0. Version 4.2.2 - Internal Release Version 4.2.1 o Fixed - Cast error while executing SQLTags expression objects. o Changed - SQLTag's scan classes now report errors to the FSQL error log. o Changed - Parameterized statements use up-converted data types instead of unsigned types- uint2->int4, uint4->int8. Version 4.2.0 o Added - New "database" scripting functions: IsConnectionAvailable, ExecuteScalarQuery, ExecuteUpdateQuery, ExecuteQuery, GetDataSetValue... o Added - New "failure" handshake option, writes to OPC after group execution failure. o Added - Advanced group options: synchronous read from OPC instead of subscribe (available for Standard, Historical, and Stored Procedure groups). o Added - New buffered data writing option. Writes to buffer instead of directly to database- very useful for data connections that can go down (works well with data cache to prevent data loss) and for short-term quick logging. o Added - Existing database table columns detected, field name entry on item configuration is now a drop-down, autocomplete combo box. o Changed - Buffered logging always enabled for Historical group, advanced option for standard group. o Changed - Improved table/procedure listing algorithm. o Changed - Async OPC writing now the default for new installations. o Changed - Standard/Historical groups now use parameterized statements against the DB. o Changed - Now possible to start groups when db connection is unavailable. o Fixed - Many improvements to datacache system: o Better threading, lots of data in cache no longer causes service to start slowly. o Automatic periodic database checking, data loading (earlier versions only checked on certain events). o New "quarantined" data facility to handle queries that error out on load. o Improved system status screen, with facilities for deleting cached & quarantined data, as well as viewing errors. o Fixed - Subscribing to OPC value, quality, timestamp causing multiple item subscriptions on server. o Fixed - Expression function menu now alphabetized. o Fixed - Analog alert deadbands not working correctly. o Fixed - Error writing alert to database in certain cases. o Fixed - Postgres DB translator file missing 'characters to escape' field. Version 4.1.5 - 2/22/2008 o Added - Option to use OPC Async writes, ability to specify write timeout. o Added - Additional execution status information to group status tab. o Added - 'Tools' menu with item for DB Query Browser. o Added - DateDiff & DateArithmatic functions to base library. o Improved - Error log viewer now supports collapsing & categorizing events. o Fixed - Occasional errors writing booleans to database (primarily through alert log & action items). o Fixed - Query Execution window not always saving settings. o Fixed - Data type conversion in expression language not correct for floats, shorts (requiring explicit cast). o Fixed - Error creating new block group item from menu bar. o Fixed - Group messages on status tab not always clearing when switching between groups. o Fixed - XOR not appearing on right-click menu for action item expressions. o Fixed - DB Query Browser not refreshing tables correctly after changing selected connection. o Fixed - Historical groups not pasting correctly. o Fixed - Incorrect datatype in Oracle definition file for long integer. o Fixed - 'Decimal' datatypes returned from database drivers causing problems with block & bi-directional groups. o Fixed - Problems resetting event meters and non-retentive hour meters from database. o Fixed - 'Write to OPC' disable incorrectly on stored procedure group when logging. o Changed - Division operation in expression language now converts inputs to doubles, preventing accidental integer division. o Changed - For data integrity reasons, intersections of alert states are no longer editable. Verison 4.1.4 - 2/5/2008 o Fixed - Stored procedure group CSV export not correct. o Fixed - Invalid reference in group WHERE clause causes group start to fail in other modes. o Fixed - Intersection of groups with identical trigger items causes item to be set to NULL. o Fixed - Removed optimization causing numbers to be rounded. o Fixed - Dependency system not tracking item name changes inside of where clause, action items. o Fixed - Error on starting groups with items going against unsigned MySQL columns. o Fixed - SQLTags incompatibility with MySQL ODBC. o Fixed - SQLTags: Scan classes not being properly de-registered after deletion. o Changed - "Delete Old Records" function significantly modified for performance. o Changed - New version of MySQL connector included, fixes deadlock issue. Version 4.1.3 o Fixed - Alerting in SQLTags not working correctly. o Fixed - "File Locked" errors on system restore. o Fixed - System backup will now add file path automatically if not specified. o Fixed - Default alert message not correctly including item value. o Fixed - CSV import not working correctly for multiple explicit segments in a block group. o Changed - Default alert message now shows whether it is an active/clear message (previously only shown in subject). o Added - Alert option to enable/disable messages from being send on the initial state. Version 4.1.2 o Fixed - Tag references not updating correctly in expression SQLTags. o Fixed - DBStatic tag values not being read with config change. o Fixed - "Syntax Error" loading some data from datacache. Version 4.1.1 o Fixed - Type conversion error with SQLTags and MS SQL server. o Fixed - Performance problem with scan classes set to 0ms execution. o Fixed - Folders occasionally showing incorrect logging status in frontend. Version 4.1.0 o Fixed - Now supports 64-bit .NET Framework/ 64-bit Windows. o Changed - New version of the MySQL connector included. "ResetPooledConnections" and "CacheServerConfig" parameters no longer supported, FactorySQL will remove them from existing connections on startup. o Added - Oracle, Postgres support in SQLTags. o Added - New Historical group. o Added - Ability to subscribe to basic opc properties. o Added - Hardware based activation support (using HASP key). o Added - Auto project backups before restore operations. o Added - Block group accessory items can now write to the database. o Added/Modified - New features for the db query browser. o Added - Modifications to db translator files no longer require restarting the service. o Added - Redundancy Setup dialog. o Fixed - Error with Oracle and prepared statements in transactions. Known Issues: ------------- -Hasp activation currently not available under 64-bit Windows. Version 4.0.5 o Fixed - Changing OPC Sqltag datatype not triggering re-subscription. o Fixed - Some default values in sqltags don't match PMI defaults. Version 4.0.4 o FIXED - Standard groups not subscribing OPC items at correct rate. o Fixed - Async trigger settings not properly triggering on standard and block groups. o Fixed - Trigger item list not refreshing automatically when items are modified. Version 4.0.3 o Fixed - Accessory items not showing up in handshake list of block groups. o Fixed - 'Previous value' not storing correctly in legacy alert log. o Modified - OPC write mechanism changed- multiple writes to the same point in the same scan cycle will all be executed (with a max of 10). o Fixed - External and DB tag SQLTags values occasionally being overwritten. o Added - Point Path to alert status table. NOTE: users should clean (delete all rows) the alert status table so that FSQL will re-create the points with all of the information. o Added - Query browser now remembers height, width, limit and auto apply settings. Version 4.1.0 o Added - Historical group o Added - DB Translators automatically reload when files are modified- FSQL restart no longer required. Version 4.0.2 o Fixed - DB Translator override not accurately changing connection string. o Fixed - Action item type override not appropriately affecting database column creation. o Fixed - Search & Replace not properly searching in various scenarios. Version 4.0.1 - 10/15/2007 o Fixed - SQLTags system occasionally doesn't recover from db connection loss. o Fixed - Quality of DB tags not being set to good when demo is reset. o Fixed - Static db tags' values being set to NULL on demo timeout. o Fixed - NULL OPC item path in SQLTag causing multiple tag subscriptions to fail. o Fixed - 'Last Execution Attempt' not updating. o Fixed - Alerting not respecting email severity restriction. o Fixed - Scheduled groups not saving correctly. o Fixed - DB translator override not saving correctly in connection configuration. o Fixed - Action item datatype override not always effective. o Fixed - Problem importing CSV files with extra commas. o Fixed - Importing legacy csv files fails to load OPC items. o Changed - Alerted SQLTag items no longer include '[~]' in the alert log. o Added - "NULL" keyword to expression language. Version 4.0.0 - 10/1/2007 o New - SQLTags system o New - Stored Procedure group. o Modified - Group system, execution engine, OPC subscription system. Version 3.1.6 - 8/29/2007 o Fixed - Bug in execution engine when running/starting many groups. o Fixed - Error when attempting to edit "project" tree node in frontend. Node should not be editable. o Added - Ability to store item paths as a row id in block group. Version 3.1.5 o FIXED - significant bug with execution engine, caused potential delays in executing units. o Fixed - Live values not shown for logging block groups if mode is set to 'insert new block'. o Fixed - Aggregate connection failing on first access after switch over (if failure was reported during connection attempt). o Fixed - Column sorting only sorts asc, does not reverse on second click. o Fixed - Multiple project monitors potentially being created in frontend, affecting redundant project display. o Fixed - Redundant project display: modified group not refreshing display correctly. o Fixed - OPC connection failure potentially handled incorrectly, causing further connection failures. o Fixed - If redundancy is disabled while data connections are operating in reduced state, they will be stuck in reduced state. o Fixed - Problem with alert item intersection resulting in occasional critical error. o Added - Ability to sort OPC browse items. o Added - 'Rename' item to standard group right-click menu o Changed - Action item edit keyboard shortcut now ctrl-enter, instead of enter. o Modified - 0 second opc timeout being allow, preventing server from ever connecting. o Modified - Redundancy: OPC Quality now takes precedence over node rank. Version 3.1.4 o Fixed - Action item positions not being stored correctly for newly created items. o Fixed - Display issue with action items and null values. o Fixed - Problem using DateTime types coming from OPC server. o Fixed - Group setting changes lost after editing db connection, launched from action tab. o Fixed - DB Query browser now shows dates resolved to the second. Version 3.1.3 o Changed - New folders now selected when created. o Added - Ability to manual specify OPC Server CLSIDs. o Fixed - Error occurs after using alert distro list preview, then starting/stopping groups. o Fixed - Various small interoperability issues. Version 3.1.2 o Added - Ability to store row id in block group. o Fixed - Copying block group does not copy accessory items. o Fixed - If a group is stopped while an OPC server is down, the groups items will be added when the server is reconnected. o Added - Double clicking on an OPC item in the browse window now retrieves and displays all properties for that item. Version 3.1.1 o Fixed - folder name, group name not evaluating correctly in alert distro list preview window (work correctly in operating system). o Changed - alert keywords for messaging and distro lists now use different sytax which is less confusing (previously indicated by "!", which is also "NOT"). o Changed - Documentation a bit clearer for alert distro lists. o Added - Ok/Cancel buttons to program settings window. Version 3.1.0 o Added - New alert distribution system. o Added - LIKE keyword to scripting language for wildcard-based string comparison. o Added - TimeBetween function to base library. o Added - CSV support for block groups. o Added - Dependency system support in block groups. o Added - data cache path now changable setting. o Added - Can now "copy" from the OPC item browse window. o Added - Can now paste OPC items from clipboard into the Redundancy OPC monitoring list. o Added - Item units, folder path, group name properties to alert custom messages & distro system. o Changed - 'Avg Group Execution Cost' statistic no longer takes into account reoccuring subsystem functions. o Fixed - 'Service Starting' screen not shown while service is restarting after a system restore. o Fixed - 'Project Source Change' screen shown after connecting to service after system restore. o Fixed - Alerting doesn't work for block group accessory items. o Fixed - Email server timeout not correct in alerting system. o Fixed - Service not waiting for the specified startup delay. o Fixed - Error after renaming folder in treeview. o FIXED - Redundancy: When node requested project state goes from active/warm (running) to ready (stopped) and then back, groups do not start correctly. o Changed - Redundancy: requested project state not modified when responsibilty state becomes UNKNOWN (only happens in rare cases). o CHANGED - Redundancy: In responsibility calculation, OPC Quality code is now evaluated before project state. Previous position was preventing it from working correctly- when enabled, responsibility will be shifted to node with best OPC quality code. o Fixed - MemberNotFound exception when starting groups with audit log. o Fixed - Datacache: over max resolution setting being stored in reverse. o Fixed - Connecting to service remotely retrieves that service's conn list, even though remote conns are a local setting. o Fixed - Changing item mode not marking group as modified (not being saved immediately). Version 3.0.6 o Changed - Included MySQL connector reverted back to 1.0.7. o Fixed - Group in redundant project disappears from treeview after being modified on different node. o Changed - Remote comm subsystem now started before logging system. Frontends trying to connect will be shown a wait message. o Added - when connecting to redundant network, will be notified if service is not master. o Added - more notifications showing connection to redundant network/backup. o Changed - Tray app waits ~30sec before loading internal database to prevent clash with starting service. Version 3.0.5 o Fixed - Standard groups not setting OPC update rate correctly on server. o Fixed - DB connections acquiring new UID when connection type is changed. o Changed - Change splash screen architecture to accomidate bug in .Net framework, should fix occasional critical error on startup. o Fixed - Live values for action items not working. o Fixed - Cannot open db config from scheduled group tab. o Fixed - Problems creating scheduled group items & display. o Fixed - Critical error when testing remote service connection with incorrect host name. o Fixed - Change Project title not saving: fix not ported from 2.3. o Fixed - OPC Server drop down in OPC item not showing servers. o Changed - OPC Server text box in block group items changed to drop down. Version 3.0.4 3/13/2007 o Fixed - Fixed some problems with project/system restore. o Ported two items from 2.3 line: 1. Must explicitly choose to rename items in treeview (simple click won't initiate rename) 2. Ctrl-Space item reference menu now scrolls horizontally. o Fixed - Project manifest not saving correctly (can't delete folders). o Fixed - Error when starting tray app & service is in "Demo Expired" mode. o Fixed - Occasional error writing to OPC server in standard group. Version 3.0.3 o Fixed - Cannot select DSN type from db config screen. o Improved - Database connection checking is not performed asynchronously in service in more cases, improving startup speed and settings saving. o Improved - Many fixes and improvements with aggregate data connections. o Fixed - Improved logic in 'Please Wait' screen to hopefully fix a threading bug reported by several users. o Fixed - Problems saving groups in redundant mode on some types of databases. o Fixed - Groups not always logging properly in redundant mode when some groups are incompatible. o Fixed - Old project not being cleared properly when new project is uploaded to service. Verison 3.0.2 - 3/6/2007 o Fixed - Referencing hourmeter items in action items causing incorrect interval update. o Fixed - Overriden table columns preventing database sub system from starting correctly. Version 3.0.1 - 3/5/2007 o Fixed - When block groups are cut in frontend, wrong icon is displayed. o Fixed - Error loading Scheduled group into frontend. o Fixed - Problems with unhandled errors. o Fixed - New OPC/Action item menu buttons disabled when block group selected. o Fixed - Startup delay not being saved correctly to the registry when edited off-line from service. Version 3.0 - 3/2/2007 Changes ------------ Many, many significant changes, both visible and not. It would be very hard to list them all here, so the following is a list of highlights: o Converted to .Net 2.0 Framework o Lots of UI work- hopefully fixes the occasional windows' painting error. o Add database-centric redundancy. o Added the aggregate db connection type. o Added the Block Data Group o New OPC subsystem, tag/subscription handling. o New subsystem status screen, with status pages for the major sub systems. o New internal database connector that should be less prone to locking errors. o Dragging many (~1000) tags from OPC browse window fixed- was very slow. Known Issues ------------ o Data connections that are unavailable, especially when using aggregate connections, can cause certain actions to slow down considerably. o There is apparently a problem with aggregate connections sometimes not saving one of their connection names (seems to be secondary). This has not been reliably repeatable. o Data caching does not work for block groups. o In some cases (usually right after install), the service may start to fail citing a "failure to upgrade internal database". Restarting the service seems to fix the problem. Version 2.3.8 - 1/17/2007 o Fixed - Bad quality data being passed to alert system as 0, causing incorrect alerts/clears. o Fixed - Settings changes to multiple groups not taking hold if they are started before changing group selection. o Changed - Changed the minimum log rate from 200ms to 50ms. o Changed - Response and sequence of events after losing connection to OPC server. Improves time before items show as BAD quality. o Fixed - In some cases, groups responding multiple times to datachange events, causing problems when server is lost. o Changed - Error log viewer now sorts by time descending. o Added - Installer now sets the COM authentication level for FSQL in the registry. Version 2.3.7 - 12/16/2006 o Fixed - "Internal server error" dialog occures in some cases when remotely connecting frontend to service. o Fixed - Pasting items only works when item pane is selected- not when group pane is selected. o Fixed - Cannot drag items onto groups in treeview. o Fixed - Critical error when trying to import a CSV with no valid items. o Fixed - CSV import doesn't work with files containing mid-line breaks o Fixed - alerting custom error message option and text missing from CSV import/export. o Fixed - Delete key not working correctly when editing group/folder names. Version 2.3.6 o Added - Ability to send custom alert messages. o Changed - Scripting "GetItemByName" function no longer case sensitive. o Fixed - OPC item dependencies not refreshing properly. o Fixed - Added horizontal scrollbar to item reference popup. o Fixed - Occasional problems starting group due to blank where clause. o Fixed - Alert on value change creating alert clear messages, though it they are always automatically marked as clear. o Fixed - Run always action items inside of triggered groups not writing strings to the database in the same way as other types of items. Version 2.3.5 o Fixed - Key columns used for enhanced alert lot not ensuring unique identification. o Fixed - "Help Contents" tool button not working. o Fixed - Project title changes not always being saved. Version 2.3.4 o Added - Fields "CharsToEscape" and "EscapeChar" to DB Translator to better accomidate strings. o Added - The two above fields to all database definition files. o Changed - Project Tree items can no longer be edited by clicking, you much choose "rename" from menu or use ctrl-r. o Fixed - Reading OPC ARRAY tags causes errors. o Fixed - DB browser not deleting rows properly. o Changed - Substring function of base library now returns blank string when passed invalid arguments (ie. starting index greater than string length), instead of raising error. Version 2.3.3 o Fixed - OPC quality in database not accurate. o Fixed - Error when opening query browser when selected connection does not exist. o Fixed - When clicking around between logging groups, status page occasionally blanks out. Version 2.3.2 o Fixed - Plugins without explictly defined FunctionName property not showing up in list. o Fixed - Groups that fail to start on service startup not being showed as errored in frontend. o Fixed - Service status application occasionally not able to connect to service. o Fixed - Error in merge project utility when tranfering using "transer" button w/ no dest. folder selected. o Fixed - Error in merge project when adding transfer the same group into same dest twice. Version 2.3.1 o Fixed - After deleting a single scheduled group, it reappears the next time you connect to the service. o Fixed - Folder logging states not always accurate on service connection. o Fixed - Activation status sometimes incorrect after re-installing an old version and then installing a new version. o Fixed - Added support for legacy OPC Server Enumerator o Fixed - Bad error message when testing email servers (without TLS). o Fixed - Editing multiple alert items at the same time clears out digital state name (and possibly other fields). o Fixed - Table drop-down not populating correctly for SQL Server. Version 2.3.0 o New - Now possible to change the column that a group uses as the index. o New - Full featured "file system"-like folder structure. o New - Full cut/copy/paste of items, groups, and folders. o New - Full Dependency system, keeps track of referenced items. o New - Event logging system. Logs to the internal database. Improved log viewer. o Fixed - Events are now created/logged for every alarm state crossed (active or cleared). o New - Enhanced alerting model/table structure. Legacy system still accessible. o Changed - Alert states are now evaluated when group executes, not asynchronously. o Changed - "Main" and "Scheduled" folders are no longer created by default. o New - Scheduled groups may be placed in any folder. o New - added "DontEscapeBackslashes" parameter to db definition file. o Changed - Run-always action items are now taken into account when running the group in "async" update mode. o Fixed - table browser will only allow editing data in tables that are FSQL compatible. o Fixed - Error on startup when alert system is set to use a connection that does not exist. o Changed - OPC browse system. Improved handling of concurrent server browsing & canceled leaf browses. o New - Ability to view value "snapshots" while browsing. With compatible servers, it will include the current value at the time of browse. o Changed - Added timestamp to group error messages. o Fixed - System restore fails in several common cases. o Fixed - Groups utilizing several OPC servers not operating correctly when one server is not available. Version 2.2.7 o Changed - Values are now converted to strings in a culturally insensative manner, fixing an issue with european number formatting. o Fixed - CSV errors while importing groups with certain alert settings, trigger settings, or action item function calls. o Changed - Tag browsing now only requests tag data type, greatly increasing browse speed. o Fixed - Problem with using action items in where clause due to execution timing. Version 2.2.6 o Fixed - Manually added remote server doesn't appear in tree until after refresh. o Fixed - Removed server does not disappear from tree until after refresh. o Fixed - Cannot edit a remote server to remove authentication (cannot set back to anonymous). o Fixed - OPC Refresh being called against potentially inactive items- causing "Cannot Connect" error. Version 2.2.5 o Fixed - Unpredictable errors writing to Alert Log when using many alert points. o Changed - Altered how the database system closes connections - was causing pooling problems with some connectors. o Fixed - Issue with upgrading from versions previous to 2.2. o Fixed - Issue with having "custom row selection" selected along with "insert new record". o Fixed - Case-sensitivity on the db-to-opc mapper tool causing items to not be matched up. o Fixed - Service connections not being saved when created from the service connection menu (going through the settings display not affected). o Added - Timestamp to system/group messages. o Changed - Text coloring on system/group message list display control to be more readable. o Changed - Authentication scheme for service passwords is now case insensitive. o Changed - Installer now requires .Net 1.1 exactly, since 2.0 has various incompatibilities. Version 2.2.4 o FIXED CRITICAL BUG - In some cases, a mis-versioned assembly was causing projects to load incompletely, which led to many other issues in the configuration frontend. o Fixed - Small bug with the tray application causing status to not update correctly. Version 2.2.3 o Fixed - Error when changing an item's server name. o Fixed - Error occasionally occuring after deleting a group. Version 2.2.2 o Fixed - Alert Status table not being updated correctly on startup. o Fixed - CSV import of groups with certain null fields causes an exception. o Fixed - Custom where clause using the table index column always wants to add a row. o Fixed - Upgrade of Triggered SQL items was not working properly. o Fixed - Auto-run Windows registry entry was not being upgraded properly. Version 2.2.1 o Fixed - Upgrader functionality not working properly all of the time. o Fixed - Retentive hour meters not retaining value across group and program re-starts. o Fixed - Deleting a group in an offline file, having never connected to a service, no longer causes an error. o Changed - Trying to write nulls to an OPC item is no longer allowed- will generate an error (does not stop the group from executing, though). o Fixed - Small issue with group status display, after stopping an errored group and starting it again. o Enhanced - Better error message when action items try to write a null to OPC. Version 2.2.0 *Compatibility Breaking Changes - Do not try to use a 2.2 frontend on a 2.1 service. o Major Change - New and Enhanced OPC sub system. Compatibility tested at the OPC Interoperability Conference, April 2006. o Major Change - New database file system. The working project and system settings are now stored in an internal database, reducing system backups to a single file, improving stability, and providing necessary ground work for future enhancements. o Feature - Data caching - should you lose your connection to the database, historical data will be cached until you are re-connected. o Feature - May now configure/connect to OPC servers remotely, over DCOM. o Feature - Improved server browsing, possible to view tag properties. o Feature - Added SSL/TLS support to alerting system, which adds support for services like Gmail. o Feature - New handy system backup and restore. o Feature - New Merge Projects tool lets you combine multiple project files. Version 2.1.5 o Fixed - OPC items being added as initially Active, causes problems with certain servers. o Changed - Action items now check value of their writeback targets, and will write when different, not just on change. o Changed - Better error logging for email alerting. o Fixed - Concurant project file access attempts on saves after starts/stops. o Fixed - Concurrent access issue when starting multiple groups with many action items at the same time. o Changed - Improved Oracle Support, Oracle available Out-of-the-box. o Added - New Service Setting - OPC Update Rate % - allows you to specify the OPC update rate as a percentage of the group update rate. Default is 33%. o Enhanced- Improved group startup time. Version 2.1.4 ------------------- |--Fixed Bugs-- +'@' symbol in write back address for upgraded sql items. +Service connection password dialog is now always on top, so that it is visible when shown along with the splash screen, when auto-connecting to a protected service. +Action item value comparison was not working well for complex data types. +Live values for action items with complex data types was not working well. The items will now be converted to strings for the purpose of live values. +Duplicate column names (such as between an OPC item, and an action item) were causing problems with table creation. +Error connecting to database on group start was not being shown in correct display box. ------------------- Version 2.1.3 ------------------- |--Fixed Bugs-- +Null values where causing subsequent values to not be displayed in Frontend. +Error enumerating OPC 1.0 servers (displayed when connecting to a service). +Fixed problem where selecting multiple groups with the same trigger field would cause trigger to revert to blank. +Changing connection type would cause a changed connection name to revert in DB Config & Service Connection config. +Search and replace did not allow replacing with a blank string. ------------------- Version 2.1.2 ------------------- |--Fixed Bugs-- +Where clause parser did not pick up key columns with string values. +Under certain conditions, Action Item "run on trigger" box value was not being saved. +Item indexing in group was being shifted (incorrectly) when non-existant addresses were added. +Alert settings were disappearing when upgrading from 2.0. +Groups with long update rates (over approx. 12 minutes) would not run reliably. +Alert settings were not being copied along with items when draging-dropping in frontend. +Negative exponents in action items weren't working correctly. +Renaming group folder before adding groups caused groups to go into incorrect folder. ------------------- |Added Features +Added Ctrl-F shortcut for search & replace on the group folder level. ------------------- Version 2.1.1 ------------------- |--Fixed Bugs--- +Action Item right-click menu (in code window) not showing available plug-in functions. +Problem loading plug-in functions without attribute-defined name. +Scripting engine was returning the "\" of an escaped character sequence. +Search and replace wasn't properly searching all fields of action items. +Lower case letters were causing errors during manual activation. +Connection Name listbox display was blank while group was logging. |--------------- |Added Features +The OPC items are now sortable, by clicking on the column header. +You may now choose which columns to show for OPC items via right-click, or Frontend Settings. -------------------- Version 2.1.0 -------- *Compatibility Breaking Changes - Do not try to use a 2.1 frontend on a 2.0 service. + Totally new core execution engine. Does a better job of limiting resource use when using a database driver that does not limit itself. Also, relieves reliance on the .Net threading timers, which have a bug in Windows 2003 SP 2. + Created a new type of hybrid item call Action Items. SQL and Macro items are automatically converted. + Add plug-in extensibility system for Action Item scripting language. New functions can be added by simply dropping an assembly in the plug-in folder. + Added new status and result feedback from the service to frontend when starting/stopping groups. + Made the "Service Status Table" sub system refresh properly after changes. (No longer requires service restart)