Hello Tori,
My thing's properties have the options "logged" and "persistent" enabled
Here is the setup:
I have something like 10 things corresponding to LoRa devices.
I have a "callback interface" that is used by those LoRa devices to update their own properties.
On the callback interface I have a service "UpdateData" that will, thanks to a (unique) deviceID received as a parameter, update the properties of the related thing and store those new properties in a stream.
The devices call that "UpdateData" service every 15 minutes.
Here is the script of the service :
// define the log prefix
var logPrefix = me.name +"::LoRa.CallbackDataSet: ";
//##################-- calling OpenWeather webservice --##################
var OWparams = {
url: "http://api.openweathermap.org/data/2.5/weather?lat="+Latitude+"&lon="+Longitude+"&units=metric&appid=**************************************" /* STRING */
};
// result: JSON
var OWresult = Resources["ContentLoaderFunctions"].GetJSON(OWparams);
if (OWresult != undefined)
var externalTemp = OWresult.main.temp;
else {
var externalTemp = 0;
logger.error(logPrefix + " Failed to retrieve the external temperature from OpenWeather.");
}
//---------------- end of calling of OpenWeather webservice ----------------
//#############-- try to find a thing that has the given deviceid --#############
var thingName = me.getLoRaDeviceFromDeviceID({deviceId: DeviceID});
if(thingName == "") {
logger.error(logPrefix + " Failed to find thing provisioned for sigfoxId: " + DeviceID);
throw "Failed to find thing provisioned for sigfoxId: " + DeviceID;
}
//-------------------------------------------------------------------------------
var dateNow = new Date();
//####################-- Setting params --####################
// location:LOCATION
var myLocation = new Object();
myLocation.latitude = Latitude;
myLocation.longitude = Longitude;
myLocation.elevation = Altitude;
myLocation.units ="WGS84";
Things[thingName].Temperature = Temperature;
Things[thingName].ExtTemperature = externalTemp;
Things[thingName].BatteryLifetime = BatteryLevel;
Things[thingName].FridgeHumidity = Humidity;
Things[thingName].FridgeLocation = myLocation;
Things[thingName].RSSI = RSSI;
Things[thingName].SNR = SNR;
Things[thingName].SpreadFactor = SpreadFactor;
Things[thingName].LastCommunication = dateNow;
//-----------------------------------------------------------
//####################-- Saving fridge value into stream --####################
var values = Things["SmartFridgeDataStream"].CreateValues();
values.RSSI = RSSI; //NUMBER
values.Temperature = Temperature; //NUMBER
values.ExtTemperature = externalTemp; //NUMBER
values.SNR = SNR; //NUMBER
values.SpreadFactor = SpreadFactor; //NUMBER
values.FridgeHumidity = Humidity; //NUMBER
values.BatteryLifetime = BatteryLevel; //NUMBER
values.FridgeLocation = myLocation; //LOCATION
var params = {
values: values /* INFOTABLE*/,
location: myLocation /* LOCATION */,
source: thingName /* STRING */,
timestamp: dateNow /* DATETIME */
};
// no return
Things["SmartFridgeDataStream"].AddStreamEntry(params);
//-----------------------------------------------------------
Normally I'm supposed to receive the parameters through HTTP POST request (that part is working fine I could test it by logging the received parameters.
But simply by clicking the "test" button of that update data service, I can clearly see that the script is successfully executed and that the properties of my things are updated. But nothing is added in the stream, and nothing appears in the logs.
Another important detail to know, We have another Thingworx platform setup (default installation with H2 default DB) and everything is working fine on that one !
It is on our new production setup, with PostgreSQL that it is not working (everything in HA).
