If more characters are needed, we can increase this up to 4000 characters. To do this:
1: Stop Service Desk services.
2: In the schema.sch file, under Queued_Notify table, change the size of column ‘msg_body’ from 1000 to 4000.
3: In the ddict.sch file, under Queued_Notify table, change the size of column ‘msg_body’ from 1000 to 4000.
4: Execute the statements associated to the SQL Server that is integrated with your Service Desk.
Microsoft SQL Server:
Execute the below statement to increase the size of column.
ALTER TABLE not_que ALTER COLUMN msg_body nvarchar(4000)
Execute the below statements to change the type of column from nvarchar2 to nclob
ALTER TABLE not_que ADD (TMP_MSG_BODY NCLOB);
update not_que set TMP_MSG_BODY=MSG_BODY
ALTER TABLE not_que DROP COLUMN MSG_BODY;
ALTER TABLE not_que RENAME COLUMN TMP_MSG_BODY TO MSG_BODY;
5: Start Service Desk Services