This was working for quite some time but appears to be non-functional now. Attempting to end the settings using the SmartApp on either IOS or Android results in an error message like:
We're having trouble connecting. Check your network connection and try again.
The live log in SmartThings API shows this:
773dca6b-43b2-477f-84f7-b2851925764a 11:13:46 AM: error org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: [physicalgraph.device.Device#773dca6b-43b2-477f-84f7-b2851925764a]; uncategorized SQLException for SQL [update device set version=?, completed_setup=?, component_label=?, component_name=?, date_created=?, device_network_id=?, error_state=?, firmware_version_id=?, group_id=?, handler_version=?, hub_id=?, is_component=?, join_fingerprint_id=?, label=?, last_updated=?, location_id=?, name=?, parent_device_id=?, parent_smart_app_id=?, previous_handler=?, previous_zigbee_id=?, primary_tile_name=?, profile_id=?, profile_type=?, protocol_connection=?, raw_description=?, sort_order=?, type_id=?, virtual_smart_app_id=?, zigbee_id=? where id=? and version=?]; SQL state [25S03]; error code [0]; (conn=1122825) Communications link failure with primary host na02useast1-datamgmt.cluster-cojnp12rqtju.us-east-1.rds.amazonaws.com:3310. Connection timed out; nested exception is java.sql.SQLException: (conn=1122825) Communications link failure with primary host na02useast1-datamgmt.cluster-cojnp12rqtju.us-east-1.rds.amazonaws.com:3310. Connection timed out @line 559 (updateSubscription)
This was working for quite some time but appears to be non-functional now. Attempting to end the settings using the SmartApp on either IOS or Android results in an error message like:
The live log in SmartThings API shows this:
773dca6b-43b2-477f-84f7-b2851925764a 11:13:46 AM: error org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: [physicalgraph.device.Device#773dca6b-43b2-477f-84f7-b2851925764a]; uncategorized SQLException for SQL [update device set version=?, completed_setup=?, component_label=?, component_name=?, date_created=?, device_network_id=?, error_state=?, firmware_version_id=?, group_id=?, handler_version=?, hub_id=?, is_component=?, join_fingerprint_id=?, label=?, last_updated=?, location_id=?, name=?, parent_device_id=?, parent_smart_app_id=?, previous_handler=?, previous_zigbee_id=?, primary_tile_name=?, profile_id=?, profile_type=?, protocol_connection=?, raw_description=?, sort_order=?, type_id=?, virtual_smart_app_id=?, zigbee_id=? where id=? and version=?]; SQL state [25S03]; error code [0]; (conn=1122825) Communications link failure with primary host na02useast1-datamgmt.cluster-cojnp12rqtju.us-east-1.rds.amazonaws.com:3310. Connection timed out; nested exception is java.sql.SQLException: (conn=1122825) Communications link failure with primary host na02useast1-datamgmt.cluster-cojnp12rqtju.us-east-1.rds.amazonaws.com:3310. Connection timed out @line 559 (updateSubscription)