Table 9. Troubleshooting Oracle Data Loader On Demand
|
|
|
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. |