Questions tagged [historian]
Andrew Henderson 
Ask Question
Historian (or an Operational Historian) refers to a database software application that logs or historizes time-based process data.
60 questions- Bountied 0
- Unanswered
- Frequent
- Score
- Unanswered (my tags)
How to check similar shaped trends in the past data? Any option other than dynamic time wrapping?
For example, let's say we have data coming from a sensor at every 5 seconds on live basis, at the same time we have been collecting this data for last whole year. Now, we got a spike today from 5:00 ...- 1
Spark action throws "Cannot execute the query against OLE DB provider "INSQL" for linked server "INSQL" from Wonderware Historian DB
Using Spark, I have successfully loaded a Dataframe from a Wonderware Historian SQL DB (see this SO question). Listing the column names: df.columns 'TagName', 'Value', 'vValue', 'Quality', '...- 1,152
How can I link Historian Data to Insigth Control? in Wonderware
Insight control isn't displaying any data in wonderware even though tags are configured and chosen to point at them, and also data is historized. I'm not sure if I am missing any configuration. I've ...- 3
SQL OPENQUERY does not work for Provider = INSQL
INSQL is linked server that uses INSQL provider (from Wonderware Historian) Query SELECT * FROM OPENQUERY(INSQL,' SELECT 1') gives error as below: Msg 7399, Level 16, State 1, Line 27 The OLE DB ...- 11
Matrikon OPC simulation Server doesnt have tags
When launching the Matrikon Simulation Server when I connect to view the tags it doesnt contain any tags, I'm trying to generate random data to make a process historian. Do I need to download another ...- 23
What is the structure of *.bin files ( also called Late Data files) in Historian Wonderware Server?
I'm trying to parse *.bin file of Late Data. I found out some meanings of some group of bytes (look at the picture), but some group of bytes I could't veryfied (in red circles). Does anyone knows what ...- 63
SQL Historian Query not returning all results
I am using an historian to search for certain values of a specific tag. The historian has certain rules, such as, I cannot create or drop tables, queries need tagnames etc. I want to search a TagName '...- 1
Value of a set of tags at a predetermined value in SQL
I'm trying to bring values to SQL from Wonderware Historian, in the code below it is taking values from the StateSummaryHistory view, which is a view of the Historian Client that updates as the ...- 9
Inserting data between SQL table and Wonderware Historian
I'm trying to get values from the Wonderware Historian to be read in the Report Builder. I got the SQL code below through the Historian Client Query, but this code does the select directly from an ...- 9
Insert query - Error converting data type nvarchar to (null)
I'm trying to insert data from SQL Server to a Linked server but I am encountering the following issue: Msg 8114, Level 16, State 11, Line 1 Error converting data type nvarchar to (null). My query is:...- 1
Volttron Crate Historian Error: Invalid data not saved
Hope you are doing great. The CrateHistorian is not working. I have installed it with the following configurations: { "connection": { "type": "crate", ...- 309
Use of KsqlDB as a HIstorian DB
I want to make a historian database that records and retrieves data from Kafka topics to a permanent database. I am trying to use the KsqlDB to do it, I have trying to use tables and streams from ...- 395
Some datetime filters on Wonderware Historian queries returns no data
I'm querying to Wonderware Historian Database from SQL Server Management Studio and found that sometimes I don't get values, depending on the datetime filters I've set, even using Full retrieval mode....- 101
Unable to query with SSRS parameter to iHistorian
I'm trying to get iHistorian to accept a query from SSRS using a parameter for Date, with OLEDB. Query is like this in the Report Builder Dataset SELECT timestamp, tagname, value FROM ihrawdata ...- 1
Wonderware History Tags
When I run my function to retrieve the history values in Wondereware into Excel it only loads 4 of the 50 tags. I have tried to select the cells that have the tag names in it and it seems that it ...- 11
15 30 50 per page1234 Next
