Skip to main content
1-Visitor
September 20, 2018
Question

Dynamically adding properties to a thing

  • September 20, 2018
  • 1 reply
  • 3397 views

Hello,

I am adding properties dynamically at run-time to a thing (say, 'Thing_1'). In 'Thing_1', the properties are added simultaneously from multiple Things (say, 'Thing_A', 'Thing_B', 'Thing_C'). Sometimes all these, properties are added to 'Thing_1' but most of the time I am getting the error - 

 

JavaException: com.thingworx.common.exceptions.ModelAccessException: [1,012] Data store timeout error: [Error occurred while accessing the model provider.]

 

I am using default H2 database as persistence provider, and my Thingworx version is: 8.1.0.

I have observed this error many times and I am not able to find the appropriate cause for it so that I can fix it, but in this one scenario, the probability of occurrence of this error is very high.

I also read couple of old posts mentioning this error and have found that this is mostly related to database configuration, but in my case I am using the default persistence provider with Thingworx.

Please let me know the probable cause of it and also if any other input is required from my end.

Thanks in advance

Aditya Mittal

1 reply

Support
September 21, 2018

Hi @amittal-3.

 

Here is an article that may explain what is occurring.  If you are unable to resolve the issue after reading this, please provide a .zip of the logs located at \ThingworxStorage\logs.

 

Regards.

 

--Sharon

 

If my response has answered your question, please mark as Accepted Solution, for the benefit of others who may have the same question.

amittal-31-VisitorAuthor
1-Visitor
September 24, 2018

Hello Sharon,

Thanks for your response. I did had a look on the article. It mentions that possible cause of the issue could be multiple entries in 'system_ownership' table.

I am using default H2 database and am using RazorSQL to view the database tables. But when I fire query

select * from system_ownership;

I get the error as "ERROR: Table "SYSTEM_OWNERSHIP" not found". Is the name of the table changed or under which category can this table be found.

Regards

Aditya

Support
September 28, 2018

Hi @amittal-3.

 

After taking a closer look at this, I think we need to review your ThingWorx logs.  Can you please provide the logs located at \ThingworxStorage\logs?

 

Regards.

 

--Sharon