Bookshelf Home | Contents | Index | Search | PDF

Siebel Enterprise Integration Manager Administration Guide > Importing Data > Checking Import Results and Troubleshooting Failures >

Evaluating Import Processing Failures

---

EIM is designed to import large volumes of data. Most failures are caused by data errors. It is usually faster and easier to correct the data errors and resubmit the corrected rows as part of a subsequent batch than to reprocess an entire batch. EIM does not stop when failures occur.

Failures can occur at several steps during the EIM Import Process; each type of failure has a different cause:

• Step 4 Failures. Step 4 processes foreign keys and bounded picklists.A row fails this step if the foreign key developed from values in the EIM table columns does not correspond to an existing row in the target Siebel database table. For example, a Step 4 failure on ACCNT_NAME indicates that the value in the ACCNT_NAME column of that row did not correspond to an existing name (S_ORG_EXT.NAME) or synonym name (S_ORG_SYN.NAME).
• Step 6 Failures. Step 6 failures generally indicate invalid user key values. For example, a contact with a NULL value for the LAST_NAME column will fail because this is a required user key. All user keys are required except MID_NAME for contacts (S_CONTACT.MID_NAME) and LOC (location) for accounts (S_ORG_EXT.LOC).
• Step 7 Failures. Step 7 evaluates the foreign key relative to the data being imported (whereas Step 4 evaluates it relative to existing data). If the foreign key references a table that is imported from the same EIM table, Step 7 resolves foreign keys into the data to be imported.
• Step 8 and Step 9 Failures. Failures for Step 8 and Step 9 indicate columns that have NULL values for fields that are required but are not part of the user key.

None of the other steps produce failures, although any step can encounter an SQL error that might halt processing. EIM imports data on a best-effort basis, loading any records it can and ignoring records that have failed.

For more information on troubleshooting import processes, see Process Failures.

Bookshelf Home | Contents | Index | Search | PDF