Customer Success Center

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Proficy Historian Connect....

KyuJang Lee May 18, 2017 02:31AM PDT

Hi,
I try to connect Proficy Historian 4.5 and 7.0, but I cannot connect to Proficy.
Please let me know the correct content of "GE Proficy Connector.json" file.
Could anyone who already connected Proficy Historian, tell me the way?

Up 0 rated Down
James DeMarco May 18, 2017 07:28AM PDT Seeq Corporation Analytics Engineer

Hi KyuJang,

To connect to Proficy 7.0 and up, the GE Proficy Connector is the way to go. For previous versions, it is necessary to configure an OPC-HDA connection via the OPC-HDA Connector.json. Both connector files can be found in C:\ProgramData\Seeq\data\configuration\link by default. Details of the OPC-HDA configuration may be found here:
https://seeq12.atlassian.net/wiki/display/KB/OPC-HDA+Connector. Please note it is generally significantly easier to establish a connection to OPC-HDA locally, since a local OPC-HDA connection does not require DCOM configuration. To configure the GE Proficy Connector, you can edit the GE Proficy Connector.json, which looks like this by default:

{
“Version” : “com.seeq.link.connectors.geproficy.config.GeProficyConnectorConfigV1”,
“Connections” : [ {
“Id” : “SOME_GUID_WILL_BE_HERE”,
“Port” : 8080,
“Host” : “localhost”,
“Username” : “ENTER_YOUR_GE_PROFICY_USERNAME_HERE”,
“Password” : “ENTER_YOUR_GE_PROFICY_PASSWORD_HERE”,
“Enabled” : false,
“Name” : “GE Proficy on localhost”
} ]
}

If you don’t see a file named “GE Proficy Connector.json” in the Seeq\data\link folder, you may need to go into “JVM Agent.json” in the same folder and change the “Enabled” property for GE Proficy Connector to true. Upon saving the file, the connector config JSON will be created. Host, port, username, and password are specific to your network and Proficy configuration, but Name and ID can be specified by you. The only restriction is that each ID must be a unique GUID within the config file, so if you create more than one connection, you will need to generate new GUIDs. Online GUID generators can help with this, for example, https://www.guidgenerator.com/.

It looks like your company is on the .kr domain, so I am assuming it is night time where you are! I am available to help if needed to ensure you are able to complete your configuration, so please let me know a good time to do so. I am on U.S. Eastern time (UTC-4 until October, then UTC-5), and I typically work from 10am to 6pm, but I can make myself available later some nights so that I can help our Asian and Australian counterparts in the morning. Let me know what times are best for you and I can set up a webconference via gotomeeting for further configuration support.

Cheers,
James DeMarco
Seeq Analytics Engineer

Up 0 rated Down
KyuJang Lee May 18, 2017 10:47PM PDT
Hi, James
Thank you for your reply.

I installed Proficy Historian 7.0 default setting as single server, no LDAP, user:admin, PW:123abc and edited GE Proficy Connector.json file as

{
"Version" : "com.seeq.link.connectors.geproficy.config.GeProficyConnectorConfigV1",
"Connections" : [ {
"Id" : "df0d38a9-f547-4a63-ac2c-c11e87354181",
"Port" : 8080,
"Host" : "localhost",
"Username" : "Admin",
"Password" : "123abc",
"Enabled" : true,
"Name" : "GE Proficy on localhost"
} ]
}

But, I can't connect Proficy as follow logs,

ERROR 2017-05-19T14:44:38.072+09:00 [Metadata sync for WIN-BJ2BAC5KMO: GE Proficy: GE Proficy on localhost] com.seeq.link.connectors.geproficy.GeProficyConnection - Metadata sync failure:
com.seeq.link.connectors.geproficy.errors.exceptions.Error401UserUnauthorizedException: Server returned an error (401 -- Error: Either you are not authenticated, or the authentication is incorrect.): Unauthorized
at sun.reflect.GeneratedConstructorAccessor31.newInstance(Unknown Source) ~[na:na]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_112]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_112]
at com.seeq.link.connectors.geproficy.errors.ServerErrorCode.throwExceptionIfError(ServerErrorCode.java:127) ~[seeq-link-connector-ge-proficy-0.33.00-v201704132029.jar:na]
at com.seeq.link.connectors.geproficy.datasource.GeProficy.renewLease(GeProficy.java:108) ~[seeq-link-connector-ge-proficy-0.33.00-v201704132029.jar:na]
at com.seeq.link.connectors.geproficy.datasource.GeProficy.doHttpGet(GeProficy.java:364) ~[seeq-link-connector-ge-proficy-0.33.00-v201704132029.jar:na]
at com.seeq.link.connectors.geproficy.datasource.GeProficy.queryTagNames(GeProficy.java:189) ~[seeq-link-connector-ge-proficy-0.33.00-v201704132029.jar:na]
at com.seeq.link.connectors.geproficy.datasource.GeProficy.queryTags(GeProficy.java:133) ~[seeq-link-connector-ge-proficy-0.33.00-v201704132029.jar:na]
at com.seeq.link.connectors.geproficy.GeProficyConnection.metadataSync(GeProficyConnection.java:94) ~[seeq-link-connector-ge-proficy-0.33.00-v201704132029.jar:na]
at com.seeq.link.sdk.BaseDatasourceConnection.lambda$spawnMetadataSync$2(BaseDatasourceConnection.java:267) ~[seeq-link-sdk-0.33.00-v201704132029.jar:na]
at com.seeq.link.sdk.utilities.ThreadCollection$1.run(ThreadCollection.java:59) ~[seeq-link-sdk-0.33.00-v201704132029.jar:na]
at java.lang.Thread.run(Thread.java:745) ~[na:1.8.0_112]

Please let me know what can I do....
Thanks
Up 0 rated Down
James DeMarco May 19, 2017 05:13AM PDT Seeq Corporation Analytics Engineer

Hi KyuJang,

Hmm, that implies that either the credentials provided in the config file are not succeeding the authentication step or that is preventing the use of valid credentials. To check the first possibility, could you please try the following command from a Command Prompt?

curl -u admin:123abc http://localhost:8080/uaa/oauth/token -d ‘grant_type=client_credentials’

This should provide a 200 response as well as a really long string of random letters and numbers. To run the command, you will need to have a curl utility installed on your machine. If you do not already have one, here is the one I use: http://www.confusedbycode.com/curl/. To check the second possibility, can you please send the log files? The most reliable way to do this is to first download the logs from the “View Logs” page in Seeq, then uploading them to this page: https://www.seeq.com/support. For more info on viewing/downloading logs from Seeq Workbench, there is this article from our knowledge base: https://seeq12.atlassian.net/wiki/display/KB/Sending+Log+Files+To+Seeq

I’d like to get your connection issue resolved ASAP, so please do let me know if there is a good time for us to do an online meeting.

- James

Up 0 rated Down
KyuJang Lee May 22, 2017 01:34AM PDT
Hi, James

I tried curl commands, but I can't fix it. And so, I created new VM and installed Proficy Historian 7.0 and Seeq. But same error with "0 items indexed".

I can send you zipped log file, but I can't attache it.

Thanks
Up 0 rated Down
James DeMarco May 22, 2017 08:18AM PDT Seeq Corporation Analytics Engineer

Hi KyuJang,

Once you have downloaded the logs to your local machine, you can use the Seeq support page’s upload tool to send the zip file to us. It is available here:

https://www.seeq.com/support

If for some reason the zip file cannot be uploaded there, please let us know and we will find another way. The other avenue is for us to meet in a gotomeeting session, which I could set up for 9am KST (UTC+9). My time zone is EDT (UTC-4) right now, so this would be 8pm for me (not a problem – I often work late). This way we could collaborate in real time to solve the issue. Please let me know so we can get your connection issues fixed right away.

Once I have the logs I can review them and also share them with the developer of the connector if needed. Once you send the logs, please send me a separate email letting me know you uploaded them to https://www.seeq.com/support so I can make sure they arrived.

Thanks,
James DeMarco

Up 0 rated Down
KyuJang Lee May 23, 2017 01:33AM PDT
Hi, James
I checked the license of Proficy Historian, and I found no HDA server license.
I think that the OPC HDA Connector cannot connect this Proficy Historian,
but I have one question, does "GE Proficy Connector" also use OPC HDA protocol?
If not, I want to know what module of Proficy Historian use in GE Proficy Connector.

Thanks you for your help.
Up 0 rated Down
James DeMarco May 25, 2017 12:25PM PDT Seeq Corporation Analytics Engineer

KyuJang,

The documentation for Proficy’s licensing is limited, so I am not sure if a separate license is needed. My understanding about versions of GE Proficy / Historian is that prior to v7, the REST API did not exist, and from v7 on, the OPC-HDA server feature is no longer supported, although I haven’t been able to confirm that yet. Support for OPC-HDA server is limited, as described here: http://help.geautomation.com/Historian55/Subsystems/iHISTHDASrv/content/getting_started.htm. No mention that I could find anywhere on that site about OPC-HDA server licensing. For the REST API, the guide we used to get things set up is here: http://help.geautomation.com/Historian55/Subsystems/iHistGS/content/restapi.pdf – I don’t believe we need anything above and beyond the base GE Historian to access the historical data via REST APIs . I think if you are able to successfully authenticate with the cURL request, we can be sure the issue is either (1) in the Seeq configuration file (capitalization of username/password, for example, or unrecognized hostname), or (2) in the connector itself. Hopefully it isn’t the latter, but if it is we will want to get it fixed right away. Thus we need to confirm the location of the issue. Would you be willing to meet via gotomeeting at 9am your time sometime in the next couple of days? I think we will be able to solve your connection issues effectively this way.

Thanks,
James DeMarco

Up 0 rated Down
KyuJang Lee May 25, 2017 06:57PM PDT
Hi, James
Thank you for your help.
I understand my problem, it's REST API setting for Proficy Historian. I will contact GE for this. I have tried some ways to access Proficy bia REST Client tool (Postman), but I can't read Proficy. Proficy REST API is some confused and difficult for setting.
I will contact you again, if I cannot fix it with GE people.

Thank you again for your help.
Up 0 rated Down
James DeMarco May 26, 2017 06:37AM PDT Seeq Corporation Analytics Engineer

KyuJang,

Often the IT configuration is the “long pole in the tent” for getting software to work well together. Good luck with sorting out the GE REST API…in the meantime, if you’d like to get a feel for the Seeq REST APIs, you can click on the menu button in the top-right corner of Seeq Workbench to select “API Reference”. The first API in the “Items” list, GET /items, can allow you to search for items in the Seeq database (there should already be some pre-populated Example data, including things like Area A_Temperature, Area B_Relative Humidity, etc.). You can put “name~=Area A” (no quote marks) in the filters field, then click “Try it out!” to see the response. It will also create a cURL request string that you can use at the Command Prompt to do the same request (you may have to replace the single quotes ’ with double quotes " first). This might also help you confirm there is not any other problem with making a cURL request on your system. Please do let me know how it goes with GE…once that is sorted out, let’s touch base to take the connector setup over the goal line!

Cheers,
James

Up 0 rated Down
KyuJang Lee May 28, 2017 10:05PM PDT
Hi, James

Thank you for your reply.

I success read Proficy data via Postman REST Client, but not yet read items in seeq with GE Proficy Connector.

As you mention about quotes in cURL command line, it's occured error for single quotes('), but it's OK for double quotes("). I can read access_token, and also I can read Proficy data with this token in Postman Rest client.

Please check seeq logs as follows,
.
.
WARN 2017-05-29T11:43:45.791+09:00 [Meradata sync for WIN-BJ2BAC5KMO: GE Proficy: GE Proficy on localhost] com.seeq.link.connectors.geproficy.datasource.GeProficy - Skipping tag: WIN-BJ2BAC5KMO.Simulation00001 due to error: Server return an error (400 -- Error: The request was malformed. The response body contains additional information.): Bad Request
.
.
INFO 2017-05-29T11:43:53.072+09:00 [Metadata sync for WIN-BJ2BAC5KMO: GE Proficy: GE Proficy on localhost] com.seeq.link.connectors.geproficy.GeProficyConnection - Metadata sync success

Best regards.
Up 0 rated Down
KyuJang Lee May 30, 2017 02:02AM PDT
Hi, James
I success read GE Proficy Historian today, but I must change time zone from +09:00 to 00:00 in my PC.

Please check the stat/end time format for connector.

Thanks
Up 0 rated Down
James DeMarco May 31, 2017 08:53AM PDT Seeq Corporation Analytics Engineer

Hi KyuJang,

Glad to hear the connection has been made. As for the time zone issue, I will talk with the lead developer on the GE Proficy connector to find out if he has any ideas about this and what to do to fix it. Are all of your Proficy servers now able to connect to Seeq?

- James

Up 0 rated Down
Edgar Hilton Jun 01, 2017 09:44AM PDT Seeq Corporation Analytics Engineer

Dear Mr. Lee,

I have received the request from our support specialist. I’m extremely happy to hear that you were able to connect through the REST API to your server.

Also, and based on the information that you have provided, we are presently attempting to recreate your problem. I will try to resolve this as quickly as possible.

-Edgar

Up 0 rated Down
Edgar Hilton Jun 07, 2017 04:04PM PDT Seeq Corporation Analytics Engineer

Dear Mr. Lee,

I am pleased to inform you that we have found the root of your problem, and you’ll be happy to know that it was, as you said, a time formatting problem. It appears that a third party library was improperly creating the time stamp that was being given from Seeq to the GE Proficy server.

I’m presently creating an installer with the fix and an updated version of Seeq. You should just be able to install it onto your machine and it will automatically upgrade your system. Our specialist, James, will provide you with the installer and further instructions as soon as it is completed.

Thank you again for your patience. Please don’t hesitate to contact us if you have any further problems.

-Edgar

Up 0 rated Down
James DeMarco Jun 08, 2017 08:41AM PDT Seeq Corporation Analytics Engineer

Hi KyuJang,

The updated installer is available here: https://seeq-my.sharepoint.com/personal/edgar_hilton_seeq_com/layouts/15/guestaccess.aspx?guestaccesstoken=ntcgu2mj0R9HcGbPBhAnhkfcmL8WYD6Q%2fhF%2f3WTClUA%3d&folderid=206161e88ed10b4a79b69f66d34705926d&rev=1. You will just need to download the file, which is named seeq-server-R17.0.33.03-64bit-windows.exe, and run it to install the upgrade as described here: https://seeq12.atlassian.net/wiki/display/KB/Installing+Seeq

Please let us know if this resolves your issue. Also, we would like to help you get connected with OPC-HDA to any additional servers you might have. The following page from our Knowledge Base has a lot of detail on how to do this for Proficy and other software that exposes an OPC-HDA interface: https://seeq12.atlassian.net/wiki/display/KB/OPC-HDA+Connector. I can provide additional support if needed for getting the OPC-HDA server configuration done.

Thanks,
James DeMarco

Up 0 rated Down
James DeMarco Jun 12, 2017 03:12PM PDT Seeq Corporation Analytics Engineer

HI KyuJang,

Have you had a chance to download and install the Seeq server from the link I sent in my last email? I want to make sure the bugfix actually fixed your bug! Once you have had a chance to test it out, could you let me know if it is working as expected? I’d also like to give you a quick tour around any Seeq features that might be of use to your efforts, if you have some time to meet.

Cheers,
James DeMarco

Up 0 rated Down
KyuJang Lee Jun 13, 2017 01:52AM PDT
Hi James,
I am some busy and couldn't check your message.
I can't open page for downloading the new file.

Please open again...

Up 0 rated Down
James DeMarco Jun 13, 2017 09:28AM PDT Seeq Corporation Analytics Engineer

Hi KyuJang,

I think there was a permissions issue with that link. Here is a new link:

https://seeq-my.sharepoint.com/personal/edgar_hilton_seeq_com/_layouts/15/guestaccess.aspx?docid=08cf7b57f302c4bc1af9baefa619e1fd3&authkey=ASygJ4DE7-GAbgYx6jduKzE

Edgar tested this one with a non-Seeq-internal recipient and it worked without issue – please let me know if the same is true for you. Also would like to work with you on the OPC-HDA configuration for any additional Proficy historians under your watch – let me know how I can help.

Thanks,
James DeMarco

Up 0 rated Down
KyuJang Lee Jun 13, 2017 06:51PM PDT
Hi James,

Great!!!! It's fixed, work well very good.

Anyway, I can't find Ge conector on Asset Trees root.
I can find HDA connector on this as like KEPServer HDA Historian.
I must search tags with Datasource filters, it's good.
But I think that I can find the connectors as datasource in Asset Trees.

Sorry for OPC-HDA connection as GE Historian, because I have no license now.

Thanks,
KyuJang Lee
Up 0 rated Down
James DeMarco Jun 14, 2017 09:01AM PDT Seeq Corporation Analytics Engineer

Hi KyuJang,

Glad to hear the connector is now working for you. I spoke with the developer on this, and I also checked the REST API guide from GE (http://help.geautomation.com/Historian55/Subsystems/iHistGS/content/restapi.pdf), and it does not seem like there is a way to access GE Proficy hierarchy, insofar as it exists, from the REST API – instead you can only retrieve a flat list from a request to the Tags list API. I have also seen the GE Proficy OPC-HDA Server data in an OPC-HDA Client tool as a (VERY LARGE) flat list on the top node of an OPC Browse tree, although that was for an older version of Proficy; 5.5, I think. Also, it may have been the case that that company was simply storing their tags that way…I am not sure.

Although it is a lot of work, if there is a hierarchy you would like to have for the Proficy tags, you can use the Seeq APIs to build a tree. Click on “API Reference” from the help menu in the top-right corner of Seeq Workbench to check the APIs. If you think this is something you would like to do, there are SDKs for Java, C#, and Python (and sample code) in the C:\Program Files\Seeq Server\sdk folder that you can use to do more advanced scripting with Seeq. Happy Seeqing!

Cheers,
James DeMarco

Up 0 rated Down
KyuJang Lee Jun 14, 2017 07:03PM PDT
Hi James,

Thanks for your many informations.

I must study Seeq more and more.....
Up 0 rated Down
James DeMarco Jun 14, 2017 07:37PM PDT Seeq Corporation Analytics Engineer

KyuJang,

There is much to learn! Our Head of Engineering just reminded me of a relatively new feature that may also help. It is called the Tree File Connector, and it uses regular expressions to build an asset tree in Seeq based on existing signals in the Seeq database. The details of this connector can be found in two html files within the Seeq data folder. By default on Windows, the data folder will be C:\ProgramData\Seeq\data. In the data\configuration\link folder, there is the Tree File Connector.json file and a descriptive html file “Tree File Connector Readme.html”. In the data\mydata\trees folder, there is the readme.html file that gives examples of how to structure the tree file. If your signal names already have a good nomenclature system, this could make building an asset tree relatively easy. Ping me any time if you have any questions…

Cheers,
James DeMarco

Post Your Public Answer

Your name (required)
Your email address (required)
Answer (required)
617c43f2656b1235fa6b5cafa8fcc064@seeq.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete