Skip to main content
C
csadouq1-Visitor
1-Visitor
May 7, 2018
Solved

Error Connecting Thingworx to MySQL Server

  • May 7, 2018
  • 6 replies
  • 4397 views

Hello,
I am trying to connect Thingworx to MySQL Database to store and read data but it doesn't seem to connect to it. I am constantly getting the error message "Unable to Invoke Service <Service> on <ThingName> : null" when running a simple service to query available data on the database. The isConnected property on my thing is always False, i used MySQLThingTemplate for the Thing.

I created a new user and have granted it all the permissions on the database server and i can access it from another device.

here is a screenshot of the setup.
I would really appreciate some help on this topic.

Thanks.

Best answer by supandey

@csadouq i could reproduce this and just replied to an another user with the steps with which i managed to get it working, you might want to review this thread for my latest response : https://community.ptc.com/t5/ThingWorx-Developers/Unable-to-Invoke-Service-on-MySqlThing-null-using-MySQL/m-p/548602#M28322 

6 replies

S
supandey5-Regular Member
5-Regular Member
May 8, 2018

Hi @csadouq do I understand it right that you have this issue even with the Administrator user for Thingworx? Have you checked if the MySQL server is reachable from the machine where you ThingWorx is installed, or are they both on same machine?

C
csadouq1-VisitorAuthor
1-Visitor
May 10, 2018

They are both on the same machine, and i am using the local network address to avoid problems, i tried accessing to it from another machine and it worked but it doesn't seem to work from Thingworx

S
supandey5-Regular Member
5-Regular Member
May 11, 2018

Thanks for adding more info, could you please also let me know what template your Thing is based of? Would it be possible to share screenshot?

Terms & ConditionsAccessibility statement