2479754 - Load table failed due to 'Cannot be NULL' error. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2479754 - Load table failed due to 'Cannot be NULL' error.

Symptom

When executing a load table command, it failed due to an error below.
The flat file to be loaded contains zero-length string for a specific column and the column 'c2' below has NOT NULL property.

I. 05/26 13:47:47. 0000000013 TxnVer 4952538 4952539
I. 05/26 13:47:47. 0000000013 Exception Thrown from dflib/dfo_CheckConstraintFilter.cxx:495, Err# 322, tid 15 origtid 15
I. 05/26 13:47:47. 0000000013 O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -195, SQLState: '23502', Severity: 16
I. 05/26 13:47:47. 0000000013 [2126]: Column 'c2' in table 'jerry' cannot be NULL


Read more...

Environment

SAP IQ 15.x
SAP IQ 16.0

Product

SAP Sybase IQ 15.4

Keywords

SAP IQ, IQ, load table, non_ansi_null_varchar, dflib/dfo_CheckConstraintFilter , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.