User Guide > Troubleshooting > Attempt to insert null in field
Was this helpful?
Attempt to insert null in field
 
Error Code
56
Error Message
Attempt to insert null in field <FieldName>
Description
This error may be displayed when you try to insert a null value in a field. This error is usually displayed for connectors like ODBC 3.5 and Actian X.
Cause/Solution
 
Cause: Error is given when null value is not allowed in the target field.
You might face this error with connectors like Actian Vector, Actian X etc.
Solution: You need to allow null value for that target field:
1. Open the transformation.
2. Select the Mapping tab.
3. Click the “i” icon that corresponds to the field.
4. Set the Allow Null property to “Yes”.
5. Save the transformation and execute.
Related Information
How to resolve "Cannot update identity column 'id'" while updating records.
 
Last modified date: 02/09/2024