---------------------------------------------------------------------
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 V (June 14, 2024)
* fixed: Web Sensor P8653 ingress data parsing issue.
Contains:
DBManager 2.25.0.0
21.1 IV (April 5, 2024)
* fixed: A database restore on SQL Server 2022 could fail under certain circumstances on SQL Server 2022.
It was identified by the error: "SQL Server Native Client: integer value out of range"
Contains:
DBManager 2.24.0.0
DBViewer 3.20.0.0
CommSvc 2.3.8558.17944
[new]
DBManager 2.23.0.0
EmailSender 1.0.5.0
21.1 III (March 25, 2024)
* fixed: Email sender behaved incorrectly when switching between unsecured communication, SSL and TLS.
Contains:
DBManager 2.23.0.0
DBViewer 3.20.0.0
CommSvc 2.3.8558.17944
[new]
DBManager 2.23.0.0
EmailSender 1.0.5.0
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)