Bookshelf Home | Contents | Index | Search | PDF

Siebel Enterprise Integration Manager Administration Guide > EIM Error Messages > Error Message Solutions >

Mapping Errors

---

This section describes error messages that are caused by incorrect EIM mappings.

Error Message 205

Error 205: Missing Temporary Column for S_XX table from EIM_XX table

This error message indicates that EIM is unable to find the necessary processing columns (columns beginning with T_). Each EIM table has three processing columns at the EIM table level (T_DELETED_ROW_ID, T_EXPORTED_ROW_ID, and T_MERGED_ROW_ID), four processing columns for each table mapping (T_XXX_RID, T_XXX_EXS, T_XXX_STA, and T_XXX_UNQ), and one processing column for each foreign key mapping. Possible causes for this error message include:

• The processing column is not in the EIM table. In this case, you need to add the missing processing column and select it for the appropriate mapping.
• The processing column is in the EIM table, but not set correctly in the mapping. In this case, you need to select the processing column appropriately for the EIM table, table mapping, or foreign key.
• The processing column is in the EIM table and set correctly in the mapping, but the column's property is set incorrectly. For example, the User Name property of the processing column for a foreign key mapping needs to be set as [Table Name].[Foreign Key Column Name]. You can examine other EIM tables for examples of correct column property settings.

Bookshelf Home | Contents | Index | Search | PDF