Cheers!
I've been working for a couple of months with Fiware, using Quantumleap and CrateDB to store historical data (which will then be displayed in Grafana).
I have created about 14 successful subscriptions through Postman for different sensors, but for the past couple of weeks I am struggling to create a new additional subscription.
Below I share the JSON that I am using to create this subscription (following the format that I have used in previous subscriptions):
{
"description": "Suscripcion a cambios de contexto CALCULATION",
"subject": {
"entities": [{
"idPattern": ".*",
"type": "CALCULATION"
}],
"condition": {
"attrs": [
"ActivePowerConsumedA1",
"ActivePowerConsumedA2",
"ActivePowerConsumedA3",
"EnergyShareA1",
"EnergyShareA2",
"EnergyShareA3",
"EquivalentTrees",
"FR1_B11_20Efficiency",
"FR1_B18_10Efficiency",
"FR1_B18_12.5Efficiency",
"FR2_B11_20Efficiency",
"FR2_B18_10Efficiency",
"FR2_B18_12.5Efficiency",
"GeneratedEnergyDayA1",
"GeneratedEnergyDayA2",
"GeneratedEnergyDayA3",
"GeneratedPowerA1",
"GeneratedPowerA2",
"GeneratedPowerA3",
"MI_B10_5Efficiency",
"PowerShareA1",
"PowerShareA2",
"PowerShareA3",
"SL_B11_28Efficiency",
"TotalActiveEnergyConsumedDay",
"TotalActivePowerConsumed",
"TotalEmissions",
"TotalEnergyShare",
"TotalGeneratedEnergy",
"TotalGeneratedEnergyDay",
"TotalGeneratedPower",
"TotalPowerShare"
]
}
},
"notification": {
"attrs": [
"id",
"ActivePowerConsumedA1",
"ActivePowerConsumedA2",
"ActivePowerConsumedA3",
"EnergyShareA1",
"EnergyShareA2",
"EnergyShareA3",
"EquivalentTrees",
"FR1_B11_20Efficiency",
"FR1_B18_10Efficiency",
"FR1_B18_12.5Efficiency",
"FR2_B11_20Efficiency",
"FR2_B18_10Efficiency",
"FR2_B18_12.5Efficiency",
"GeneratedEnergyDayA1",
"GeneratedEnergyDayA2",
"GeneratedEnergyDayA3",
"GeneratedPowerA1",
"GeneratedPowerA2",
"GeneratedPowerA3",
"MI_B10_5Efficiency",
"PowerShareA1",
"PowerShareA2",
"PowerShareA3",
"SL_B11_28Efficiency",
"TotalActiveEnergyConsumedDay",
"TotalActivePowerConsumed",
"TotalEmissions",
"TotalEnergyShare",
"TotalGeneratedEnergy",
"TotalGeneratedEnergyDay",
"TotalGeneratedPower",
"TotalPowerShare"
],
"http": {
"url": "http://quantumleap:8668/v2/notify"
},
"metadata": [
"dateCreated",
"dateModified"
]
}
}
As expected, I get HTTP response code 201 Created
Additionally, when I query OCB for subscriptions, I get, among the existing subscriptions created, the one I just created:
{
"id": "6388cc5324c929752900e240",
"description": "Suscripcion a cambios de contexto CALCULATION",
"status": "active",
"subject": {
"entities": [{
"idPattern": ".*",
"type": "CALCULATION"
}],
"condition": {
"attrs": [
"ActivePowerConsumedA1",
"ActivePowerConsumedA2",
"ActivePowerConsumedA3",
"EnergyShareA1",
"EnergyShareA2",
"EnergyShareA3",
"EquivalentTrees",
"FR1_B11_20Efficiency",
"FR1_B18_10Efficiency",
"FR1_B18_12.5Efficiency",
"FR2_B11_20Efficiency",
"FR2_B18_10Efficiency",
"FR2_B18_12.5Efficiency",
"GeneratedEnergyDayA1",
"GeneratedEnergyDayA2",
"GeneratedEnergyDayA3",
"GeneratedPowerA1",
"GeneratedPowerA2",
"GeneratedPowerA3",
"MI_B10_5Efficiency",
"PowerShareA1",
"PowerShareA2",
"PowerShareA3",
"SL_B11_28Efficiency",
"TotalActiveEnergyConsumedDay",
"TotalActivePowerConsumed",
"TotalEmissions",
"TotalEnergyShare",
"TotalGeneratedEnergy",
"TotalGeneratedEnergyDay",
"TotalGeneratedPower",
"TotalPowerShare"
]
}
},
"notification": {
"timesSent": 3,
"lastNotification": "2022-12-01T15:49:09.000Z",
"attrs": [
"id",
"ActivePowerConsumedA1",
"ActivePowerConsumedA2",
"ActivePowerConsumedA3",
"EnergyShareA1",
"EnergyShareA2",
"EnergyShareA3",
"EquivalentTrees",
"FR1_B11_20Efficiency",
"FR1_B18_10Efficiency",
"FR1_B18_12.5Efficiency",
"FR2_B11_20Efficiency",
"FR2_B18_10Efficiency",
"FR2_B18_12.5Efficiency",
"GeneratedEnergyDayA1",
"GeneratedEnergyDayA2",
"GeneratedEnergyDayA3",
"GeneratedPowerA1",
"GeneratedPowerA2",
"GeneratedPowerA3",
"MI_B10_5Efficiency",
"PowerShareA1",
"PowerShareA2",
"PowerShareA3",
"SL_B11_28Efficiency",
"TotalActiveEnergyConsumedDay",
"TotalActivePowerConsumed",
"TotalEmissions",
"TotalEnergyShare",
"TotalGeneratedEnergy",
"TotalGeneratedEnergyDay",
"TotalGeneratedPower",
"TotalPowerShare"
],
"onlyChangedAttrs": false,
"attrsFormat": "normalized",
"http": {
"url": "http://quantumleap:8668/v2/notify"
},
"metadata": [
"dateCreated",
"dateModified"
],
"lastSuccess": "2022-12-01T15:49:09.000Z",
"lastSuccessCode": 500,
"covered": false
}
}
When I go into CrateDB to verify the creation of the table, it simply does NOT show up.
Am I doing something wrong with this particular subscription?
What should I do to get this table to appear in CrateDB? since I need it to continue advancing in a project
I am attentive to the comments and I am very grateful for the collaboration.
I tried deleting and recreating the subscription and even the entity, hoping that after doing so, the table would be created after creating the subscription again.
The table was never created.
I tried to download the CrateDB service, whose version used is 5.0.0 and, after uploading it again, waiting for the table to appear, it still did not appear.
the solution i found was to modify the entity type, both in the context entities and in the subscription. For some reason, a table for entity type "CALCULATION" was not being created in crate