Property Data is not logging in to the Value Stream

[pshashipreetham]

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.

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.

[abjain]

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

[pshashipreetham]

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.

[abjain]

@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

[pshashipreetham]

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.

[pshashipreetham · Accepted solution]

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).

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,