This project has moved. For the latest updates, please go here.

Issue with OutputAdoadapter with Version 1.5

Jul 11, 2012 at 2:22 PM

Hello everybody,

          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/250285http://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=1.5.90.0, Culture=neutral, PublicKeyToken=null
Assembly Version:      1.5.90.0
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 ----
   MySql.Data.MySqlClient.MySqlStream.ReadPacket()
       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
   MySql.Data.MySqlClient.MySqlDataReader.NextResult()
       openPDC.exe: N 01126
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(behavior As CommandBehavior)
       openPDC.exe: N 02399
   MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
       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 

Regards