1 of 1 people found this helpful
Please check below KB article. It is suggested to check that triggers at db level, those causing this error. Triggers were created at Database level to notify when a schema change -create/drop happens. Disabling triggers resolves the issue.
Here is the meaning and reason for the below ERROR.
When SET CONCAT_NULL_YIELDS_NULL is ON, concatenating a null value with a string yields a NULL result. For example, SELECT 'abc' + NULL yields NULL. When SET CONCAT_NULL_YIELDS_NULL is OFF, concatenating a null value with a string yields the string itself (the null value is treated as an empty string). For example, SELECT 'abc' + NULL yields abc.
So what you need to do it set the CONCAT_NULL_YEILDS_NULL to OFF and then create the form. Or you need to provide a defailt value for each field which is there on the form which is not possible as some fields are read only and gets populated by the remedy server only.
Hope that helps.
To check the current value of "CONCAT_NULL_YIELDS_NULL"
fire Select SESSIONPROPERTY('CONCAT_NULL_YIELDS_NULL') for your remedy db.
if it is 1 then below is the command to set/unset it.
Set CONCAT_NULL_YIELDS_NULL ON/OFF