Canary Team

Steve Mason

smason

Martinsburg, PA

1882
336
4

Joined: Mon Jun 07 15:41:47 UTC 2021

My Posts

Latest Posts

Re: Best practice for modifying external properties saved in SQL
I ran this by @Ken Wyant , he suggested developing something in Axiom to be used as a data entry form and then scripting to insert/replace the properties in the sql database.…
- smason
- 5 days ago
- Questions & Answers
- Reported - view
Re: Example on Rollup
@frank. zhao You can span multiple levels. It will roll up the tag to whatever asset type the calc is set to. Within the function itself, you specify the child asset that you are rolling up.…
- smason
- 6 days ago
- Questions & Answers
- Reported - view
Re: How can I ignore Bad/No Data values in a Value Box sum?
Good suggestion @Damon Vinciguerra ! Unfortunately, the Fallback (Flbk) only works for NoData qualities, not Bad qualities . We created a work item to include this functionality in the function.…
- smason
- 7 days ago
- 2
- Questions & Answers
- Reported - view
Re: Excel Add-In not Fully Installing V26.3
@timothy. vertin Glad you could resolve it!
- smason
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Release V26.6
@Damon Vinciguerra I updated the release notes with a link to the documentation.…
- smason
- 2 wk ago
- 1
- Canary System Release Notes
- Reported - view
Re: Upgrading from v25 to v26 - Collector server not reaching to the correct license server
Hi @apermag , Is there a local Identity service running on the Collector machine? The License endpoint will default to whatever the Identity endpoint is if there is no local License service.…
- smason
- 2 wk ago
- Bugs or Issues
- Reported - view
Re: Handling Async or Out-of-Order Data in Canary SQL Collector and MQTT
@Damon Vinciguerra Yes, the last one in wins as there can only be one value per timestamp.
- smason
- 3 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Pulling Values with Bad Quality (0X00)
@nicolas It would not. The authentication piece completely changed in v24+. You would need to update the Historian in order to utilize the Excel Add-in.
- smason
- 3 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Pulling Values with Bad Quality (0X00)
I wouldn't expect a value to be returned if the quality is Bad; however, the add-in seems to be the exception, at least in version 26.6 that I'm running.…
- smason
- 3 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Axiom application and chart getting grayed out randomly and not able to save or open.
@h james , this was fixed in v26.6.
- smason
- 3 wk ago
- Bugs or Issues
- Reported - view
Re: Customize Event Email Subject
Hi @laruer , this was released in v26.6.
- smason
- 3 wk ago
- 1
- Calculations & Events
- Reported - view
Re: Test Event Email Button
Hi @laruer , this was released in v26.6.
- smason
- 3 wk ago
- 1
- Calculations & Events
- Reported - view
Re: Pulling Values with Bad Quality (0X00)
Hi @nicolas , The Excel Add-in has an option to return the value regardless of quality. If you choose the Raw Data function, there is a Value and Value if Good checkbox. Choose Value.
- smason
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Excel Add-In not Fully Installing V26.3
To me, it looks like it is trying to use the 32-bit version of the add-in based on the .xll file, "CanaryLabs-Packed.xll". The 64-bit version is "CanaryLabs64-Packed.xll".…
- smason
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Excel Add-In not Fully Installing V26.3
Hi @timothy. vertin , Here is what my screen looks like: I have 3 additional COM Add-in types, but I am also using the 64-bit version of Excel. It appears your end user may be using the 32-bit…
- smason
- 1 mth ago
- Questions & Answers
- Reported - view
Re: How to send a subset of tags from one Canary historian to another
Hi @isaac fowler ! Great question! The easiest solution would be to set up an alternative OPC Collector session and send the data to their Historian directly, assuming the network allows it.…
- smason
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Calcs & Events Tile (version 26)
@frank. zhao You are correct on all accounts. From the Jobs screen you can also be selective about which assets you want to backfill.
- smason
- 1 mth ago
- Calculation Server
- Reported - view
Re: Error when opening Axiom applications containing Spark Charts
Hi @zach. hoskin , I would recommend opening a support ticket for this issue. I think they'll be able to resolve it faster than us going back and forth.…
- smason
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Linked Tags (version 26)
Hi @frank. zhao. The only way you could look at data separately is through the Historian tile. All other client queries are routed through the Views service where the two are combined.
- smason
- 1 mth ago
- 1
- Views and Asset Models
- Reported - view
Re: Connecting Canary to Power BI (version 26)
@James Wise Thanks for the post! I updated the article to include this information. In regard to your last comment, you shouldn't have to check the box to "Allow any extension to load without…
- smason
- 1 mth ago
- 1
- Using Canary's APIs
- Reported - view
Re: Aggregate List (version 26)
Hi @Davin Ross , I believe that aggregate has been deprecated. I'll remove it from the list. I would recommend using Startbound of Start as an alternative.
- smason
- 1 mth ago
- 1
- Excel Add-in
- Reported - view
Re: How to Configure the CygNet Collector (version 26)
Yes! I updated the article to include that information.
- smason
- 2 mths ago
- Data Collection
- Reported - view
Re: V26.5 OPC UA session/group tag limits
Will do @Lane Olsen ! There really shouldn't be a limit anymore in terms of a session or group. We suggest 25k tags in a DataSet, but that's to control the daily HDB file size.…
- smason
- 2 mths ago
- Questions & Answers
- Reported - view
Re: OPC UA Collector performance issues
Hi @michal. frydrych , Performance improvements to the OPC Collector U/I have been made in v26.5.
- smason
- 2 mths ago
- 1
- Bugs or Issues
- Reported - view
Re: API Returns duplicate offset during fall-back DST transition
@Shawn Rieger , This has been resolved in 26.5.
- smason
- 2 mths ago
- Bugs or Issues
- Reported - view

1 2 3 4 5 37