while Im working with the new version of OpenPDC I have encountered a problem with the AdoOutputAdapter. My system structure is easy:
- 20 Pmu Data coming from an OpenPDC on another server with a C37.118 protocol, send at 10frames per sec, and the data arrive to my Server where I have another OpenPDC with version 1.5.
- I have setup this OpenPDC with historian Archives that has a configuration setting like described in the discussions (http://openpdc.codeplex.com/discussions/284427;
http://openpdc.codeplex.com/discussions/250285; http://openpdc.codeplex.com/discussions/255282 ). The main Task of this Server
is to collect the Data and write it to a MySql DB in some tables.
So, when i enable the device , After a few moments , I get an error like :
[ARCHIVENAME] UNKNOWN COLOUMN 'NAN' IN 'field list'
I have encountered this message also in the version 1.4.2 but this error message doesnt cause problems and the openpdc was capable to write the correct data inside my mysql DB correctly. The version 1.5, instead, stops at that point, and doesnt write anything
in my DB table. Moreover, naturally, after a while, i get Yellow color messages like:
[ARCHIVENAME] there are xxxxxx unprocessed measurements in the output queue
exactly like in the discussion (http://openpdc.codeplex.com/discussions/284427), but I suppose that this is due to the impossibility to write data to my DB table. Sometimes, I'm "lucky"
and the OpenPDC write for some moments the data inside the correct DB table, but when a red message appear, it stops the program again.
Here under the errorlog of this event:
Machine OS: Microsoft Windows NT 6.1.7601 Service Pack 1
Application Domain: openPDC.exe
Assembly Codebase: c:/program files/openpdc/openpdc.exe
Assembly Full Name: openPDC, Version=188.8.131.52, Culture=neutral, PublicKeyToken=null
Assembly Version: 184.108.40.206
Assembly Build Date: 5/31/2012 3:22:16 PM
.Net Runtime Version: 4.0.30319.239
Exception Source: MySql.Data
Exception Type: MySql.Data.MySqlClient.MySqlException
Exception Message: Unknown column 'NaN' in 'field list'
Exception Target Site: ReadPacket
---- Stack Trace ----
openPDC.exe: N 00492
MySql.Data.MySqlClient.NativeDriver.GetResult(affectedRow As Int32&, insertedId As Int32&)
openPDC.exe: N 00450
MySql.Data.MySqlClient.Driver.NextResult(statementId As Int32, force As Boolean)
openPDC.exe: N 00131
openPDC.exe: N 01126
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(behavior As CommandBehavior)
openPDC.exe: N 02399
openPDC.exe: N 00140
AdoAdapters.AdoOutputAdapter.BulkInsert(measurements As IEnumerable`1)
openPDC.exe: N 02184
AdoAdapters.AdoOutputAdapter.ProcessMeasurements(measurements As IMeasurement)
openPDC.exe: N 00083
TVA.Collections.ProcessQueue`1.ProcessItems(items As T)
openPDC.exe: N 00050
For conclusion, I hope to have explained well my problem, If you have any suggest I Will definitly appreciate it.
Thankyou in advice