CCA SDM Integration job fails to find MDR name

Products

• CA Configuration Automation
• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

The configuration and integration of CCA with SDM to export CIs from the CCA database to the SDM CMDB
failed when running a SDM Integration job in CCA server with the error:

cca.log:
======
...
INFO  [pool-5-thread-2] com.ca.acm.integration.sdm.SDMCI (SDMCI.java:167) - Run GRLoader started
INFO  [pool-5-thread-1] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:304) - Not found: MDR name(name.domain.local) MDR class(CCA r12.8)
INFO  [pool-5-thread-1] com.ca.CMDB.GRLoader.grReader (grReader.java:188) - Processing Relationships
INFO  [pool-5-thread-1] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:304) -  
INFO  [pool-5-thread-1] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:304) - Results:
INFO  [pool-5-thread-1] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:304) -                Read   Skipped   Inserts   Updates    Errors  Warnings
INFO  [pool-5-thread-1] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:304) - CI                1         0         0         0         1         0
INFO  [pool-5-thread-1] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:304) - Relation          0         0         0         0         0         0
INFO  [pool-5-thread-1] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:304) - 
INFO  [pool-5-thread-1] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:858) - ===============================================================================
INFO  [pool-5-thread-1] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:304) - GRLoader completed with errors.
INFO  [pool-5-thread-1] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:860) - ===============================================================================
INFO  [pool-5-thread-1] com.ca.acm.integration.sdm.SDMCI (SDMCI.java:169) - Run GRLoader started finished
INFO  [pool-5-thread-1] com.ca.acm.integration.sdm.SDMCI (SDMCI.java:172) - Process Result started
INFO  [pool-5-thread-2] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:493) - ===============================================================================
INFO  [pool-5-thread-2] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:494) - GRLoader Started - load from xml file(<path to XML file>) - to CMDB - CI Updates allowed / inserts allowed
INFO  [pool-5-thread-2] com.ca.CMDB.GRLoader.GRLoader (GRLoader.java:510) - ===============================================================================
DEBUG [pool-5-thread-1] com.ca.acm.common.util.ACMSQLEvaluator (ACMSQLEvaluator.java:53) - 
COT --> Following SQL has been identified as candidate for violation: 
UPDATE acm_sdm_ci_expt_status WITH (ROWLOCK)  SET msg = ?, ci_uuid = ?, ci_typ = ?, ci_name = ?, expt_tm = ?, ci_expt_status = ? WHERE ci_name = '<ci name>'
values: 
[ERROR: Not found: MDR name(name.domain.local) MDR class(CCA r12.8)]

Environment

Configuration Automation: 12.9

Service Desk: 17.3

Cause

The MDR Name FQDN in Service Desk MDR Definition was set with the wrong character case.

 

 

 

Resolution

Change the MDR Name to same character case.

Example:

NAME.domain.local --> name.domain.local

Restart the SDM and CCA services.