cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted

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

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 3
Highlighted

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

Are you able to share your JavaScript?

 

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

Highlighted

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

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 ?

Highlighted

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

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?

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!