Questions & Answers Category

Backfill To vs Remove Old Data

How are Backfill To and Remove Old Data related? Below are the definitions from the documentation. So Backfill To will be leveraged anytime the calc is saved or the calc service is started up?…

Asset hierarchy definition help

I have a dataset populated by a CSV collector and I am trying to create a virtual view to put the tags into an asset hierarchy. The tag names are of the form CsvTag.<site>.…

All valueboxes in a row getting time from a datetimepicker

Hi Today I have datetimepickers scripted towards valueboxes in a grid. One datetimepicker for each row in the grid. The grid as it is today is 7 columns and 20 rows.…

UFL collector fails to start

I have installed the UFL collector, following https://helpcenter.canarylabs.com/t/m1y8gkj/how-to-configure-the-csv-collector-version-24 but after installation, the install folder looks different:…

• Answered

Events Table Optimization

We are trying to optimize performance of the Events and Event Properties table, is it advisable to add Indexing and table partitions to achieve this?

Calculations stuck in Backfilling

I have several calculations that are stuck in 'Backfilling' and never go to Live Mode. This obviously means calculations that depend on them can't start.…

• Answered

Unable to read from transport connection

Hi, Has anyone come across this Error "Error during Live Update: Unable to read data from the transport connection;An exsiting connection was forcibly closed by the remote host" What may be the cause…

Connecting v23 and v24 historians via Remote Historian View

We currently have two Canary servers, one v23 and one v24. Is it supported to set up Remote Historian Views on each server so that the Axiom instance on each can access the Views from the other? Or,…

• Answered

Continuously repeating "Validating File"

In our Messages log I'm seeing repeated instances of historian files trying to be validated, then terminated, then validated over and over. After it churns for a while,…

• Answered

Replacing NaN in ValueBox calculation

I'm looking for an easy way to replace NaN as displayed in a ValueBox when the underlying calculation is NaN. I was trying to use the Value Transform using an if statement,…

Scaling on Virtual View

Hi all- I currently have some tags I am historizing that have a different scale associated with them as I store (10x / 100x / 500x). I am currently using virtual views and I am looking for a way to…

Button or link to a specific page within another application

I see that a button can link to another Axiom application, but I want to go to a specific page within that application rather than just the first page. Is this possible either with a button or a link…

• Answered

Axiom Scripting Launch Application

Is there any way to launch a different application from a currently running application using scripting?

Use an attribute of a parent asset in a calculation

I need to reference the value of an attribute in a parent asset in my calculation. For this example I'm trying to calculation the contribution of the current element towards the total of all the…

• Answered

Event duration sum

Hi, is there a way to total all the durations of an event that occurred within a time period. For example, I have an event triggered for downtime of equipment and I'd like to sum up the total…

How can I set time aggregation in Chart parameters?

I was reviewing the chart parameters documentation for the latest Axiom 24v. I noticed there was no mention of time aggregation. Is this available as a secret, undocumented parameter!?

Axiom as public facing self-service customer-specific portal

We have a v24 canary historian that collects flow rates from meters. The flow is coming into our pipeline system. The product comes from various customers (approximately 90 different customers).…

Event gives an error message

Hi, I am trying to setup an event that can let me know when a tag is above 70. I followed the instructions on How To Create an Event (version 22) - Calculation Server - Canary Community to get it…

Different log-ins for different preferences without using Windows LDAP

Hi, We run plant operations from a single PC with a general login, so everyone can access the HMI system and the Axiom trending package. Is there a way to create different accounts for the Axiom…

Displaying Unit property in Axiom

I have various tags with the property "Units", like this calculated tag: I'd like to show this in Axiom, and reading other posts it sounds like I need to create another Value symbol to show the units…

Assign Asset to 2nd level of all tags

I've got a View in which ever tag has 4 parts (separated by a period). In every tag, the 2nd level is known as the "area". I would like to assign an "Area" asset to the 2nd level of every single tag.…

Date & time functions in calculations

I'm trying to calculate approximate sunrise/sunset times for each day of the year for a solar generation application. I have them worked out in Excel and need to transfer the calculations to Canary.…

• Answered

Recurring hdb Reference Count Errors

I get recurring Reference Count warnings on hdb2 files (version 23.1). Is this a cause for concern?

Update Value Boxes based on Time/Date

I have an application that will show current line conditions/settings and whether they are running in spec. We want to add a way to pick a time/date so we can see all those line conditions on a…

Simple calculation. Don't understand where the results go

I'm new to Canary and trying to understand how the asset model and calculations work. I've got Solar PV data coming in for 2 inverters with a number of strings of panels on each inverter.…

• Answered