IBM Support

DataStage Netezza Connector stage returns an error "Field cannot contain null values"

Troubleshooting


Problem

An IBM InfoSphere DataStage job with the Netezza Connector stage has a fatal error: [SQLCODE=HY000][Native=46] ERROR: Column : Field cannot contain null values

Symptom

Error message Reason: [SQLCODE=HY000][Native=46] ERROR: Column : Field cannot contain
null values

Cause

A target Netezza table has a field defined as "not null with default" that is excluded from the Insert statement and Schema reconciliation options have not been set properly.

Diagnosing The Problem

Review the Netezza table definition for fields with "not null with default "

Resolving The Problem

In the Netezza Connector Stage properties, under Session->Schema Reconciliation set the following:

Unmatched link column action: Drop
Type mismatch action: Drop
Unmatched table column action: Ignore all
Mismatch reporting action: Info

Here is a example


Related Information

Troubleshooting Netezza Connector

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;8.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21634922

Page Feedback