APM-SAM: The initial data load to sync CA Asset Portfolio Management to CA Software Asset Manager errors when importing contacts

book

Article ID: 5163

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

After performing the initial data load to sync data from CA Asset Portfolio Management (APM) to CA Software Asset Manager (SAM), the import in SAM fails with the following error:  invalid reference in field import_data_source_id.

"<contact_uuid>";"CASAM";"System_MA_User";"";"";"";"";"System_MA_User";"";"";"1";"0";"";"";"";"User for Asset Management and Software Delivery Integration";"insert";"error";"Invalid reference in field ""import_data_source_id"".";"ASP-I2" 

The import data_source_id mentioned in the error is the second column - "CASAM"

Cause

The data source named CASAM does not exist in CA Software Asset Manager. 

Environment

CA Asset Portfolio Management 14.x
CA Software Asset Manager, 3.x or 4.x

Resolution

Add the CASAM data source in SAM: 



1.  Login to CA Software Asset Manager as a user in an administrative role



2.  Navigate to Admin -> Master Data -> System -> Data Sources



3.  Click the + icon to add a new data source



NOTE:  The source key and import ID are required (see the * next to the label) and are usually the same




Make sure the above data source name "CASAM" is entered exactly as shown.

4.  After saving the new data source, execute the attached cleanup script in SQL Server to enable the 'initial data load' from APM to be run a second time. 

Attachments

1558686732658000005163_sktwi1f5rjvs16f22.png get_app
1558533877062SAM_Cleanup_script_MsSql_-_14.1.zip get_app