GridProtectionAlliance / openPDC

Open Source Phasor Data Concentrator
MIT License
128 stars 59 forks source link

Archiving data using Historian Instance #100

Closed anudeepm closed 6 years ago

anudeepm commented 6 years ago

Hi,

I have connected four PMUs and I am able to monitor/read data from the openPDC console. But, when I archive the data to read it from historian view application in openPDC, I see only NaN values.

My final objective is to read the historical measurements through MySQL database. I have created a new output historian instance as described in http://openpdc.codeplex.com/discussions/571880

Please find attached the open-historian-instance-configuration screenshot, errorlog text file, and the CSV data file after exporting from historian view application manage_historian_instances ErrorLog.txt freqHistorian.xlsx

-- Thanks, Anudeep

ritchiecarroll commented 6 years ago

Here was a similar discussion: http://discussions.gridprotectionalliance.org/t/ado-output-adapter-error-failed-to-initialize-adapter-not-connecting-to-mysql-database/152

Per this outcome, perhaps you should double check your MySQL Connector.NET version number.

I am going to close this for now, feel free to reopen if issue still occurs.