On Sp Portal the data collection task can not be saved when selecting manually a large number of servers.

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

Error Message :
A popup Error (refer to the attachment):
Errors have occured. Write failed.

On sldppcoll.log:
##########################
02-May-2012 08:37:42] sldf_admin_tasks.php [371]: odbc_mssql error: [22001: [Microsoft][SQL Native Client][SQL Server]String or binary data would be truncated.] in EXECUTE("INSERT INTO sld_admin_tasks_params ....
#########################

Patch level detected:Sysload Portal 4.00
Product Version: Sysload 5.7.0

Description :On Sp Portal the data collection task can not be saved when selecting manually a large number of servers.
Environment:
OS: Windows Server 2008
OS Version: Win 2008 R2
Cause:
Cause type:
Defect
Root Cause: The database schema has not been upgraded correctly after a SP Portal upgrade:The impacted colums are:
Resolution:
As a Workaround:
Modify on SQL Server Studio the length of the colums following this procedure:

- Stop the two SP Portal services
- Login on the MS SQL Management Studio as Administrator
- Execute this query:
########################
USE spp_db
GO
ALTER TABLE sld_admin_log ALTER COLUMN sld_object_detail VARCHAR(4000)
GO
ALTER TABLE sld_admin_tasks_params ALTER COLUMN sld_param_value VARCHAR(4000)
GO
#########################

- Restart the SP Portal services

Fix Status: Released

Fix Version(s):
Component: Portal
Version: Sysload 5.7.0
Additional Information:
Workaround :
N/A