When using a Data Connector import rule, a foreign key is attempting to be set in the "Data class mappings" section. For example, the Ownership Details > Owner data class, for an Asset Owner. When the Import Rule is ran, the Asset Owner is not updated as expected.
The Update Mode of the data class is set incorrectly.
Ensure that the Update Mode for the data class is set correctly to enable it to update foreign keys. The Update Mode has three settings:
For example, the following error will occur if a foreign key is attempted to be used without the Update Mode set to Append:
Error: Row x skipped for data class 'Cost Items'. Multiple rows of data for the same resource is not allowed while using Update mode on a data class without key columns.
Solution: For multi rowed records, the Update Mode usually will need to be changed from Update to Append, to enable multiple updates to occur correctly.
Related Articles
Import Rule fails to set or removes Asset Owner or Cost Center
http://www.symantec.com/business/support/index?page=content&id=TECH170991
Data Connector Import Rule overwrites imported associations or reverse associations
http://www.symantec.com/business/support/index?page=content&id=TECH202757
Data Connector Import Rule overwrites old Cost Items with the new ones, or, re-adds the same Cost Items over and over
http://www.symantec.com/business/support/index?page=content&id=TECH199686
Error "Row x skipped for data class '<data class name>'. Data class foreign key lookup on column '<column name>' failed." occurs when using a Data Connector import rule that has a foreign key data class mapping
http://www.symantec.com/business/support/index?page=content&id=TECH164571
Error "Row x skipped for data class 'Identity'." occurs when using a Data Connector import rule to bring in resources with purchase order cost items
http://www.symantec.com/business/support/index?page=content&id=TECH166546
Error "Row x skipped from data class 'Cost Items'." occurs when using a Data Connector import rule to bring in resources with purchase order cost items
http://www.symantec.com/business/support/index?page=content&id=TECH166544
Data Connector Import Rule fails to create association mappings
http://www.symantec.com/business/support/index?page=content&id=TECH191367
How to troubleshoot import issues when using a Data Connector Import Rule
http://www.symantec.com/business/support/index?page=content&id=TECH195835