After upgrading the Atrium Gateway to Platform Version: v1.1.2, our sensor wont come back

Hi,

First I apologize for this. The Atrium Gateway is still noted as Beta for reasons such as this. We are still solidifying over the air software updates.

Could you first ensure the sensor is still functioning? Remove the lid from the sensor and press the CFG button. You should see the LED inside the sensor turn on when the CFG button is pressed. This indicates it is on and the batteries are still good. If that works press and release the RST button. After a few seconds you should see that same STAT light in the sensor flash indicating it is sending data.

If you can confirm the sensor is in fact working by following the previous steps then open Node-Red on the gateway by opening your browser and entering ncd-a798.local:1880 Click the debug button which looks like a bug in the upper right corner of the window. Below that make sure the drop down is set to “all nodes”. Now press and release the RST button on the sensor. Let me know if you see any error messages in the debug log.

Thank you,
Travis

3/5/2026, 11:50:52 AMnode: Query devicesmsg : error

“Error: SQLITE_ERROR: no such column: d.last_status”

3/5/2026, 11:51:52 AMnode: Query devicesmsg : error

“Error: SQLITE_ERROR: no such column: d.last_status”

3/5/2026, 11:52:52 AMnode: Query devicesmsg : error

how do i factory reset the [Atrium-Gateway]

You will not want to factory reset the Gateway as that would clear all software.

It looks like the devices table schema for the SQLite DB table is missing the last_status column. This is why the device is not being entered into the table.

To fix this open the SQLite Console in the Atrium web interface. In the SQL Query field enter:

ALTER TABLE devices ADD COLUMN last_status TEXT;

Now clear that out and enter this in the SQL Query field to pre populate that column for all sensors with a default value:

UPDATE devices SET last_status = 'unknown' WHERE last_status IS NULL;

After doing this see if the Sensors page updates. If not check to see if there are any other issues in the Node-Red Debug log.

Let us know what you find.

Thank you,
Travis Elliott

unfortunately i tied to revert back to the existing version and now it looks like it’s back to 1.0.0 it’s not a big deal to reset we were using this unit in house for testing purposes.

Oh boy. I would say you’re going to need to send that Atrium Gateway back here at this point. The amount of time and frustration it would take to get this corrected at this point justifies returning the unit to us so we can correct it.

You can fill out an RMA here:
https://ncd.io/contact-us/product-returns/