This project has moved and is read-only. For the latest updates, please go here.

Manager problems

Mar 11, 2010 at 7:24 PM
Edited Mar 11, 2010 at 8:45 PM

I'm running off a recent source build (thanks mthakker) and having some problems with the manager.  I (think I) followed the steps to set it up, running openpdc.exe through debug mode, moved an initial data MDB, and fired up localhost/openpdcmanager.

The first time the Manager loads, it pops up a window that says "Failed to Retrieve Nodes: The remote server returned an error: NotFound".  If I click "Okay", it hangs on the "Loading data, please wait" modal window.

Subsequent attempts hang on the same "Loading data, please wait" window, with "Currently processing PMU data from the following companies".  Some attempts are combined with a window popping up from an unknown source with the VS JIT Debugger, reporting "An unhandled exception ('System.ServiceModel.FaultException '1') occured in aspnet_wp.exe [5708]".

Configuration issue, operator error, or missing documentation?

Thanks,

Matt

 

 

Mar 11, 2010 at 8:58 PM

Hi Matt,

First check if http://localhost/openPDCManagerServices/Service/PhasorDataService.svc returns a page with "You have created a service" message. If it does then please check ErrorLog table in the database to see if it has any errors logged. If so, then please provide me those errors. If the above mentioned URL returns an error then that means service is not configured properly. Also check if NodeDetail query in the database returns any values. Please let me know what you find out.

Thanks,
Mehul Thakkar

Mar 11, 2010 at 10:22 PM

So, uninstalled everything I could, rebuilt, and started from the top.

I have an initial-data mdb in build/output/debug/apps/openPDC.  I am running the service in debug mode.

Creating the service works.  ErrorLog is empty.  NodeDetail is empty.  The whole DB (being the initial data, not sample data) is empty.  When I open the Manager through VS2k8, the first window reports that it is unable to retrieve the nodes due to an internal error.

Thanks,

Matt Hauer

Mar 12, 2010 at 1:53 PM

Matt

I will check with Ritchie and fix the initial data to include a Development node record in the database. Meanwhile, there are two ways you can define a node into the Node table.

1. Manually - add one node manually into the database in Node table. ID column value will be auto generated. CompanyID can be looked up into the Company table. Please enter rest of the column and save it.

2. Open up openPDCManager, and you should be able to close "Loading Data... Please Wait..." popup on the home page. Go to Manage --> Node screen from the top menu and fill in all the fields and save.

Please let me know if this does not help.

Thank you,
Mehul Thakkar

 

Mar 12, 2010 at 4:50 PM

I thought about trying to add a node when it first opened up ~ using the Manager to configure itself ~ but the node list couldn't find any companies, when I went to the 'Add Node' screen.  The 'Add Company' screen couldn't retrieve the Company list is a similar fashion, and would not let me write a new company to the database, which makes me suspect that it's more a configuration problem than a software problem.

 

I'm going to try feeding openPDC a MySQL database instead of the Access MDB shortly though.

 

Mar 12, 2010 at 11:37 PM

Running through MySQL is running into a similar problem, but has provided slightly more information.  OpenPDC's core is working, and is posting the XML metadata and time-series data to localhost.  The setup is connecting to the MySQL server, though there are two sources that could be doing that (both the core and the Manager).  It is still suffering from an internal error when the Manager attempts to pull table data, for unspecified reasons.

 

Thanks,

Matt

 

Mar 16, 2010 at 3:01 PM

Matt,

Did you run SampleDataSet.sql after setting up mySQL database? If not, then would you please try running this script and see if openPDCManager works. Please let me know.

Thanks,
Mehul Thakkar

Mar 16, 2010 at 5:28 PM

Matt,

One more suggestion for the error message "Failed to Retrieve Node". Please modify web.config file for openPDCManagerServices to set includeExceptionDetailInFaults to true. Please see below. This will return exact detail of the error message. Please let me know if this helps or not.

<serviceBehaviors>
 <behavior name="openPDCManager.Services.Service.PhasorDataServiceBehavior">
  <serviceMetadata httpGetEnabled="true"/>
  <serviceDebug includeExceptionDetailInFaults="true"/>
  <serviceThrottling maxConcurrentCalls="64" maxConcurrentSessions="50" maxConcurrentInstances="1"/>
 </behavior>
</serviceBehaviors>

Thank you,
Mehul Thakkar

Mar 25, 2010 at 9:36 PM

I did run the Sample setup script after setting up MySQL Server, and can visually verify that the schema and tables have been properly set up.

Changing the line to provide extra detail resulted in the intial error being "An OLE DB Provider was not specified in the ConnectionString."  This is MUCH more useful of an error message.

Mar 26, 2010 at 2:01 PM

Matt,

This looks like an issue with "DataProviderString" setting in the web.config of openPDCManagerServices. Please make sure this setting looks like below:

<font size="2" color="#0000ff"><font size="2" color="#0000ff">

<

</font></font><font size="2" color="#0000ff">

 

</font>

add name="ConnectionString" value="Server=serverName;Database=openPDC;Uid=root;Pwd=password" description="Example MySQL database connection string" encrypted="false"/>
<
add name="DataProviderString" value="AssemblyName={MySql.Data, Version=5.2.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d};ConnectionType=MySql.Data.MySqlClient.MySqlConnection;AdapterType=MySql.Data.MySqlClient.MySqlDataAdapter" description="Example MySQL database .NET provider string" encrypted="false"/>

From the error message it looks like your DataProviderString still points to OLEDB (may be from the previous MS Access settings).

Please let me know if this does not help.

Thank you,
Mehul Thakkar

Mar 26, 2010 at 5:19 PM

This helps, and the system now connects long enough to bring up that TVA has three measured lines and one "total".  It also reports that it failed to retreive filtered measurements by device, citing that the specified cast is not valid.  I used the sample setup script, and don't see a ticket for this one.

 

Thanks,

Matt Hauer

Mar 26, 2010 at 9:08 PM

Matt,

Glad to hear that it is now better than before. Error "Failed to retrieve filtered mesurements by device" should be logged into the ErrorLog table in the database. Would you please forward me the detail from that table? It is related data in the database and should be easy to fix.

Thank you,
Mehul Thakkar

Mar 29, 2010 at 4:47 PM
1, 'GetFilteredMeasurementsByDevice', 'Specified cast is not valid.', 'System.InvalidCastException: Specified cast is not valid.
at System.Data.DataRowExtensions.UnboxT`1.NullableField[TElem](Object value)
at System.Data.DataRowExtensions.Field[T](DataRow row, String columnName)
at openPDCManager.Web.Data.CommonFunctions.<GetFilteredMeasurementsByDevice>b__a3(DataRow item) in C:\OpenPDC Source\Synchrophasor\Current Version\Source\Applications\openPDCManager\Web.Data\CommonFunctions.cs:line 3050
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at openPDCManager.Web.Data.CommonFunctions.GetFilteredMeasurementsByDevice(Int32 deviceID) in C:\OpenPDC Source\Synchrophasor\Current Version\Source\Applications\openPDCManager\Web.Data\CommonFunctions.cs:line 3049', '2010-03-26 09:10:44'

2, 'GetRealTimeData', 'Invalid URI: The format of the URI could not be determined.', 'System.UriFormatException: Invalid URI: The format of the URI could not be determined.
at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)
at System.Uri..ctor(String uriString)
at System.Net.WebRequest.Create(String requestUriString)
at openPDCManager.Web.Data.CommonFunctions.GetTimeSeriesData(String timeSeriesDataUrl) in C:\OpenPDC Source\Synchrophasor\Current Version\Source\Applications\openPDCManager\Web.Data\CommonFunctions.cs:line 721', '2010-03-26 09:10:45'

3, 'GetDeviceList', 'Specified cast is not valid.', 'System.InvalidCastException: Specified cast is not valid.
at System.Data.DataRowExtensions.UnboxT`1.NullableField[TElem](Object value)
at System.Data.DataRowExtensions.Field[T](DataRow row, String columnName)
at openPDCManager.Web.Data.CommonFunctions.<GetDeviceList>b__69(DataRow item) in C:\OpenPDC Source\Synchrophasor\Current Version\Source\Applications\openPDCManager\Web.Data\CommonFunctions.cs:line 2140
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at openPDCManager.Web.Data.CommonFunctions.GetDeviceList(String nodeID) in C:\OpenPDC Source\Synchrophasor\Current Version\Source\Applications\openPDCManager\Web.Data\CommonFunctions.cs:line 2139', '2010-03-26 09:16:21'

4, 'GetFilteredMeasurementsByDevice', 'Specified cast is not valid.', 'System.InvalidCastException: Specified cast is not valid.
at System.Data.DataRowExtensions.UnboxT`1.NullableField[TElem](Object value)
at System.Data.DataRowExtensions.Field[T](DataRow row, String columnName)
at openPDCManager.Web.Data.CommonFunctions.<GetFilteredMeasurementsByDevice>b__a3(DataRow item) in C:\OpenPDC Source\Synchrophasor\Current Version\Source\Applications\openPDCManager\Web.Data\CommonFunctions.cs:line 3050
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at openPDCManager.Web.Data.CommonFunctions.GetFilteredMeasurementsByDevice(Int32 deviceID) in C:\OpenPDC Source\Synchrophasor\Current Version\Source\Applications\openPDCManager\Web.Data\CommonFunctions.cs:line 3049', '2010-03-26 09:17:29'

5, 'GetRealTimeData', 'Invalid URI: The format of the URI could not be determined.', 'System.UriFormatException: Invalid URI: The format of the URI could not be determined.
at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)
at System.Uri..ctor(String uriString)
at System.Net.WebRequest.Create(String requestUriString)
at openPDCManager.Web.Data.CommonFunctions.GetTimeSeriesData(String timeSeriesDataUrl) in C:\OpenPDC Source\Synchrophasor\Current Version\Source\Applications\openPDCManager\Web.Data\CommonFunctions.cs:line 721', '2010-03-26 09:17:29'


________________________________________
From: mthakkar [email removed]
Sent: Friday, March 26, 2010 1:08 PM
To: Hauer, Matthew
Subject: Re: Manager problems [openpdc:204677]

From: mthakkar

Matt,

Glad to hear that it is now better than before. Error "Failed to retrieve filtered mesurements by device" should be logged into the ErrorLog table in the database. Would you please forward me the detail from that table? It is related data in the database and should be easy to fix.

Thank you,
Mehul Thakkar

Read the full discussion online<http://openpdc.codeplex.com/Thread/View.aspx?ThreadId=204677&ANCHOR#Post424240>.

To add a post to this discussion, reply to this email ([email removed]<mailto:[email removed]?subject=[openpdc:204677]>)

To start a new discussion for this project, email [email removed]<mailto:[email removed]>

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe<http://www.codeplex.com/site/discussions/thread/unsubscribe/204677> on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com
Mar 30, 2010 at 3:04 PM

Matt,

Would you please email me data from the DeviceDetail and MeasurementDetail views in the database? This looks like a data issue. Once I look at the data, I will email you the modified view definitions.

Thank you,
Mehul Thakkar

Mar 30, 2010 at 3:37 PM
DeviceDetail:

'e7a5235d-cb6f-4864-a96e-a8686f36e599', 1, , 'SHELBY', 'Shelby', 0, 29, 1, 2, 2, 3, -89.803823, 35.387099, 1, 'transportProtocol=File; file=Sample1344.PmuCapture', '', 30, 0, 35, '', 3, 0, 1, 'Tennessee Valley Authority', 'TVA', 'TVA', 'DEVARCHIVE', 'ABB', 'ABB-521', 'IEEE 1344-1995', 'Eastern Interconnection', 'Development', ''

MeasurementDetail:
29, 'TVA', 'Tennessee Valley Authority', '069c5e29-f78a-46f6-9dff-c92cb4f69371', 1, 'DEVARCHIVE', '', 5, 'TVA_SHEL-BUS1:ABBV', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 3, 1, '500 kV Bus 1', 'V', '+', 'SHELBY-PM1', 0, 1, 'Shelby ABB-521 500 kV Bus 1 Positive Sequence Voltage Magnitude', 1, 'Volts', 'Phasor', 'VPHM', 'Voltage Magnitude', 'PM', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', '25355a7b-2a9d-4ef2-99ba-4dd791461379', 1, 'DEVARCHIVE', '', 6, 'TVA_SHEL-BUS1:ABBVH', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 4, 1, '500 kV Bus 1', 'V', '+', 'SHELBY-PA1', 0, 1, 'Shelby ABB-521 500 kV Bus 1 Positive Sequence Voltage Phase Angle', 1, 'Degrees', 'Phasor', 'VPHA', 'Voltage Phase Angle', 'PA', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', '28bbb1fc-3434-48d3-87a8-bf5024c089d5', 1, 'DEVARCHIVE', '', 11, 'TVA_SHEL-DELL:ABBI', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 1, 4, 'Dell', 'I', '+', 'SHELBY-PM4', 0, 1, 'Shelby ABB-521 Dell Positive Sequence Current Magnitude', 1, 'Amps', 'Phasor', 'IPHM', 'Current Magnitude', 'PM', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', '34172112-0565-4ad7-b314-f0876d978751', 1, 'DEVARCHIVE', '', 9, 'TVA_SHEL-CORD:ABBI', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 1, 3, 'Cordova', 'I', '+', 'SHELBY-PM3', 0, 1, 'Shelby ABB-521 Cordova Positive Sequence Current Magnitude', 1, 'Amps', 'Phasor', 'IPHM', 'Current Magnitude', 'PM', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', '3647f729-d0ed-4f79-85ad-dae2149cd432', 1, 'DEVARCHIVE', '', 4, 'TVA_SHEL:ABBDF', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 6, , '', '', '', 'SHELBY-DF', 0, 1, 'Shelby ABB-521 Frequency Delta (dF/dt)', 1, '', 'PMU', 'DFDT', 'Frequency Delta (dF/dt)', 'DF', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', '65ac9cf6-ae33-4ece-91b6-bb79343855d5', 1, 'DEVARCHIVE', '', 3, 'TVA_SHEL:ABBD1', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 9, , '', '', '', 'SHELBY-DV1', 0, 1, 'Shelby ABB-521 Digital Value 1', 1, '', 'PMU', 'DIGI', 'Digital Value', 'DV', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', '70e72607-dbbc-458b-9c66-5fd32b447a03', 1, 'DEVARCHIVE', '', 10, 'TVA_SHEL-CORD:ABBIH', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 2, 3, 'Cordova', 'I', '+', 'SHELBY-PA3', 0, 1, 'Shelby ABB-521 Cordova Positive Sequence Current Phase Angle', 1, 'Degrees', 'Phasor', 'IPHA', 'Current Phase Angle', 'PA', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', '7aaf0a8f-3a4f-4c43-ab43-ed9d1e64a255', 1, 'DEVARCHIVE', '', 1, 'TVA_SHEL:ABBS', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 8, , '', '', '', 'SHELBY-SF', 0, 1, 'Shelby ABB-521 Status Flags', 1, '', 'PMU', 'STAT', 'Status Flags', 'SF', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', '93673c68-d59d-4926-b7e9-e7678f9f66b4', 1, 'DEVARCHIVE', '', 2, 'TVA_SHEL:ABBF', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 5, , '', '', '', 'SHELBY-FQ', 0, 1, 'Shelby ABB-521 Frequency', 1, 'Hz', 'PMU', 'FREQ', 'Frequency', 'FQ', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', '96cb33be-f7e4-4dfe-a20a-50976aa507fd', 1, 'DEVARCHIVE', '', 8, 'TVA_SHEL-BUS2:ABBVH', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 4, 2, '500 kV Bus 2', 'V', '+', 'SHELBY-PA2', 0, 1, 'Shelby ABB-521 500 kV Bus 2 Positive Sequence Voltage Phase Angle', 1, 'Degrees', 'Phasor', 'VPHA', 'Voltage Phase Angle', 'PA', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', 'bcd7aa41-32f1-4d3c-96d5-9e1da2c9469e', 1, 'DEVARCHIVE', '', 14, 'TVA_SHEL-LAGO:ABBIH', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 2, 5, 'Lagoon Creek', 'I', '+', 'SHELBY-PA5', 0, 1, 'Shelby ABB-521 Lagoon Creek Positive Sequence Current Phase Angle', 1, 'Degrees', 'Phasor', 'IPHA', 'Current Phase Angle', 'PA', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', 'c635e906-8bfb-486d-901e-46c8e07afdc3', 1, 'DEVARCHIVE', '', 12, 'TVA_SHEL-DELL:ABBIH', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 2, 4, 'Dell', 'I', '+', 'SHELBY-PA4', 0, 1, 'Shelby ABB-521 Dell Positive Sequence Current Phase Angle', 1, 'Degrees', 'Phasor', 'IPHA', 'Current Phase Angle', 'PA', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', 'ed6def67-54c4-4e74-af95-c95fa6915fbc', 1, 'DEVARCHIVE', '', 13, 'TVA_SHEL-LAGO:ABBI', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 1, 5, 'Lagoon Creek', 'I', '+', 'SHELBY-PM5', 0, 1, 'Shelby ABB-521 Lagoon Creek Positive Sequence Current Magnitude', 1, 'Amps', 'Phasor', 'IPHM', 'Current Magnitude', 'PM', -89.803823, 35.387099
29, 'TVA', 'Tennessee Valley Authority', 'ee130f0f-8c94-414f-b081-9551ffb73753', 1, 'DEVARCHIVE', '', 7, 'TVA_SHEL-BUS2:ABBV', '', 1, 'e7a5235d-cb6f-4864-a96e-a8686f36e599', 'SHELBY', 'Shelby', 30, 1, '', 2, 'ABB-521', 'ABB RES521', 3, 'Ieee1344', 'IEEE 1344-1995', 3, 2, '500 kV Bus 2', 'V', '+', 'SHELBY-PM2', 0, 1, 'Shelby ABB-521 500 kV Bus 2 Positive Sequence Voltage Magnitude', 1, 'Volts', 'Phasor', 'VPHM', 'Voltage Magnitude', 'PM', -89.803823, 35.387099
Apr 5, 2010 at 7:59 PM

Matt,

We were able to reproduce this bug against mySQL database in out development environment. It has been fixed and checked in to change set # 43021.

Thank you,
Mehul Thakkar