I recently got an error message and it turns out the reason for it was because I hadn't set my Ignition Designer to 'Read/Write' mode, so all read queries would work fine but I couldn't write data to the database. This was difficult to diagnose because of verbose error messages that in no way highlighted the main cause of the issue. The real reason 'Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Cannot run this function when in read-only mode.' about 2/3rds of the way down at the 2nd line that starts with 'Caused By:', very hard to find. If the error message stack trace in the script console were collapsed and expandable at the users request, with only the core error message info shown, it would be much easier to debug. See the attached PDF which shows the difference between the 2 error messages, which is pretty stark.