MQTT Collector Admin Crashes When Adding Filter
Hello,
When adding a filter to the MQTT Collector while following Data Logging - Project Boot Camp - Canary Community (canarylabs.com), the application crashes when selecting the "+" icon next to the filter.
This happens each time I reopen the application and try adding the filter again.
Event Viewer Application Crash:
"Faulting application name: CanaryAdmin.exe, version: 21.4.1.21315, time stamp: 0x618d4711
Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
Exception code: 0xc0000005
Fault offset: 0x00007ffc74e922a8
Faulting process id: 0x2e48
Faulting application start time: 0x01d842d1c5b658e6
Faulting application path: C:\Program Files\Canary\Canary Admin\CanaryAdmin.exe
Faulting module path: unknown
Report Id: 7537e903-aec5-11ec-8121-000d3aeecb75
Faulting package full name:
Faulting package-relative application ID: "
Event Viewer .NET error:
"The process was terminated due to an unhandled exception."
-
Hi Davin Ross ,
Are configuring this from a remote Admin client, or are you local to the MQTT Collector? Just wondering if your client and the Admin service on the MQTT Collector are on different versions which may be causing this. I am not able to reproduce this behavior on my environment. If you are local to the collector, could you upgrade to the latest version, v22.0?
-
Steve Mason
Interesting, v.22 is showing the same behavior local on the Canary Collector / Historian Server.
Jeff Knepper , no rush. I'm ok with waiting since this is just for testing. -
Davin Ross What OS are you using? I am using a very old one (Windows 2012 R2).
-
pvmagacho Our test environment is also Windows Server 2012 R2.
-
-
Hello. I am having the same problem. How can I upgrade to version 22.0?
-
We are testing our newest release candidate right now. Are you OK with waiting through the weekend for 22.0.1?
-
Jeff Knepper Sure. No problem.
-
Davin Ross and pvmagacho
Thanks for the input. Once we saw you were both using 2012 R2 we set up our own server and were able to reproduce it. It does appear to be tied to that particular OS, although were not really sure why. It also occurs if you try to add a property.
As a workaround, you can manually add the filter record to the sqlite database. Once that record is added, you can delete or modify it, or add another.
The file you will need to edit is C:\ProgramData\Canary [Labs]\Logger\StoreAndForward\MQTTCollector\MQTTCollector.sqlite. We use DB Browser (it's free) to edit these files. If you don't have DB Browser, we include a portable version of it in our software. That is located in C:\ProgramData\Canary [Labs]\Shared\Utilities\SQLiteDatabaseBrowserPortable\SQLiteDatabaseBrowserPortable.exe.
Once you open that database you will want to select the 'Browse Data' tab. You will need to manually add the record to the SubscriptionFilters table.
The 'ID' can be any numeric value. The 'SubscriptionID' must be a valid ID. You can determine that by looking at the Subscriptions table.
Once you create the record, you will need to 'Write Changes'.
On a side note, if you are using v22.0, there is a bug in which you cannot Apply changes unless you have entered a value for the 'LWT' fields on the initial screen. This is for consuming JSON through MQTT which we introduced in v22.0. Once you Apply changes you can go back and remove these. There is a fix for this bug in 22.0.1.
Hope this helps!
-
Steve Mason Can you also provide examples for the Tag Properties entry in the SQLite DB? Thank you
-
Sure pvmagacho !
Very similar to the Filters, you will need to manually enter the first record into the SubscriptionTagProperties table. Once that record has been saved, you will be able to add/delete/modify properties in the Admin.
Again, the 'ID' can be any numeric value. The 'SubscriptionID' must match the 'ID' found in the Subscriptions table.
-
Print this page