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

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

Property Data is not logging in to the Value Stream

pshashipreetham
17-Peridot

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.

 

Shashi Preetham
1 ACCEPTED SOLUTION

Accepted Solutions

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,

Shashi Preetham

View solution in original post

5 REPLIES 5

@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?

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.

Shashi Preetham

@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

Hi @abjain ,

Apologies for the delay, the issue was fixed somehow without any clue in QA Env, now this issue is getting replicated in PROD Env, Trying to Open a Support case with PTC.

Thanks,
Shashi.

Shashi Preetham

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,

Shashi Preetham
Top Tags