ALERT: Datto Drive Cloud service will no longer be available as of July 1, 2019. For more information, see our end-of-life article. If you'd like to migrate your data to Datto Workplace, see our migration guide.
To learn how to download your Datto Drive Cloud data, please visit this article.

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? Have a feature request?

Head on over to our Community Forum or get live help.