Datto RMM: Character limit for component variables

Follow

Topic

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).

Environment

  • Datto RMM

Description

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]

2019-03-11_16-19-09.pngFigure 1: Character limit error (click to enlarge)

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:

  • CHAR
  • TINTYBLOB
  • TINYTEXT
  • ENUM
  • SET.

Solution

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.

References


Was this article helpful?

0 out of 0 found this helpful

You must sign in before voting on this article.

Want to talk about it? Head on over to our Community Forum!