Skip to main content
D
dunnowhattogive1-Visitor
1-Visitor
July 18, 2019
Question

Error : " Must have a datashape defined to add rows"

  • July 18, 2019
  • 3 replies
  • 2460 views

Hello all,

I have been following this tutorial of sorts to connect Thingworx to external databases.

https://developer.thingworx.com/en/resources/guides/external-databases/external-database-read

I'm using a MySQL database. the problem arises when I am trying to run a javascript based query service. I am not getting any results to the query when I run the service and the reason is quoted as  " Must have a datashape defined to add rows".

3 replies

T
thingw0rxgenie5-Regular Member
5-Regular Member
July 18, 2019

Are you able to share your JavaScript?

 

This sounds like you're attempting to add a row to an InfoTable without a DataShape assigned.

E
Etienne1-Visitor
1-Visitor
July 24, 2019

Hi team !

 

We use Thingworx 8.4.0.

 

We have the same error message over here : we created a custom JDBC connector extension with a service that queried a Cosmos DB instance, it was working fine but then we added new services and we got this message when executing either the original service or the new ones. The strangest thing is that we reverted to the old extension ZIP with proper uninstallation of the new extension, the problem remained !! We cleared the browser images & files cache but it's not changing a thing.

 

Any idea ?

T
thingw0rxgenie5-Regular Member
5-Regular Member
July 24, 2019

Are you able to pinpoint what line is causing the error by using log statements and checking the ScriptLog? Or do you believe it's something coming from the extension?

Terms & ConditionsAccessibility statement