Data Import Errors & Warnings

See the information below for help troubleshooting errors and warnings that occur when importing data into CDB via FTP.

Errors

You must resolve all errors before CDB can import your data. See the Actions column in the table below for details about how to resolve each error.

Error No.	Type	Message	Explanation	Actions
G-001	Global	Package could not be imported	Data Workbench was not able to import the package. This error accompanies any Package- and File-type errors.	Resolve all Package- and File-type errors and re-import.
L-001	Load	Package could not be loaded	During the import process, Workbench was unable to load the data due to a system issue.	Re-import your package.
P-001	Package	Manifest file could not be read	The manifest file for your package is missing, is not structured correctly, does not have the correct File.Name, or is empty.	Correct your manifest file and re-import. Learn how to create a manifest file.
P-002	Package	Study `Study.Name` could not be found	The `study` value provided in the manifest file did not match any Study record in Data Workbench.	Correct the `study` in your manifest file and re-import.
P-003	Package	Source value not provided	The manifest file didn’t provide a `source`.	Add a `source` to your manifest file and re-import.
P-004	Package	User does not have access to study	You don’t have access to the Study you’re attempting to import data into.	Contact your organization’s user administrator or your Veeva Services representative to request access to the study. Correct the name of the `study` in your manifest file and re-import.
P-005	Package	Study not specified	Your manifest file is either missing the `study` object or didn’t include a value for `study`.	Add the `study` object to your manifest file and re-import.
F-001	File	File could not be found: `File.Name`	Workbench couldn’t find the file in your ZIP package.	Add the missing CSV file to your ZIP package. Update the manifest file to refer to the correct file.
F-002	File	Additional file `File.Name` detected and not processed	Your ZIP package contains a file (CSV or otherwise) that is not described in your manifest file.	Remove the file from your ZIP package and re-import. Describe the CSV file in your manifest file and re-import.
F-003	File	Required column mapping for `element` not found. Required column mappings for `element, element…` not found	One or more of your files doesn’t have an object for a required column mapping in your manifest file, or that object isn’t correctly formatted.	Add or correct the missing column mappings in your manifest file and re-import.
F-004	File	File `File.Name` could not be processed: Required column mapping [column] not found.	Workbench could not match the column mapping in your manifest file to the columns in the CSV.	Update the column mapping in your manifest file and re-import. Update the column name in the CSV file and re-import.
F-005	File	File `File.Name` could not be processed: Duplicate column names detected	Your CSV file has at least two (2) columns with the same name. For example, the Form uses the same Item twice in a single Item Group.	Rename one of the duplicate columns in your CSV file and re-import. Remove the duplicate columns in your CSV file and re-import.
F-006	File	Form file name `File.Name.csv` is invalid	Your CSV file’s name is invalid.	Rename your CSV file, update your manifest file to reference the new file name, and re-import.
F-007	File	File with no name will be ignored	A file in your package doesn’t have a file name.	Remove the unnamed file from your package and re-import.
D-001	Data	`File.Name` - `Row`: Study `value` not found	The value provided for Study doesn’t match the Name of the Study from the manifest file.	Correct the `study` value in your CSV file and re-import. Correct the `study` value in your manifest file and re-import.
D-002	Data	`File.Name` - `Row`: Site `value` not found	The value provided for `site` doesn’t match the Name (Site Number) of a Site that exists for this study in Vault EDC.	Correct the `site` value in your CSV file and re-import.
D-003	Data	`File.Name` - `Row`: Subject `value` not found	The value provided for `subject` doesn’t match the Name (Subject ID) of a Subject in Vault EDC.	Correct the `subject` value in your CSV file and re-import.
D-004	Data	`File.Name` - `Row`: Event `value` not found for Subject `value`	The Event Definition specified exists, but the Event hasn’t been added to the subject’s Casebook.	Correct the `event` value in your CSV file and re-import.
D-005	Data	Value `value` for column `column` is invalid, and will be ignored	Workbench couldn’t read the column value provided.	Update the column’s value and re-import.
D-006	Data	`File.Name` - `Row`: Number of row cells do not match number of columns	The row in your CSV file has more cells than there are columns.	Remove the extra cells from your CSV file and re-import. Add columns to your CSV file to appropriately capture the data and re-import.
D-007	Data	Item configs on form `Form` with a blank/missing name were ignored	One or more keys for an item’s `config` in your manifest file are blank (“”).	Update your manifest file with values for the blank keys and re-import.
D-008	Data	Item config `Item` on form `Form` is missing its type, and will be ignored	The Item is missing the `type` object in your manifest file.	Update your manifest file with a `type` for the Item and re-import.
D-009	Data	Item config `Item` on form `Form` is of an invalid format, and will be ignored	Your item’s configuration can only include strings and objects, not an array.	Update your Item `config` in your manifest file and re-import.
D-013	Data	Item config `Item` on form `Form` has invalid type `type`, and will be ignored.	The `type` provided for the Item is not supported in Data Workbench.	Update the `type` for the Item in your manifest file and re-import.
D-016	Data	Missing value for mapped column `Site`	The `site` column doesn’t have a value.	Update the `site` value.
D-024	Data	Multiple subjects exist in Site `Site Number` with name `Subject`	There is more than one Subject at the chosen Site that matches the Subject provided in the CSV file.	Update the `subject` value in your CSV file so that it is unique within the site and re-import.
D-025	Data	Duplicate, unequal item config `Item name` found on forms `forms`	An Item exists on more than one Form, but the item’s definition parameters are different for each Form.	Correct your manifest file and re-import.
D-027	Data	`key` has an invalid value `value`	The value you provided for this configuration is invalid.	Update the manifest file to use a valid confiugration.
D-028	Data	`key` cannot specify > [1] value(s)	The value you provided for this configuration can’t have more than 1 value.	Update the manifest file to use a valid configuration.
R-001	Reference	`related` value not provided	The manifest file didn’t provide the `related` property.	Add the `related` property to your manifest file and re-import.
R-002	Reference	`related_item` value not provided	The manifest file didn’t provide the `related_item` property in the `related` array.	Add the `related_item` property into your `related_array` in the manifest file and re-import.
R-003	Reference	`related_key` value not provided	The manifest file didn’t provide the `related_key` property in the `related array.	Add the `related_item` property into your `related_array` in the manifest file and re-import.
R-004	Reference	Incorrect number of items in the property `related`	The `related` property must have at least 1, but no more than 4, `related_item` and `related_key` pairs.	Adjust your `related` property to have at least 1, but no more than 4, `related_item` and `related_key` pairs.
R-005	Reference	Data Type mismatch between `related_item` and `related_key`	The data types for `related_item` and `related_key` don’t match. These must have the same data type.	Update the data type for `related_item` or `related_key`, so that their data types match, and re-import.
R-006	Reference	File `File.Name` could not be processed: Duplicate column names detected	The reference data CSV file has at least 2 columns with the same name (column header).	Rename the duplicate columns in your CSV file and re-import. Remove the duplicate columns in your CSV file and re-import.
R-007	Reference	Duplicate value for the property related_form	The form Name, as represented by the `related_form` property, is present across more than one Source.	Add the Source name to the `related_form` property in your manifest file and re-import.
R-008	Reference	Number of items are more than 10	The manifest file can only list up to 10 Items.	Reduce the number of Items in the reference object to be less than 10 and re-import.
R-009	Reference	Incorrect data type	The manifest file has an Item with an unsupported data type (float, time, and boolean). Reference objects only support the following data types: text, int, date, and datetime.	Modify the Items to use a supported data type and re-import. Remove the unsupported Items and re-import.
R-010	Reference	Duplicate values for `related_key`	The combination of defined keys for a reference object must be unique.	Adjust the defined keys to be unique and re-import.
R-011	Reference	Form is not present	The Form specified by the `related_form` property doesn’t exist in the Source. The related Form must either already exist in CDB or be included in the same import package as the reference object.	Correct the `related_form` property to point to an existing Form and re-import. Add the Form to the import manifest and include its data CSV in the import package.

Warnings

While CDB does not require you to resolve every warning before importing your data, Workbench may ignore certain Items and exclude them from import. Warnings that cause data to be ignored are marked with an asterisk (*). See the Actions column in the table below for details about how to resolve each error.

Warning No.	Type	Message	Explanation	Actions
F-008	File	Config [sequence] will be deprecated in [20R1]. Updated manifest file touse [formsequence]	Your manifest file uses the sequence configuration, which was deprecated in the 20R1 (April 2020) release.	Update your manifest file to use formsequence instead.
D-010*	Data	Field `field` of item `item` on form `form` is unknown, and will be ignored	While you can include as many fields as you’d like for item configuration in addition to those required, Data Workbench ignores these fields.	No action required. You can choose to remove these fields, but it doesn’t prevent import to leave them.
D-011*	Data	Value `value` for field `field` on item `item` on form `form` is invalid, and will be ignored	The field’s value is intended to be numeric, but Workbench can’t interpret it as a number.	Update the value and re-import.
D-012	Data	Value `value` for field `field` on item `item` on form `form` does not match format pattern `pattern`, and will be ignored	The value provided in the CSV doesn’t match the configured format pattern for the Item (for Items with the Date, Time, and DateTime data types).	Update the value to use the appropriate format pattern and re-import.
D-014	Data	Item config `item` on form `form` has an invalid pattern `pattern`. Valid patterns include `patterns`.	The Date, Time, or DateTime format you provided in the Item configuration is not supported by Data Workbench.	Update the Item configuration to use a supported format, as well as the values in the form’s CSV file, and re-import. See a list of supported formats here.
D-015	Data	Duplicate data row ignored	The CSV file contains duplicate rows, based on the keys defined in the manifest file to uniquely identify a row. By default, uniqueness is defined by Study, Site, Subject, and Event.	Remove the duplicate rows in the data file. Update the maniefst file so that additional keys are used to uniquely identify a row.
D-017*	Data	Value `value` for item `item` exceeds maximum allowed length `length`, and will be ignored	The value provided in the CSV is longer than the maximum allowable length specified in the Item configuration (for Items with the Text data type).	Update the value and re-import.
D-018*	Data	Value `value` for item `item` exceeds minimum allowed value `min`, and will be ignored	The value provided in the CSV is less than the minimum allowed value specified in the Item configuration (for Items with the Integer and Float data types).	Update the value and re-import.
D-019*	Data	Value `value` for item `item` exceeds maximum allowed value `max`, and will be ignored	The value provided in the CSV is greater than the maximum allowed value specified in the Item configuration (for Items with the Integer and Float data types).	Update the value and re-import.
D-020*	Data	Value `value` for item `item` is invalid, and will be ignored	Data Workbench can’t interpret the value provided in the CSV file as the data type configured for the Item. Data Workbench ignored this value during import.	Update the value and re-import.
D-021	Data	Value `value` for item `item` is invalid; default `default` will be used in its stead	Data Workbench can’t interpret the value provided in the CSV file as the data type configured for the Item. Instead, Data Workbench imported the configured default value.	Update the value and re-import to use your value and not the default.
D-022*	Data	Item config `itemName` precision `precision` is greater than length `length`; both will be ignored	Your float-type Item confiugration has a Precision that is greater than the Length. Data Workbench ignores both and uses the default.	Update the `precision` or the `length` in the Item’s `config` and re-import.
D-023*	Data	Item config `itemName` has a minimum `min` that is greater than its maximum `max`; the minimum will be ignored	Your number- or integer-type item configuration has a Minimum Value (`min`) that is greater than the Maximum Value (`max`). Data Workbench ignroes the Minimum Value.	Update the `min` or `max` in the Item’s `config` and re-import.

* This warning results in data or configuration being ignored during import.