I just received an Unexpected Error. The error is Null in Variable Name

[rvrdadd1]

An unexpected error has occurred trying to load the app. Check [Logs]

Error: java.sql.SQLException: NULL not allowed for column "GLOBAL_VARIABLE_NAME"; SQL statement: UPDATE app_id_global_variable_link SET global_variable_name = ? WHERE global_variable_name = ? [23502-224] Query: UPDATE app_id_global_variable_link SET global_variable_name = ? WHERE global_variable_name = ? Parameters: [null, bedroom_delayed_off]

[joshlobe]

Hey there.. and welcome!
Where exactly are you seeing this error?
Are you writing a custom app?

[user3115]

Hi,

im getting the same error in Settings>Hub Variables.

Error: java.sql.SQLException: NULL not allowed for column "GLOBAL_VARIABLE_NAME"; SQL statement: UPDATE app_id_global_variable_link SET global_variable_name = ? WHERE global_variable_name = ? [23502-224] Query: UPDATE app_id_global_variable_link SET global_variable_name = ? WHERE global_variable_name = ? Parameters: [null, SetPointHigh]

before getting this i deleted two variables i was not using and then tried to Rename another variable. I choose not to rename the variable and then chose cancel. Right after this i got the error.

Now when I click on Hub Variables i get a page with this error on it. Cant reach my variables!

[bertabcd1234]

See if any of this advice applies to your situation:

Hub Variables option, on Settings menu, not working (error message)

This might help: If you don't have any connectors, removing the app is harmless; if you do, they'll break and need to be re-created unless Bruce is able to personally assist in that manner again. If you know what caused the app to end up in this state, that might also be helpful for them to see if there is a way to prevent it in the future.