IBM Support

Information Server Quality Stage Match Rule Failure "ORA-01400: cannot insert NULL into..."

Technote (troubleshooting)


Quality Stage Match rule set pass fails with the following error:

<APT_CombinedOperatorController(0),0> [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]ORA-01400: cannot insert NULL into ("QS_MATCH"."PASS_1_RESULTS_DATA"."DATACOL0006")

Resolving the problem

The error is caused by the interaction of two conditions:

  1. The fact that Oracle stores null values in place of null strings.
  2. A defect in the Quality Stage server which causes "not nullable" constraints to be incorrectly assigned to unbounded, "nullable" columns.

These conflicting conditions then trigger the reported error. The Quality Stage server issue is resolved in the IS 8.5 release.

To work around this issue, please do the following:

  1. Ensure that every unbounded column in the job leading to and including datasets used for the Match Designer input has a column length.
  2. Re-compile and run job.
  3. Import new table definitions in Match Designer.
  4. Update Test Environment.
  5. Save spec and passes.
  6. Re-run passes.

Document information

More support for: InfoSphere QualityStage

Software version: 8.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1591597

Modified date: 04 February 2016

Translate this page: