Technote (troubleshooting)
Problem(Abstract)
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.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.