Import Rule fails to set or removes Asset Owner or Cost Center
| Article:TECH170991 | | | Created: 2011-10-03 | | | Updated: 2012-11-06 | | | Article URL http://www.symantec.com/docs/TECH170991 |
Problem
When a Data Connector Import Rule is used that is expected to set the Asset Owner and/or the Cost Center for a resource, it fails to do so or it removes the prior values. This was found by editing an imported/updated resource or by reviewing Configuration Item reports that show this data.
Error
Various or none. For example:
Row x skipped for data class 'Ownership Details'. No value has been specified for non nullable destination column 'Ownership Percentage' and there is no existing value for this column in the NS database for this resource.
Cause
Both "issues" are working as designed.
If the Asset User or Cost Center is not being set, the Import Rule is not setting both the Ownership Details/Cost Center Ownership data classes and the Asset User Owners/Cost Center association.
If the ownership is later disappearing, when the CMDB task Clean Ownership next runs, this will attempt to match both the data class and association. If there are not values for both, partial asset owner settings are removed from the affected resources.
Solution
Ensure that the correct data class and association are made for Users and Cost Centers. Figure 1 displays which to add for each type.
Figure 1: Example of how to fully configure User and Cost Center associations to a resource.

For Users (highlighted in red):
- Add and assign the data class mapping of Ownership Details, which includes the Owner and Ownership Percentage. Tip: The Ownership Percentage must be provided and cannot be blank (null). This can either be done via the data file or manually in the Import Rule by setting the Source to <Value> = 100.
- Add and assign the association mapping of Asset User Owners.
- To add these:
1. Click on "Select data classes".
2. Click on the Group drop down list to expand it.
3. Click on the CMDB Data Classes parent folder. Tip: This folder will be used, not those folders under it. Each folder contains its own data classes, along with possibly sub-folders that have their own. Figure 2 displays this.
4. Click on Ownership Details.
5. Click on the ">" button to add Ownership Details to the "Selected items" list.
6. Click on the OK button.
Figure 2: Click on the "CMDB Data Classes" folder to see its specific data classes, and also any sub-folders.

7. Click on "Select associations".
8. Click on the Group drop down list to expand it.
9. Click on the "CMDB Association Types" parent folder. Tip: As with step 3, this is from this folder, not those under it.
10. Click on Asset User Owners.
11. Click on the ">" button to add Asset User Owners to the "Selected items" list.
12. Click on the OK button.
13. These steps have now added the Ownership Details: Owner and Ownership Percentage data classes and the Asset User Owner association.
For Cost Centers (highlighted in blue):
- Add and assign the data class mapping of Cost Center Ownership, which includes the Owner and Ownership Percentage. Tip: The Ownership Percentage must be provided and cannot be blank (null). This can either be done via the data file or manually in the Import Rule by setting the Source to <Value> = 100.
- Add and assign the association mapping of Cost Center.
- To add these:
1. Click on "Select data classes".
2. Click on the Group drop down list to expand it.
3. Click on the CMDB Data Classes parent folder. Tip: This works like the above instruction's steps 3 and 9.
4. Click on Cost Center Ownership.
5. Click on the ">" button to add Cost Center Ownership to the "Selected items" list.
6. Click on the OK button.
7. Click on "Select associations".
8. Click on the Group drop down list to expand it.
9. Click on the "CMDB Association Types" parent folder. Tip: This works like the above instruction's steps 3 and 9.
10. Click on Cost Center.
11. Click on the ">" button to add Cost Center to the "Selected items" list.
12. Click on the OK button.
13. These steps have now added the Cost Center Ownership: Owner and Ownership Percentage data classes and the Cost Center association.
Note: If the resource type does not include the expected data classes and associations, such as if a custom resource is used and it was not based off of a resource that has these (such as just "Resource" for the base type), these may not appear and the user may need to manually add them to the custom resource type before they can then be referenced in an Import Rule.
Related Article
How to import data using a Data Connector Import Rule
http://www.symantec.com/business/support/index?page=content&id=HOWTO79380
How to troubleshoot import issues when using a Data Connector Import Rule
http://www.symantec.com/business/support/index?page=content&id=TECH195835
|
|
Article URL http://www.symantec.com/docs/TECH170991
Terms of use for this information are found in Legal Notices









Thank you.