Reaction on SP Monitor disappears when typing more than 4096 characters.
Article ID: 87081
Updated On:
Products
CA Automic Sysload
Issue/Introduction
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.
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
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.
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
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
N/A
Feedback
Yes
No
Powered by
