Highlighted
Established Member..
Established Member..
2825 views

uCMDB Integration with SM 9.4 failed

Jump to solution

Hi Experts,

 

I am facing an issue while integrating uCMDB (10.21) with SM (9.4) via SM adapter.

 

I am getting following error in logs and please find the screenshot of failed jobs as well.

 

 

Failed running population. destID:SM DEV, Failed during query:SM Computer To Software With Composition, all queries:[SM Biz To Computer With Containment, SM Computer To Computer With Connects, SM Biz To Computer With Usage, SM Biz To Biz With Containment, SM Biz To Biz With Usage, SM Biz To Software With Containment, SM Biz To Software With Usage, SM Computer To Software With Composition],  finished queries:[SM Biz To Computer With Containment, SM Biz To Computer With Usage, SM Biz To Software With Usage, SM Biz To Software With Containment, SM Biz To Biz With Containment, SM Biz To Biz With Usage, SM Computer To Computer With Connects] ERROR:com.mercury.topaz.cmdb.shared.base.CmdbException: [ErrorCode [802] General Integration Error{SM DEV}]

appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [802] General Integration Error{SM DEV}]

CMDB Operation Internal Error: class com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.exception.AdapterAccessGeneralException : The Universal CMDB attribute "sm_id" of CI type "running_software" is mapped to an empty value, please check this mapping in XSLT file.If you didn't customize this field, this error is probably generated because the UCMDB enhancements CP wasn't properly installed on the SM server : operation Data Access Adapter Query: Retrieve Changed Data

                at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:160)

                at com.hp.ucmdb.dataAccess.manager.DataAccessAdapterManagerProbeImpl.executeOperation(DataAccessAdapterManagerProbeImpl.java:50)

                at com.hp.ucmdb.discovery.probe.agents.probemgr.adapters.DataAccessAdaptersFacade.invokeOperation(DataAccessAdaptersFacade.java:414)

                at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runChangesOnPopulateChangesAdapter(AdapterService.java:1262)

                at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueriesOnPopulateChangesAdapter(AdapterService.java:1102)

                at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueries(AdapterService.java:354)

                at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runDiscovery(AdapterService.java:198)

                at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.discover(AdapterService.java:149)

                at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter.launchTask(JobExecuter.java:1205)

                at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.launchAndIsProbeRestarting(JobExecuter.java:952)

                at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.executeTask(JobExecuter.java:868)

                at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.run(JobExecuter.java:728)

Caused by: appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [802] General Integration Error{SM DEV}]

CMDB Operation Internal Error: class com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.exception.AdapterAccessGeneralException : The Universal CMDB attribute "sm_id" of CI type "running_software" is mapped to an empty value, please check this mapping in XSLT file.If you didn't customize this field, this error is probably generated because the UCMDB enhancements CP wasn't properly installed on the SM server : operation Data Access Adapter Query: Retrieve Changed Data

                at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:113)

                at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:60)

                at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:227)

                at com.mercury.topaz.cmdb.shared.manage.operation.flow.OperationInFlowDefaultExecutor.execute(OperationInFlowDefaultExecutor.java:23)

                at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:158)

                ... 11 more

Caused by: com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.exception.AdapterAccessGeneralException: [ErrorCode [802] General Integration Error{SM DEV}]

The Universal CMDB attribute "sm_id" of CI type "running_software" is mapped to an empty value, please check this mapping in XSLT file.If you didn't customize this field, this error is probably generated because the UCMDB enhancements CP wasn't properly installed on the SM server

                at com.hp.ucmdb.dataAccess.exceptions.ExceptionConverter.createAdapterAccessGeneralException(ExceptionConverter.java:341)

                at com.hp.ucmdb.dataAccess.exceptions.ExceptionConverter.createAdapterAccessException(ExceptionConverter.java:175)

                at com.hp.ucmdb.dataAccess.exceptions.ExceptionConverter.createAdapterAccessException(ExceptionConverter.java:67)

                at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessAdapterOperation.createAdapterAccessException(AbstractDataAccessAdapterOperation.java:54)

                at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessAdapterOperation.doExecute(AbstractDataAccessAdapterOperation.java:39)

                at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractFrameworkOperation.commonExecute(AbstractFrameworkOperation.java:17)

                at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:87)

                ... 15 more

Caused by: java.lang.RuntimeException: The Universal CMDB attribute "sm_id" of CI type "running_software" is mapped to an empty value, please check this mapping in XSLT file.If you didn't customize this field, this error is probably generated because the UCMDB enhancements CP wasn't properly installed on the SM server

                at com.mercury.topaz.fcmdb.adapters.serviceDeskAdapter.population.PopChunkGetter.createExternalId(PopChunkGetter.java:518)

                at com.mercury.topaz.fcmdb.adapters.serviceDeskAdapter.population.PopChunkGetter.addOrDelCIToTopology(PopChunkGetter.java:601)

                at com.mercury.topaz.fcmdb.adapters.serviceDeskAdapter.population.PopChunkGetter.addOrDelCIToTopology(PopChunkGetter.java:644)

                at com.mercury.topaz.fcmdb.adapters.serviceDeskAdapter.population.PopChunkGetter.addOrDelCIsToTopology(PopChunkGetter.java:226)

                at com.mercury.topaz.fcmdb.adapters.serviceDeskAdapter.population.PopChunkGetter.getNextResultChunk(PopChunkGetter.java:188)

                at com.mercury.topaz.fcmdb.adapters.serviceDeskAdapter.ServiceDeskAdapter.getChanges(ServiceDeskAdapter.java:1375)

                at com.hp.ucmdb.dataAccess.operations.DataAccessAdapterQueryRetrieveChanges.getChangesResult(DataAccessAdapterQueryRetrieveChanges.java:46)

                at com.hp.ucmdb.dataAccess.operations.DataAccessAdapterQueryRetrieveChanges.doDataAccessQueryExecute(DataAccessAdapterQueryRetrieveChanges.java:38)

                at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessLifeCycleAdapterQuery.doLifeCycleExecute(AbstractDataAccessLifeCycleAdapterQuery.java:34)

                at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessLifeCycleAdapterOperation.doDataAccessExecute(AbstractDataAccessLifeCycleAdapterOperation.java:57)

                at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessAdapterOperation.dataAccessExecute(AbstractDataAccessAdapterOperation.java:59)

                at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessAdapterOperation.doExecute(AbstractDataAccessAdapterOperation.java:37)

                ... 17 more

 

 

 

 

Kindly provide a solution for the above issue,

 

0 Likes
1 Solution

Accepted Solutions
Highlighted
Established Member..
Established Member..

Re: uCMDB Integration with SM 9.4 failed

Jump to solution

Thanks for the solutions guys,

 

I have resolved the issue. those adapter were customized and during the upgrade the customized adapter got over written and hence we once again customized the adapter files in the new version and tried pushing one ci at a time and resolved the issue.

Thanks,

Sada

View solution in original post

0 Likes
5 Replies
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: uCMDB Integration with SM 9.4 failed

Jump to solution

Hi sadanandan.

You say you're integrating UCMDB 10.21 with SM 9.40.  Which SM adapter did you choose when you set up your integration point?  The ServiceManagerAdapter9.x or the ServiceManagerEnhancedAdapter9.x?  You should be using the Enhanced adapter for integrating with Service Manager 9.40 and above.

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: uCMDB Integration with SM 9.4 failed

Jump to solution

Hi

This error generally happens when running population because 'sm_id' attribute of CI in ucmdb is mapped to SM attribute which has empty value.

You have to check fields mapping in configuration file named 'cmdb_root_attributes_population.xslt'. Get the name of web service field which is mapped to 'sm_id' attribute. Check on SM side if this attribute has empty value or not.

If SM web service field is actually empty then you need to use another web service field to populate 'sm_id attribute'.

0 Likes
Highlighted
Established Member..
Established Member..

Re: uCMDB Integration with SM 9.4 failed

Jump to solution

Thanks for the solutions guys,

 

I have resolved the issue. those adapter were customized and during the upgrade the customized adapter got over written and hence we once again customized the adapter files in the new version and tried pushing one ci at a time and resolved the issue.

Thanks,

Sada

View solution in original post

0 Likes
Highlighted
New Member..
New Member..

Re: uCMDB Integration with SM 9.4 failed

Jump to solution

i had an error with integration ; it is about the queries

com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.exception.AdapterAccessGeneralException: [ErrorCode [7004] Integration [{0}]: Get Supported Queries has failed on PROBE[{1}]\r\n{2}{HP Service Manager, D1HSMDPXXPWV1}]
Data Store [HP Service Manager]: Get Supported Queries has failed on PROBE[D1HSMDPXXPWV1].

 

0 Likes
Highlighted
Visitor.

Re: uCMDB Integration with SM 9.4 failed

Jump to solution

Hi

 

Did you have any answer about the problem?

Ing. Systems
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.