Skip to main content
P
18-Opal
pshashipreetham18-Opal
18-Opal
July 8, 2022
Solved

Property Data is not logging in to the Value Stream

  • July 8, 2022
  • 2 replies
  • 2625 views

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.

 

Best answer by pshashipreetham

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,

2 replies

A
abjain15-Moonstone
15-Moonstone
July 11, 2022

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

    P
    18-Opal
    pshashipreetham18-OpalAuthor
    18-Opal
    July 14, 2022

    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.

    A
    abjain15-Moonstone
    15-Moonstone
    July 18, 2022

    @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

      P
      18-Opal
      pshashipreetham18-OpalAuthorAnswer
      18-Opal
      December 25, 2022

      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,

      Terms & ConditionsCookie settingsAccessibility statement