--------------------------------------------------------------------- Comet Database - history of changes: Comet Datababase includes 2 programs: DBViewer and DBManager. This history file contains info about DBManager. To see history of changes in DBViewer, find DBViewer history.txt. --------------------------------------------------------------------- 21.1 II (January 19, 2024) * fixed: Email Sender was always incorrectly connecting to SMTP port 25. Fixed to use SMTP port from service configuration. Contains: DBManager 2.22.0.0 DBViewer 3.20.0.0 CommSvc 2.3.8558.17944 21.1 I (October 30, 2023) * new: device U0246G supported Contains: DBManager 2.21.0.0 DBViewer 3.20.0.0 CommSvc 2.3.8558.17944 21.0 I (June 2, 2023) * new: One Click automatic installation installs Microsoft SQL Server 2022 Express 64-bit * new: new device Web Sensor P8653 supported Contains: DBManager 2.20.0.0 DBViewer 3.19.0.0 CommSvc 2.2.8346.24491 20.2 I (August 24, 2022) * fixed: Overloaded environment with too many devices and active alarming profiles occasionaly caused deadlocks. This issue was affecting online data ingress and was causing occasional data loss. If there are error messages about deadlocks in the SOAP Server event log, you should upgrade the Comet Database to this version, since the issue has been resolved. message example about deadlock: "Storing ... to DB failed: ... Inserting channel ... Transaction ... was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction." Contains: DBManager 2.19.0.0 DBViewer 3.18.0.0 CommSvc 2.2.8144.27365 20.1 V (May 4, 2022) * fixed: SOAP Server was not able to release TCP connections when it was incorrectly left alive from client side. Releasing of these orphaned connections was fixed. This helps SOAP Server not being overhelmed e.g. when used with Wifi Sensors in low signal strength. Contains: DBManager 2.18.4.0 DBViewer 3.17.0.0 CommSvc 2.2.8144.27365 20.1 IV (March 25, 2022) * fixed: communication between Alarm Notifier Server and Email Server failed (frozen) after first email sent this bug appeared since last release 20.1 III Contains: DBManager 2.18.3.0 DBViewer 3.17.0.0 CommSvc 2.2.7891.22564 20.1 III (March 16, 2022) + Email Sender Service enhanced for support TLS 1.2 authentication with SMTP server. Contains: DBManager 2.18.2.0 DBViewer 3.17.0.0 CommSvc 2.2.7891.22564 20.1 II (January 17, 2022) * Fixed: Database connection was unable to connect when password contained special characters {, }, possibly others Contains: DBManager 2.18.1.0 DBViewer 3.17.0.0 CommSvc 2.2.7891.22564 20.0 V (August 3, 2021) * fixed: Microsft SQL Server Clinet 11.0 x86/x64 driver is part of installation. This driver is hardly used in database component. Solves problems: "Connection is busy with results from other hstmt" * fixed: Exchanged use from MSXML4.0 to MSXML6.0 due to ended support for MSXML4.0 from Microsoft Contains: DBManager 2.17.4.0 DBViewer 3.15.0.0 CommSvc 2.1.7768.26069 20.0 IV (April 22, 2021) + Support of JSON version 6 from GSM dataloggers + OneClickInstaller generates paswords that meets strong password requirements (automatic installation of MS SQL server was often interrupted due to weak password) * fixed: Database Viewer: MKT statistic for zero and negative values was not calculated. Bug fixed. Contains: DBManager 2.17.3.0 DBViewer 3.14.0.0 CommSvc 2.1.7768.26069 20.0 III (November 8, 2020) fixed: SOAP Server listens for JSON messages from Wifi sensor only on ../wifisensor URL (../soap is keeped for other device types) Contains: DBManager 2.17.2.0 DBViewer 3.13.0.0 CommSvc 2.1.7508.13285 20.0 II (October 22, 2020) fixed: SOAP Server incorrectly supported HTTP persistent connection what could lead to data loss during data ingress from Wifi Sensors. Contains: DBManager 2.17.1.0 DBViewer 3.13.0.0 CommSvc 2.1.7508.13285 20.0 I (October 15, 2020) + Support of Wifi Sensors Contains: DBManager 2.17.0.0 DBViewer 3.13.0.0 CommSvc 2.1.7508.13285 19.0 III (January 02, 2020) + Support of JSON version 5 from GSM dataloggers Contains: DBManager 2.15.0.0 DBViewer 3.12.0.0 CommSvc 1.0.7033.23577 19.0 II (July 11, 2019) fixed: Acquisition from P8xxx Web Sensors: 5th channel copied value from 4th channel Contains: DBManager 2.15.0.0 DBViewer 3.12.0.0 CommSvc 1.0.7033.23577 19.0 I (March 27, 2019) fixed: Alarm evaluation was using local time instead of UTc for determination if the device is offline (This led to dummy alarm messages at winter to summer time changes) Contains: DBManager 2.14.0.0 DBViewer 3.12.0.0 CommSvc 1.0.7019.30473 18.0 II (January 23, 2019) fixed: Malfunction export to Comet Database in Datalink service Contains: DBManager 2.13.0.0 DBViewer 3.11.0.0 CommSvc 1.0.6942.21373 18.0 I (January 7, 2019) + SMS/Email Alarming: Posibility to send notification at choosen time using CRON expression + Support of new ULogger types: U4440M, U3631M, U6841M fixed: Deleting channel data failed due to violating of table reference. fixed: Sms Sender: Problem with incorrectly initialized modem (enabled echo) Contains: DBManager 2.12.0.0 DBViewer 3.11.0.0 CommSvc 1.0.6942.21373 17.0-II (December 6, 2018) * fixies only in DBViewer Contains: DBManager 2.11.0.0 DBViewer 3.10.1.0 CommSvc 1.0.6715.28674 17.0-I (May 5, 2018) + Mobile Datalogger AState channels are newly stored as binary channel, hence SMS/Email alarming is applicable on them list of these chanels: - CONFIGURATION ERROR - MEASUREMENT ERROR - EXTERNAL POWER ERROR - OPTICAL ALARM ACTIVE - ACCOUSTIC ALARM ACTIVE - LOW BATTERY - EMPTY BATTERY * Alarm notifier service fixed to react on short peak alarms (needed for buffered mode from mobile dataloggers) Contains: DBManager 2.11.0.0 DBViewer 3.10.0.0 CommSvc 1.0.6642.28680 16.1-II (February 6, 2018) * fixies only in DBViewer Contains: DBManager 2.10.0.1 DBViewer 3.9.0.0 CommSvc 1.0.6599.25400 16.1-I (January 16, 2018) * FIXED: export ULogger history data failed when it contains alarm state samples (9th channel) Contains: DBManager 2.10.0.1 DBViewer 3.8.0.0 CommSvc 1.0.6585.25137 16.0-I (Nobember 27 , 2017) + ULogger - online data (via modem data connection) supported Contains: DBManager 2.9.0.0 DBViewer 3.7.0.0 15.0-II (August 22, 2017) * Internal version for special purposes Contains: DBManager 2.8.1.0 DBViewer 3.6.1.0 15.0-I (August 1, 2017) + New database structure 15.0 + New device ULogger support (acquisition from device record) + New Hx5xx firmware support (Humidex, 1/2 alarms) * FIXED: Print of alarm presentation near channel value * Improved statistics: error and interrupt values are excluded DBManager 2.8.0.0 DBViewer 3.6.0.0 14.0-III (April 11, 2017) * FIXED: Datalink service not supported DBAPI 14.0 Contains: DBManager 2.7.2.0 DBViewer 3.5.0.0 14.0-II (March 3, 2017) * FIXED: database upgrade fails when at least one sms/email profile already exists Due to this, it is strictly recommended not to use 14.0-I for database upgrade! Contains: DBManager 2.7.1.0 DBViewer 3.5.0.0 14.0-I (January 27, 2017) + storing history of notes - when note is edited, original is stored into history + statistics: counting duration time of binary states + SMS/Email alarming: added ability to send user message in notification + SMS/Email alarming: added ability to change detection interval + Comet Database One Click Installer is able to perform database backup and upgrade * FIXED: deleting device which was selected in some sms/email profile led to error Contains: DBManager 2.7.0.0 DBViewer 3.5.0.0 13.0-IV (June 14, 2016) + New supervising service Watch Dog Service Contains: DBManager 2.5.0.0 DBViewer 3.4.2.0 13.0-III (April 6, 2016) + revised manuals Contains: DBManager 2.4.0.0 DBViewer 3.4.2.0 13.0-II (March 15, 2016) * FIXED: Database Viewer, export to CSV, bug in columns' header Contains: DBManager 2.4.0.0 DBViewer 3.4.2.0 13.0-I (January 12, 2016) + New database structure 13.0 + Inserting notes to data in database (note can be insert from Database Viewer data table and chart) + Users for signing in Database Viewer + Filtering visible device in Database Viewer according to signed in user + Logging of sign in/out Database Viewer and logging of alarm confirmation + Backup/Restore database in Database Manager * FIXED: deleting data in Database Manager for huge databases * (March 3, 2016) FIXED: Database Manager error at program start when detecting license Contains: DBManager 2.4.0.0 DBViewer 3.4.1.0 12.0-II (December 09, 2015) * FIXED: Bug in upgrade script from DBAPI 11 to DBAPI 12. New table objects had wrong CZECH_CI_AS collation on varchar columns. This bug could arise on non Czech installations of SQL server during upgrading to DBAPI 12 when CometDatabase 12.0-I installation was used. 12.0-I (August 07, 2015) + New database structure 12.0 - Multilogger supported + Datalink server + Statistics - Standard Deviation + Statistics - print report + Graph - colors of lines can be stored into template + MySQL server no longer supported Contains: DBManager 2.3.0.0 DBViewer 3.3.0.0 11.0.11.0-I (September 15, 2014) + New database structure 11.0.11.0 - P8620, P8641, P8652, P8552 sensors supported Contains: DBManager 2.2.0.0 DBViewer 3.2.0.0 10.0.10.0-VI (June 06, 2014) * FIXED: In case of company re-branded version, SMS Sender, Email Sender and Alarm Notifier service resulted to error on its start due to inability to find logs folder. DBManager version is same as in previous 10.0.10.0-IV package. Contains: DBManager 2.1.4.0 DBViewer 3.1.5.0 10.0.10.0-V (June 03, 2014) * New version released due to fixes in DBViewer 3.1.4.0 only. DBManager version is same as in previous 10.0.10.0-IV package. Contains: DBManager 2.1.4.0 DBViewer 3.1.4.0 10.0.10.0-IV (May 06, 2014) * Fixed: More detailed info on program start if it cannot create user folders. This can happen if somebody has redirected user folders to network location. Contains: DBManager 2.1.4.0 DBViewer 3.1.3.0 10.0.10.0-III (December 11, 2013) * Fixed: Creating/upgrading to DB API 10.0 on MSSQL Server 2005 resulted to bug "Forceseek is not recognized table hints option." If anybody reached this bug, reconnect to the database with this version of DBManager (or any newer in future). Autopatch will be applied. Contains: DBManager 2.1.3.0 DBViewer 3.1.2.0 10.0.10.0-II (November 22, 2013) + "Sensors RS485/232 Utility" support added. This gives: - Txxxx/Hxxxx RS488/232 support - 3rd Party Device with RS485/232 connection and Modbus communication protocol support + SOAP server supports SOAP messages with data from more then one device. Acquisition via Sensors RS485/232 utility guarantees same samples times for devices with the same sending interval. + DBViewer: Configuration of DB connection can be passed by ini file instead of windows registry. + new Sensor prototype added (P8??? internal T+RH) + posibility to translate Alarm Notifier email/sms text using INI file + Optimized queries for obtaining min max of selected data for MSSQL Server + Optimized behaviour of of device-channel selector in DBViewer. Auto obtaing min max data dates was canceled. * Fixed: DBViewer resulted to error when some MS channels was disabled from viewing * Fixed: Incorrect date format used in some cases could lead to error when exporting data from MS or dataloggers. Fixed by using ISO date format. Only when MSSQL server used. * Fixed: When .msx file had only #17 alarm out channel then export to the database resulted to error. * Fixed: Occasional but when export data from .mxs to the database: "Database Index was not set for process 0 - Serial number N was not found" * Fixed: Bug only when MySQL server used in DB upgrade if older database was restored to newer one. Message "Table X already exists, cannot create..." Problematic DBAPI version upgrades: 4.1 -> 5.0, 7.2 -> 8.0, 8.0 -> 9.0 When this would occur then upgrade to the DBAPI version 10.0 is recommended. * Fixed: DBViewer, device-channel selector: was unable to unselect channels of device (clicking on the device) when max limit 100 channels reached. * Fixed: DBManager: Disabled check IsAdminLoggedOn * Fixed: MSSQL only, bug in upgrade DBAPI 8.0 -> 9.0 (autopatch90) * Fixed: Automatic activation to unlimited DB after upgrade from older versions (only when DBManager is licenced) Contains: DBManager 2.1.2.0 DBViewer 3.1.2.0 10.0.10.0-I (November 15, 2013) * Internal testing version Contains: DBManager 2.1.1.0 DBViewer 3.1.1.0 9.0.9.0-VII (September 10, 2013) * DBViewer: Fixed: Graph templates Contains: DBManager 2.0.8.0 DBViewer 3.0.5.0 9.0.9.0-VI (September 3, 2013) * Fixed: DBManager, database upgrade on MSSQL resulted in corrupted database in versions CometDatabase-9.0.9.0-I..V (DBManager 2.0.2.0..2.0.6.0) Contains: DBManager 2.0.7.0 DBViewer 3.0.4.0 9.0.9.0-V (June 13, 2013) * Fixed: DBManager, Administrator check skipped Contains: DBManager 2.0.6.0 DBViewer 3.0.3.0 --------------------------------------------------------------------- Database Manager - history of changes: --------------------------------------------------------------------- 2.0.2.0 (June 13, 2013) * Fixed: changes for new licencing system 2.0.1.0 (April 23, 2013) * Fixed: Irelevant user interface changes 2.0.0.0 (April 14, 2013) not released for public use + New database structure 9.0.9.0 - P2520 sensors supported - Tx6xx sensors supported + New system of licencing 1.11.1.18 (December 12, 2012) * Fixed: Email Sender service: SSL / TLS behaviour 1.11.1.15 (December 6, 2012) + New database structure 8.0.8.0 - SMS/Email alarming 1.9.2.0 (July 24, 2012) + New database structure 7.2.7.1 * Fixed: DB stored procedure for storing sample from Txxxx sensor BUG - incorrect type of v_interval parameter 1.9.1.0 (June 11, 2012) + New database structure 7.1.7.1 * Fixed: Detecting DB version 1.9.0.0 (May 18, 2012) + New database structure 7.0.7.0 - P8(5/6)xx sensor support for RH probes 1.8.0.16 (May 3, 2012) + New database structure 6.0.6.0 - CO2 sensors support - Accoustic alarming in Viewer 1.8.0.0 - 1.8.0.15 * for testing purposes only 1.7.0.19 (October 7, 2011) + New database structure 5.0.5.0 - Online acquisition from MS6, MS55 1.6.0.3 (July 25, 2011) + New database structure 4.1.4.1 * Fixed: SQL command returning unnamed columns leads to an error when RecordCountMode <> cmVisible or RecsMax > 0 1.5.0.49 (February 17, 2011) * Fixed: Datetime format was badly displaying 3 characters long month and day. 1.5.0.46 (February 10, 2011) + New database structure 4.0.4.0 + Microsoft SQL Server supported + Online data acquisition compression + Tool for compression history data 1.4.0.122 (October 1, 2010) fixed: Database backuping 1.4.0.106 (August 3, 2010) * First version of program * Supports database structure of version 3.1.0.0 * Includes SOAP server of version 1.0.0.95 1.4.0.115 (August 16, 2010) * Demo version - program functionality limited until September 30, 2010 * Changes same as in version 1.4.0.106 * Includes SOAP server of version 1.0.0.112 (Demo version of SOAP server limited until September 30, 2010)