Skip to main content
M
Mr_Henry_M1-Visitor
1-Visitor
May 17, 2019
Solved

Problems with ThingWorx Edge ADO Service

  • May 17, 2019
  • 4 replies
  • 2618 views

Hello!

 

I'm trying to deal with the ThingWorx Edge ADO Service. I performed the configuration for the AdoThing.config file, specifying the address, port and Appkey - as well as the type of my database driver (Excel) and the ConnectionString. I also created an AdoThing Thing like a remote database. But there is no connection at the moment. I'm sure that I made some mistake and didn't take into account something, but I don't know what and where. Please, help.

 

1.png

 

2.png

 

3.png

 

 

Best answer by Mr_Henry_M

In addition to this I discovered the following in the Application Log:

 

2019-07-16 15: 32: 14.092 + 0400 [L: ERROR] [O: ctcpmDispatchingServerCommunicationModule] [I:] [U:] [S:] [T: http-nio-8085-exec-4] Application key 'ADO' expired!
2019-07-16 15: 32: 14.108 + 0400 [L: ERROR] [O: ctcscjJsr356ServerConnection] [I:] [U:] [S:] [T: http-nio-8085-exec-4] Unable to send error ResponseMessage [details: Error [context: authenticating connection] [cause: Application key 'ADO' expired!], cause: WebSocket session is not open, cannot get Basic RemoteEndpoint]
2019-07-16 15: 32: 14.108 + 0400 [L: ERROR] [O: ctcscjJsr356ServerConnection] [I:] [U:] [S:] [T: http-nio-8085-exec-4] Error [ authenticating connection], Server websocket will be closed. cause: Application key 'ADO' expired!

 

After creating a new key and editing AdoThing.config it all worked.

4 replies

T
tmisner16-Pearl
16-Pearl
May 21, 2019

Hello Mr_Henry_M,

 

Thank you reaching out on the ThingWorx Developer Community.

 

Looking at the details provided in your initial post can you confirm first that you have proceeded through all of the steps within the ThingWorx ADO Service Configuration Guide. Perhaps a step was missed from this guide.

 

Additionally can you confirm what happens when you attempt to run ThingWorxADOService.exe per step 4 on Page 13 of the above guide? Are you shown any errors in the console? Furthermore, is any logged in the ThingWorx Application Log or Error Log when the AdoThing fails to connect?

 

Regards,

Tyler Misner

ThingWorx Technical Support Engineer

M
Mr_Henry_M1-VisitorAuthor
1-Visitor
May 22, 2019

Hello. Thank you for your answer. I installed ADO Service using a different instruction, and step 4, which you mention, goes there at the very beginning. Only after its successful execution AdoThing.config file is created. And here is the opposite. Anyway, I don't see any records in the logs associated with this connection. Most likely, there are no errors, because there was not even an attempt to establish a connection.

 

As it seems to me, this is due to the incorrect filling of the AdoThing.config file. For example, I don't quite understand what needs to be specified for the "port" in the screenshot above. Making a request for ports, I saw the following:

 

 

Ports.png

 

And it's not clear which port is the port of the ThingWorx Server. If we are simply talking about TCP, then it should be "443", as I understand it, that is, the default value

Terms & ConditionsAccessibility statement