Hello,
The problem is in the title. The data is indeed collected by OpenHistorian. The tags are present in Grafana, but I don’t have any data.
Thank you for your help.
config:
win serveur 2022
data base type: sqllite
grafana:
config:
win serveur 2022
data base type: sqllite
grafana:
Hello,
Can someone help me understand what’s wrong?
Thank you.
In the openHistorian data source in Grafana, e.g., OHDATA, if you click “Save & Test”, does this succeed?
In this case there could be (1) an issue with the time range – all incoming and outgoing timestamps are assumed to be in UTC, or (2) an issue with resolution, you can specify a full resolution query to ensure all data points are returned for a query (use with caution, too much data can overwhelm browser)
This looks to be possibly querying OHSTAT instead of OHDATA – try switching the data source to OHDATA in the Grafana query…
There is a “statistics” historian and a “data” historian – the statistics historian is only for information collected by the system every ten seconds; all recorded measurement values go into the “data” historian…
In Historian I have 5 days of data so the values are there. I think that if I had a time problem the values would be displayed over 2 days but with a time difference?
Can you check what version of openHistorian and what version of the openHistorian Grafana Datasource you are using?
The first is displayed in the lower left if you open the openHistorian manager (Web or App)
The second should be in the Datasource page in Grafana somewhere.
hopenhistorian : 2.8.157.0
grafana: 7.3.4
That is quite a while ago. Are you able to update to a later version of both? (Updating the openHistorian should update both) The latest version is 2.8.477
Can you confirm via the openHistorian export data feature (in the web UI) that the historian itself stores the data and appropriate timestamps?
Try this one:
https://gridprotectionalliance.org/nightlybuilds/openHistorian/Beta/openHistorian.Installs.zip
Hello,
I had found it but the word BETA had not inspired me. 
I apologize for the late reply, but the update destroyed the entire database and tags. 
Everything is working much better, the values are being returned correctly in Grafana. However, I have an error in the query that I can’t seem to identify.
yet the values are good
Regarding hopenhistorian, it’s no longer possible to set multiplier=0.01 (for example).
On another topic, I would like to record a value per day.
For example, at 12:00 AM every day.
Is it possible in historian to trigger the PLC to read a register only at that time (this would avoid saving unnecessary values)?
Thank you very much for your help
It sounds like maybe you are using culture settings for a region that uses commas as the decimal separator instead of periods. The latest version of the openHistorian Manager should now accept 0,01 instead.
Hello,
In my previous version of OpenHistorian, it worked. Now, it’s not a problem because Grafana knows how to do it very well. You just need to know that the value isn’t scaled in OpenHistorian; nothing wrong.
Hi, I have the same problem with the before version and grafana, but when I update have the next problem
Hello,
I’m no expert, but the update completely deleted the database.db file.
I hope you don’t have the same problem because I started from a white page. 