QueryPropertyHistory service no storing any data

[Pratik_Aswale]

Hello,

I have a simple remote thing and 1 property which is logged and persist the data change is also set to value.

It is getting data from Kepware using industrial connection, on composer it is changing data but on QuryPropertyHistory no data is reflecting please check screenshot.

Thanks

[Velkumar]

Hi @Pratik_Aswale 

Do you see any error message related to remote thing in Application log?

Also check whether you have assigned ValueStream to remote thing

/VR

[Pratik_Aswale]

Hello,

There are no errors in application logs and I have also attached VS to remote thing

[Rocko]

Did you assign a value stream to the thing?

[Pratik_Aswale]

Yes I have assigned a value stream

[Rocko]

Sorry, missed that in your other reply. To isolate the problem: When you remove the binding and update the value manually, does it work then?

[Pratik_Aswale]

Hi ,

I removed the binding and manually changed the values still I am getting blank infotable in service

[Rocko]

now add a new property, just logged, not persisted, no index, and try with that one. Also try restarting the platform, if possible.

[Pratik_Aswale]

Hi,

I have created a new property with only log enabled, and also restarted tomcat. Still no result. PFA

[Rocko]

Ok last resort is to switch the thing to another VS. If that doesn't work, create a ticket with support.

[Pratik_Aswale]

Hi,

I tried switching VS not helped, I have opened support ticket. Thanks for the help

[Rocko]

Once this is resolved, please post the resolution here for everyone's learning.

[Pratik_Aswale]

Yeah Sure

[Velkumar]

Hi @Pratik_Aswale 

One last suggestion, have you tried after restarting Platform & Database ?

/VR

[Pratik_Aswale]

Yes I have restarted Platform and DB

[Pratik_Aswale]

Hello,

I noticed a strange thing QueryPropertyHistory is working when I change property data type to String.

PFA

[Pratik_Aswale · Accepted solution]

Installed a fresh new DB and it working fine now, I guess there was some issue in backed corruption of data.

Thanks.