Infotable data loss

Question

Hello there,I've just lost a month's worth of data which is stored in Thing's infotable property. It happened to me few times and I cannot pinpoint what exactly is causing it.Most often it happens in the 'edit' mode, though the work conducted has nothing to do with that infotable. The property is set as persistent. The infotable is part of the ThingShape which in turn is inherited by the ThingTemplate. An entry is made on an hourly basis by a service.Does anyone know why it happens and how to prevent such events?What happens when the service creates an entry in the infotable, the thing is in the 'edit' mode and the user clicks 'cancel'?Tomcat 8.0.38, psql 9.4.11, Win 2012 r2Thanks.

CarlesColl · Accepted Answer

Ok the code it's wrong

Persistence on Infotable Properties only happens when there's a DataChange event, and the way you are adding rows doesn't throws data change event o that property.

To ensure a DataChange event it's thrown on a Infotable Property you must rewrite the whole property not just adding a row.

Then the correct code for interacting with a Persistent Infotable Property it's:

var copy = Resources["InfoTableFunctions"].Clone({ t1: me.myInfoTableProperty });

var newEntry = { };

copy.AddRow(newEntry);

// -- And this is the key to force persistence

me.myInfoTableProperty = copy;

CarlesColl · Answer

First of all, Infotable properties aren't designed to store hourly basis data, that's a lot of data for a Infotable Property ( they keep in memory... )

Anyway, how it's your code that records hourly basis data on the infotable property?

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded