When running the Send Message [WIN] component or similar components that store text in a variable, there is an unstated 225-character limitation on the string length. This is due to the way this variable is stored in our database (MySQL).
- Datto RMM
If you enter a message that is greater than 255 characters, you will see the following error message:
could not insert: [com.centrastage.csm.JobVariable]; SQL [insert into job_variable (version, component_idx, job_id, value, variable_id) values (?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert: [com.centrastage.csm.JobVariable]
This limitation is due to the data type of the variable storing this message in our database. The MySQL data types that have 255 limits are:
Currently, the only solution is to shorten the message. Datto RMM recommends posting a feature request on our community forum if you would like to see this limit increased in the future.
- MySQL string data types (external article)