DataLoader Error Handling

The following error messages may be displayed by DataLoader:

General Errors When Starting DataLoader

General Problems When Starting DataLoader
Error Message Explanation
Missing required parameter Loading parameter is missing
Input file is required No input file is specified
You must select a Target Service No target service is selected
Cannot write to file Problem with the instance scratch directory in the location where the input file will be placed
Database Error Problem with database connection
Failed to upload file Problem uploading the input file to the SFX server

Errors When Checking the Validity of the Input File Primary Key Value

Errors When Checking the Validity of the Input File Primary Key Value
Error Message Explanation
no found on line X Primary key is missing
  • Not a valid <PRIMARY_KEY> on line X
  • Not a valid <PRIMARY_KEY> (<primary_key_value> is not a valid value)
Checksum errors in ISSN and ISBN are allowed.
 Invalid primary key (according to definition of the attribute in config/ctx_attrib.config_)

Error When Checking Validity of Other Input File Values

Error When Checking Validity of Other Input File Values
Error Message Explanation
Column X is not a valid value for <INPUT_FILE_FIELD_NAME> ('<VALUE>' is not a valid value) Invalid non-primary key value. Can occur for ACTIVATION_STATUS, OBJECT_TYPE, and LANGUAGE fields.
  • ACTIVATION_STATUS – Only ACTIVE/INACTIVE/THRESHOLD are allowed values.
  • LANGUAGE – Only the three letter language codes defined in the standard are allowed values.

Error When Matching Primary Key from Input File with OBJECT_ID

Error When Matching Primary Key from Input File with OBJECT_ID
Error Message Explanation
No object with that <PRIMARY_KEY> found No corresponding object is found in the database.

Error When Updating or Deleting Portfolios

Error When Updating or Deleting Portfolios
Error Message Explanation
No portfolio with that <PRIMARY_KEY> found No object portfolio is found in the database.

Errors When Updating or Deleting Institute Activation Entries

Errors When Updating or Deleting Institute Activation Entries
Error Message Explanation
  • No institute entry found for <institute_name>
  • You can only load the 'ACTIVATION_STATUS' and 'THRESHOLD' columns when using institute/group
No institute entry is found in the database.

Errors When Adding Objects

Errors When Adding Objects
Error Message Explanation
Cannot add object with no attributes on line X Minimum required data for a new object is not provided. DataLoader checks that there is at least one attribute besides OBJECT_TYPE in the input file.

Errors When Updating or Deleting Objects

Errors When Updating or Deleting Objects
Error Message Explanation
No object with that <PRIMARY_KEY> found No object is found in the SFX database.
Failed to remove object: Cannot remove non-local Object The object is a global object.
Ignoring OBJECT_TYPE for non-local object The input file contains an OBJECT_TYPE value for a global object that cannot be updated.
Report Invalid row the title type MAIN- is missing The object is missing a TITLE.
Report Missing Key No OBJECT_TYPE found The object is missing an OBJECT_TYPE.
Report Invalid row 0003-0007 of type ISSN-PRINT duplicate to object id 954925377920 The ISSN already exists for a different object.
Report NotLocal 0003-0007 Cannot remove non-local Object An attempt was made to remove a global object.
Report Invalid row Object identifier_type ISBN does not match object type JOURNAL.ISBN 1509-0515 is not valid. The object has both an ISSN and an ISBN.
Report Invalid row ISBN 1596-9827 is not valid The ISBN of the object is in an incorrect format.
Report Invalid row the title type WRITING_SYSTEM-Hangul is missing. The CJK object is missing a required title of type Hangul.
Report Invalid row the title type WRITING_SYSTEM-Hanja is missing. The CJK object is missing a required title of type Hanja.
Report Invalid row the title type ROMANIZATION-Pinyin is missing The CJK object is missing a required title of type ROMANIZATION-Pinyin.