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

Getting data from historian web service

Oct 22, 2009 at 7:21 PM

Hello,

I'm trying to get data from the historian web service.

I installed OpenPDC, configured an equipment and it's working. I can get the pdc output using the 'pmu connection tester'.

I try to list the metadata for the measurements using the web service call:

http://localhost:8600/historian/metadata/read/xml

and get this as result:

<Metadata xmlns="http://schemas.datacontract.org/2004/07/TVA.Historian.Services" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<MetadataRecords />
</Metadata>

The result is empty. Did I miss some configuration or did something wrong?

 

Best Regards,

Luiz Henrique

Coordinator
Oct 22, 2009 at 8:21 PM

Hi Luiz,

First, I would like to make sure that you have configured the openPDC to receive data from your device. If you have done so, please make sure that the HistorianMetadata query/view in the Access database returns the measurements you have defined for your device since this is the metadata used by the historian. If everything in the Access database is configured correctly then when the openPDC starts up, you should see "AdoMetadataProvider has started metadata refresh..." message when the in-process historian is quering metadata from the Access database's HistorianMetadata view and then see "AdoMetadataProvider has finished metadata refresh" message when metadata import is complete. Once the metadata import/refresh is complete you should be able to retrieve the metadata and any archived data using the historian web services.

- Pinal

Oct 22, 2009 at 8:56 PM
Edited Oct 23, 2009 at 11:59 AM

Thank you very much!

The problem was the file location.

I used the installers, and openpdc (adometadataprovider) looks for the file in another directory (c:\windows\system32\openPDC.mdb).

I edited the file 'C:\Program Files\TVA\openPDC\openPDC.mdb'. When I started openpdc service, that's the output:

--------------------------------------------------------

[DEVARCHIVE] Attempting connection...

[DEVARCHIVE] AdoMetadataProvider has started metadata refresh...

[DEVARCHIVE] ERROR: Could not find file 'C:\WINDOWS\system32\openPDC.mdb'.

[DEVARCHIVE] Connection established.

--------------------------------------------------------

I put the full path in config file and it worked! :)

 

Thanks for you help!

Coordinator
Oct 23, 2009 at 12:32 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.