About the Data Vault Message Reference
Data Definition Language Errors
Data Vault Repository Service Exit Codes
- Data Vault Repository Service Exit Codes
Load Balancer and Administration Errors
Data Vault Repository Administration CLI Errors
Data Vault SQL Tool Messages
- Data Vault SQL Tool Messages
Appendix A: Data Vault Loader Messages
- Data Vault Loader Messages Overview
- Messages and Prompts
- Load Operation Error Messages
  - 30101
  - 30102
  - 30103
  - 30104
  - 30105
  - 30106
  - 30107
  - 30108
  - 30109
  - 30110
  - 30111
  - 30112
  - 30113
  - 30114
  - 30115
  - 30116
  - 30117
  - 30118
  - 30119
  - 30120
  - 30121
  - 30122
  - 30123
  - 30126
  - 30127
  - 30128
  - 30129
  - 30130
  - 30131
  - 30132
  - 30136
  - 30138
  - 30139
  - 30140
  - 30141
  - 30142
  - 30143
  - 30144
  - 30145
  - 30146
  - 30147
  - 30148
  - 30149
  - 30150
  - 30151
  - 30152
  - 30153
  - 30154
  - 30155
  - 30156
  - 30157
  - 30158
  - 30159
  - 30160
  - 30161
  - 30162
  - 30163
  - 30164
  - 30165
  - 30166
  - 30167
  - 30169
  - 30170
  - 30171
  - 30172
  - 30173
  - 30175
  - 30176
  - 30177
  - 30178
  - 30179
  - 30181
  - 30180
- File Parsing Messages
  - 0001
  - 0002
  - 0003
  - 0006
  - 0007
  - 0008
  - 0009
  - 0010
  - 0011
  - 0013
  - 0014
  - 0015
  - 0016
  - 0017
  - 0018
  - 0018
  - 0019
  - 0020
  - 0021
  - 0022
  - 0023
  - 0024
  - 0024
  - 0025
  - 0026
  - 0027
  - 0028
  - 0028
  - 0028
  - 0028
  - 0029
  - 0030
  - 0031
  - 0032
  - 0033
  - 0034
  - 0035
  - 0035
  - 0036
  - 0037
  - 0038
  - 0039
  - 0040
  - 0041
  - 0041
  - 0041
  - 0048
  - 0049
  - 0050
  - 0051
  - 0052
  - 0053
  - 0054
  - 0055
  - 0056
  - 0057
  - 0058
  - 0059
  - 0061
  - 0062
  - 0063
  - 0064
  - 0065
  - 0066
  - 0067
  - 0068
  - 0069
  - 0070
  - 0071
  - 0072
  - 0080
  - 0083
  - 0084
  - 0096
  - 0097
  - 0098
  - 0099
  - 0100
  - 0101
  - 0102
  - 0103
  - 0104
  - 0105
  - 0112
  - 0113
  - 0114
  - 0115
  - 0116
  - 0117
  - 0118
  - 0119
  - 0120
  - 0121
  - 0122
  - 0123
  - 0124
  - 0125
  - 0126
  - 0127
  - 0128
  - 0129
  - 0130
  - 0131
  - 0132

Data Vault Message Reference

6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4

Back Next

22002

Data exception - null value not allowed

This message appears when an INSERT statement attempts to insert a null value into a column that participates in a PRIMARY KEY constraint, or on which a NOT NULL constraint is defined. None of the columns that are part of a primary key can have null values; while a NOT NULL constraint ensures that the column contains no null values.

that when loading into a table through the Data Vault Loader, omitting a NOT NULL column from the mapping section of the load specification script will always cause the operation to fail with this error. Since the column is omitted, the Data Vault Loader will attempt to load the column with default null values, which are disallowed because of the NOT NULL constraint.

Rename Saved Search

Table of Contents

Data Vault Message Reference

Data Vault Message Reference

22002

22002