Skip to main content
Jul 8, 2022 1:01 PM UTC
Solved

Property Data is not logging in to the Value Stream

Migrated the Postgres DB from 10 to 13, but after the migration, data is not logging in to the ValueStream. Below is the Property Settings image.

Shashi_Preetham_0-1657285120115.png

The DataTable entries are stored in DataTable Tables in DB, but not the Property values in the ValueStream Table. What would be the potential issue, or how can this issue be debugged?

Thanks,
Shashi.

 

Dec 25, 2022 11:12 AM UTC

So,

Root Cause: Due to a performance issue number of threads to be submitted for logging the value in DB are on the waiting list (in Queue).

Shashi_Preetham_0-1671966667274.png


Restarted the Thingworx Server, which fixed the issue as a temporary fix.


Performance is due to querying the 7000 DataTables Entries in a Service that runs every minute.

Thanks,

5 replies

Jul 11, 2022 5:21 AM UTC

@pshashipreetham Is it for one specific property only or in general data is not getting logged to value stream? Please check the thing on which this property is defined as to whether value stream has been defined for that?

Also try creating a new thing , value stream and property and check whether it happens for it also?

Jul 14, 2022 10:16 AM UTC

Hi @abjain ,

Thanks for the reply, done all sorts of experiments, but not able to find the root cause. I assuming it is the write permission issue from the user I connected in the platform-settings.json. NOT SURE !!!

Thanks,
Shashi.

Jul 18, 2022 5:37 AM UTC

@pshashipreetham Any error which you have seen in the application/error logs while writing data to value stream? If this is user specific , have you tried with Administrator

pshashipreethamAuthorAnswer
Dec 25, 2022 11:12 AM UTC

So,

Root Cause: Due to a performance issue number of threads to be submitted for logging the value in DB are on the waiting list (in Queue).

Shashi_Preetham_0-1671966667274.png


Restarted the Thingworx Server, which fixed the issue as a temporary fix.


Performance is due to querying the 7000 DataTables Entries in a Service that runs every minute.

Thanks,