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 |