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

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

Timeseries data is not logging into Value stream in Thingworx 8.5.4

vi1
16-Pearl
16-Pearl

Timeseries data is not logging into Value stream in Thingworx 8.5.4

Hi,

 

I am using the Thingworx 8.5.4 in Thingworx HA configuration.

I have observed below issue.

"Timeseries data is not logged into Value stream but data is updating into Remote thing."

Below setting are given to property.

Data Change Type is "Always" and logged is selected

Whenever if restart the Remote Thing, its logging the timeseries data into value stream upto 2 change values.

I did not observe in Thingworx 8.2.5 and Thingworx 8.5.1 version with same thingworx source code

I have verified with "QueryNamedPropertyHistory" and "QueryPropertyHistory" to check the timeseries data. Refer the attached screenshot.

Any one knows what is the reason? why its not logging into value stream?.

I have restarted Azure postgre sql service (Version 10)  and restarted Tomcat also.

Thank you in Advance...

Regards,

Latha

 

 

5 REPLIES 5
raluca_edu
17-Peridot
(To:vi1)

Hi,

 

How many rows has value_stream table? Are there any errors in Thingworx logs or db logs?

What persistence provider you use?

 

Thanks,

Raluca Edu

vi1
16-Pearl
16-Pearl
(To:raluca_edu)

Hi ,

 

Thank you for response.

 

I am using the Azure PostgreSQL 10 version  for default persistence provider in Thingworx.

 

I did not observe any error logs on Thingworx. I will check on postgre sql logs.

where can I check no of rows in  value_stream table?.

 

Thanks&Regards,

Vidyullatha

 

vi1
16-Pearl
16-Pearl
(To:vi1)

Hi,

 

I have observed below errors on Thingworx Application Logs.

 

2020-03-23 02:28:56.182-0700 [L: ERROR] [O: c.t.s.s.e.QueuedEvents] [I: ] [U: SuperUser] [S: ] [P: ] [T: http-nio-80-exec-1] Failed to dispatch event. Invalid Thing In Event Type.Thing:Entity.PersistentSessioned91f09d-68ff-4bd9-990c-792edeb98286:Event.DataChange:Property.isConnected:PersistentSessioned91f09d-68ff-4bd9-990c-792edeb98286
2020-03-23 02:28:56.182-0700 [L: ERROR] [O: c.t.s.s.e.QueuedEvents] [I: ] [U: SuperUser] [S: ] [P: ] [T: http-nio-80-exec-1] Failed to dispatch event. Invalid Thing In Event Type.Thing:Entity.PersistentSessioned91f09d-68ff-4bd9-990c-792edeb98286:Event.AnyDataChange:PersistentSessioned91f09d-68ff-4bd9-990c-792edeb98286

 

Thanks&Regards,

Vidyullatha

raluca_edu
17-Peridot
(To:vi1)

Hi,

 

Connect to Azure PostgreSQL  db and run the following query to find the number of rows:

 

select count(*) from value_stream;

 

Raluca Edu

vi1
16-Pearl
16-Pearl
(To:raluca_edu)

Hi,

 

I am unable to run the query tool.

 

Observation  on Thingworx:

 

If create the Thing, assign Value stream and update the property values through service manually without any remote binding, time series values are storing into value stream.

 

If create the Thing ,assign Value stream and bind the remote property values to thing properties, time series values are not storing into value stream.

Is there any changes on plotform settings file?. Below is the persistent provider settings.

 

"PersistenceProviderPackageConfigs":
{
"PostgresPersistenceProviderPackage":
{
"ConnectionInformation":
{
"acquireIncrement": 5,
"acquireRetryAttempts": 3,
"acquireRetryDelay": 10000,
"checkoutTimeout": 1000000,
"driverClass": "org.postgresql.Driver",
"fetchSize": 5000,
"idleConnectionTestPeriod": 60,
"initialPoolSize": 5,
"jdbcUrl": "XXX",
"maxConnectionAge": 0,
"maxIdleTime": 0,
"maxIdleTimeExcessConnections": 300,
"maxPoolSize": 1000,
"maxStatements": 100,
"minPoolSize": 5,
"numHelperThreads": 8,
"password": "XXX",
"testConnectionOnCheckout": false,
"unreturnedConnectionTimeout": 0,
"username": "XXX"
},
"StreamProcessorSettings":
{
"maximumBlockSize": 2500,
"maximumQueueSize": 250000,
"maximumWaitTime": 10000,
"numberOfProcessingThreads": 5,
"scanRate": 5,
"sizeThreshold": 1000
},
"ValueStreamProcessorSettings":
{
"maximumBlockSize": 2500,
"maximumQueueSize": 500000,
"maximumWaitTime": 10000,
"numberOfProcessingThreads": 5,
"scanRate": 5,
"sizeThreshold": 1000
},
"PersistentPropertyProcessorSettings":
{
"maximumBlockSize": 2500,
"maximumWaitTime": 1000,
"maximumQueueSize": 100000,
"numberOfProcessingThreads": 20,
"scanRate": 25,
"sizeThreshold": 1000
}
}

 

Thanks&Regards,

Vidyullatha

 

Announcements


Top Tags