Information Server Quality Stage Match Rule Failure "ORA-01400: cannot insert NULL into..."
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:
- The fact that Oracle stores null values in place of null strings.
- 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:
- Ensure that every unbounded column in the job leading to and including datasets used for the Match Designer input has a column length.
- Re-compile and run job.
- Import new table definitions in Match Designer.
- Update Test Environment.
- Save spec and passes.
- Re-run passes.
More support for:
Software version: 8.1
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Reference #: 1591597
Modified date: 03 December 2012