Reaction on SP Monitor disappears when typing more than 4096 characters.

Document ID : KB000087081
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Affects Release version(s): 1

Error Message :
None

Patch level detected:Sysload Monitor 1.41
Product Version: Sysload 1.4.1

Description :Reaction on SP Monitor disappears when typing more than 4096 characters on Administration->Reaction->Send Email->Message body.
Environment:
OS: Windows Server 2008
OS Version: R2
Cause:
Cause type:
Configuration
Root Cause: When using MS SQL Server database with SP Monitor, we are not able to read the content of a column on the table when it has more than 4096 characters.
Resolution:
Stop both sp monitor services
Backup both php.ini files:
/spmhttpd/conf/php.ini
/spmphprt/php.ini

Then edit both files, adding this on the section MSSQL, this will allow to read up to 2GB of information

[MSSQL]
mssql.textlimit=2147483648
mssql.textsize=2147483648

Restart the services

Fix Status: No Fix

Additional Information:
Workaround :
N/A