We are trying to copy a row which has NULL value in column NamePrefixCode, in the table PTY_PARTY from source to target. The PTY_PARTY table has check constraint on column NamePrefixCode which will allow NULL or valid values from a reference table. While copying the data using portal 3.8 it works fine and NULL will be copied from source to target. In case of portal 4.2, the copy process is ignoring the NULL value and passing empty/spaces to target. Due to this, a SQL insert is failing and throws an error. The error is:
"Empty Sting N'' is a values by itself and it doesn’t mean NULL or not equivalent to NULL value."
From the Trace on the Database: