Authentication Error

Your account does not have the right privileges.

Check the following conditions, and resolve them if necessary:

• Make sure that your login name and password are specified correctly.
• Make sure your account has the Admin Import privilege.
• Make sure your account has the Enable Web Services Access privilege and that you are impersonating an administrator.
• Make sure you are not using SSO credentials. Oracle Data Loader On Demand does not support SSO authentication.

Import fails

The import process cannot find the owner of a record.

Check the following conditions, and resolve them if necessary:

• Make sure that the owner record exists in Oracle CRM On Demand.
• Make sure that the data file contains the user sign-in ID for owners.

Picklist not populated

Picklist values are not found.

Check the following conditions, and resolve them if necessary:

• Make sure the picklist values exist in Oracle CRM On Demand.
• Make sure the picklist values match exactly the values in Oracle CRM On Demand.
• Check the case of the picklist values. Picklist values are case sensitive.
• Make sure picklist values in Oracle CRM On Demand have neither leading nor trailing blank spaces.
• Check if cascading picklists rules are affecting the picklist values available.

Records not imported

The import process cannot find your associated records.

Check the following conditions, and resolve them if necessary:

• Make sure that associated records exist in Oracle CRM On Demand before the import process starts.
• Make sure that associated record values match exactly the value in Oracle CRM On Demand.
• Check all entries for proper case. Entries are case sensitive.
• Make sure the associated record names in Oracle CRM On Demand have neither leading nor trailing blank spaces.

The downloaded ZIP file for Oracle Data Loader On Demand is unusable

Corrupted or damaged ZIP file.

Either restart your browser, or try a different supported browser such as FireFox.

If you are using Internet Explorer, change the following setting: Internet Options, Advanced tab, clear the check box for Use HTTP 1.1.

Validation failed error

The operating system cannot create a required file.

Check the following conditions, and resolve them if necessary:

• Do not use forward slashes (/) in path names. For example, use d:\temp instead of d:/temp.
• Use either the full path with backslashes (\) or put the CSV and map files in the same folder as the JAR file.
• If you have the CSV and map files in a subdirectory, then include the name of subdirectory as well. For example, if your JAR file is in d:\dl and your data and map files are in a subdirectory called data, then specify the path to be data\myFile.csv or d:\dl\data\myFile.csv.

You receive the following message when submitting an import job:

"Processing this request will exceed your current storage allotment, therefore your request cannot be processed. Please reduce the number of records and try again or contact your Company Administrator."

Your storage allotment is almost full.

To reduce the allotment usage you can delete data you no longer need. To purchase additional capacity or licenses, contact your sales representative.

You receive the following message:

"String index out of range: -1"

A required field is blank, possibly the first field in a record.

Make sure all required fields have valid data. If there legitimately is no data for a field, enter a blank by using a pair of quotation marks.